If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Matching
Hi, I need the new table to fill in automatically from the another table. A B C 1 FRUIT COLOR AMOUNT 2 apple green 100 3 apple green 150 4 orange yellow 100 5 orange yellow 200 6 apple red 175 E F G 1 FRUIT COLOR TOTAL AMOUNT 2 apple green 250 3 orange yellow 300 4 apple red 175 As I used VLOOKUP for col G but need your help on col E and F, which could auto fill in from A and B and without repeating. Thank you! |
#2
|
|||
|
|||
Matching
To summarize the data, you could build a pivot table from the first
table, with Fruit and Colour in the row area, and Amount in the data area. There are instructions and links for pivot tables on Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivotstart.htm wrote: Hi, I need the new table to fill in automatically from the another table. A B C 1 FRUIT COLOR AMOUNT 2 apple green 100 3 apple green 150 4 orange yellow 100 5 orange yellow 200 6 apple red 175 E F G 1 FRUIT COLOR TOTAL AMOUNT 2 apple green 250 3 orange yellow 300 4 apple red 175 As I used VLOOKUP for col G but need your help on col E and F, which could auto fill in from A and B and without repeating. Thank you! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Matching query | Lori | Running & Setting Up Queries | 1 | June 17th, 2004 12:13 AM |
Join with 2 matching fields | Andrew Black (delete obvious bit) | Running & Setting Up Queries | 2 | June 9th, 2004 08:37 PM |
Return multiple matching results (as an array?) | Paul | Worksheet Functions | 2 | May 14th, 2004 12:01 PM |
"Matching" column A's values in column B | Chris.F | Worksheet Functions | 0 | January 12th, 2004 02:24 PM |
Matching data to return value | Craig | Worksheet Functions | 3 | December 31st, 2003 05:37 PM |