Sponsored Content
Full Discussion: Help for Excel
Top Forums UNIX for Dummies Questions & Answers Help for Excel Post 302651889 by blubiz2 on Wednesday 6th of June 2012 10:10:09 AM
Old 06-06-2012
Help for Excel

Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same.

Here is what I mean. I want to combine the same products into one row. While keeping the product number and per unit price the same while adding the quantity's together and updating the total cost. Also if possible indicate the number of different customers for the customer column.
Code:
  Customer .Product .Product Number.Quantity. Per Unit Price.Total  
   Bonnie / Clamp / 4216 / 13 / 5    =PRODUCT(D23,E23)   
   Bonnie  / TB / 1356  / 5  / 20  /  =PRODUCT(D26,E26)   
   Shawn /  Washers / 3212 / 15  /   0.2 /  =PRODUCT(D29,E29)   
   Bonnie  /  Washers / 3212 / 10 / 0.2 /  =PRODUCT(D30,E30)

So that this will look like...
Code:
  Bonnie /  Clamp /   4216 / 13 /  5 / =PRODUCT(D23,E23)   
  Bonnie / TB /  1356/. 5 / 20 / =PRODUCT(D26,E26)   
  2 / Washers / 3212 / 25 / 0.2  / =NEW PRoduct

Thanks a lot and any and all help will be greatly appreciated!

Moderator's Comments:
Mod Comment Please use next time code tags for your code and data

Last edited by blubiz2; 06-06-2012 at 11:26 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

excel

i am currently using a unix environment and will be constantly receiving documents in excel format(.xls) my question is is there any tools that will do auto convertion of data in the excel doc into .txt? ps.. my job are mainly for batch processing. thus it would be great if no manual work is... (2 Replies)
Discussion started by: swakoo
2 Replies

2. UNIX for Dummies Questions & Answers

Excel help

Folks; I'm writing a shell script to extract some field out of log file to a text file which i can convert/open in Excel sheet. I gave names to the fields like (Editor_name, Owner, etc..) to be in the top of the Excel sheet. When i open the file using Excel sheet i see these filed names fine on... (2 Replies)
Discussion started by: moe2266
2 Replies

3. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

4. Windows & DOS: Issues & Discussions

Excel manipulation

I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My... (1 Reply)
Discussion started by: dvrraju
1 Replies

5. Shell Programming and Scripting

Excel

I have file called abc.txt at /usr/abc.. Content of file is as below. mZ2|uM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2 oZ2|iM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2 pZ2|qM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2... (3 Replies)
Discussion started by: j_panky
3 Replies

6. Windows & DOS: Issues & Discussions

Excel

Hello, I have received very much needed help in the past from this forum and hope that someone can assist me once more. I am in the military and I am tracking classroom specific training for each one of our units per sailor in that unit. I am attaching the spreadsheet for your review. There are... (5 Replies)
Discussion started by: Maggiepie
5 Replies

7. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies

8. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
DFU-UTIL(1)						      General Commands Manual						       DFU-UTIL(1)

NAME
dfu-util - Device firmware update (DFU) USB programmer SYNOPSIS
dfu-util [-ldpciatUDRhvV] DESCRIPTION
dfu-util is a program that implements the host (computer) side of the USB DFU (Universal Serial Bus Device Firmware Upgrade) protocol. In the OpenMoko project (for example), this program is used to communicate with the specially enhanced u-boot boot loader, which implements the DFU device side. OPTIONS
-l, --list List the currently attached DFU capable USB devices. -d, --device VENDOR:PRODUCT Specify vendor/product ID of the DFU device. Both VENDOR and PRODUCT are hexadecimal numbers (no prefix needed). Example: $ dfu-util --device 1457:51ab If you only have one standards-compliant DFU device attached to your PC, this is optional. However, as soon as you have multiple DFU devices, dfu-util will detect this and abort, asking you to specify which device it shall use. -p, --path BUS-PORT. ... .PORT Specify the path to the DFU device. -c, --cfg CONFIG-NR Specify the configuration of the DFU device. -i, --intf INTF-NR Specify the DFU interface number. -a, --alt ALT Specify the altsetting of the DFU interface by name or by number. -t, --transfer-size Specify the number of bytes per USB transfer. If you don't supply this option, the maximum possible size for your combination of host OS and USB device is chosen (for optimal performance). -U, --upload FILE Read firmware from device into FILE. Note: Upload support is currently broken. -D, --download FILE Write firmware from FILE into device. -R, --reset Issue USB reset signalling once we are finished. -s, --dfuse-address Specify target address for raw binary download/upload on DfuSe devices. Do not use this for downloading DfuSe files. -h, --help Show a help text and exit. -v, --verbose Print more information about dfu-util's operation. A second -v will turn on verbose logging of USB requests. -V, --version Show version information and exit. EXAMPLES
Here are some examples for the usage of dfu-util in the OpenMoko project (working with the Neo1973 hardware): Flashing the rootfs: $ dfu-util -a rootfs -R -D /path/to/openmoko-devel-image.jffs2 Flashing the kernel: $ dfu-util -a kernel -R -D /path/to/uImage Flashing the bootloader: $ dfu-util -a u-boot -R -D /path/to/u-boot.bin Copying a kernel into RAM: $ dfu-util -a 0 -R -D /path/to/uImage Once this has finished, the kernel will be available at the default load address of 0x32000000 in Neo1973 RAM. Note: You cannot transfer more than 2MB of data into RAM using this method. BUGS
Please see http://wiki.openmoko.org/wiki/Dfu-util for some limitations and bugs in the current dfu-util code. Please report any further bugs at on the openmoko mailing list at openmoko@lists.openmoko.org. LICENCE
dfu-util is covered by the GNU General Public License (GPL), version 2 or later. AUTHORS
Weston Schmidt <weston_schmidt@yahoo.com> Harald Welte <hwelte@hmw-consulting.de> This manual page was written by Uwe Hermann <uwe@hermann-uwe.de>. It is licensed under the terms of the GNU GPL (version 2 or later). February 29, 2008 DFU-UTIL(1)
All times are GMT -4. The time now is 01:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy