Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup help please
I have multiple pages that have 65,536 rows, same monsterous spreadsheet,
138-MEG and I need to lookup data from each and have a summary sheet accept the returned answers: Fleet Removal Date Install Date TSI CSI BMW 06/10/2008 06/10/2005 100:03 189 Ford 06/10/2008 06/10/2003 200:03 289 Chev 06/10/2008 06/10/2002 340:03 389 Olds 06/10/2008 06/10/2006 180:03 129 Suzu 06/10/2008 06/10/2007 50:03 89 Hond 06/10/2008 06/10/2001 1,100:03 1189 BMW 06/10/2008 06/10/2005 100:03 189 Ford 06/10/2008 06/10/2003 200:03 289 Chev 06/10/2008 06/10/2002 340:03 389 Olds 06/10/2008 06/10/2006 180:03 129 Suzu 06/10/2008 06/10/2007 50:03 89 Hond 06/10/2008 06/10/2001 1,100:03 1189 I need the return vlookup to get me all of the BMWs, then the Fords, etc., and just give me an end result of a count of how many of each, but I need the TSI and CSI fields to also add up and then average that by the like units: Fleet TSI CSI 76 BMW 7100:03 5,189 81 Ford 3200:03 3,289 66 Chev 4340:03 389 42 Olds 2180:03 429 21 Suzu 550:03 689 91 Hond 21,100:03 18,189 Can this be done? Thanks, Champ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup help please
I think it can be done, but I don't understand what you want. Your result
shown at the bottom has as the first column the numbers 76, 81, 66, 42, etc. What are those? There is no label. Also, how do you add up a "number" like 100:03 and 200:03. What are these #'s? Also your result table shows only sums, I assume. You want averages too, right? Is each tab (sheet) a separate summary? And I don't understand what has to be accepted? Please explain. "Champ" wrote: I have multiple pages that have 65,536 rows, same monsterous spreadsheet, 138-MEG and I need to lookup data from each and have a summary sheet accept the returned answers: Fleet Removal Date Install Date TSI CSI BMW 06/10/2008 06/10/2005 100:03 189 Ford 06/10/2008 06/10/2003 200:03 289 Chev 06/10/2008 06/10/2002 340:03 389 Olds 06/10/2008 06/10/2006 180:03 129 Suzu 06/10/2008 06/10/2007 50:03 89 Hond 06/10/2008 06/10/2001 1,100:03 1189 BMW 06/10/2008 06/10/2005 100:03 189 Ford 06/10/2008 06/10/2003 200:03 289 Chev 06/10/2008 06/10/2002 340:03 389 Olds 06/10/2008 06/10/2006 180:03 129 Suzu 06/10/2008 06/10/2007 50:03 89 Hond 06/10/2008 06/10/2001 1,100:03 1189 I need the return vlookup to get me all of the BMWs, then the Fords, etc., and just give me an end result of a count of how many of each, but I need the TSI and CSI fields to also add up and then average that by the like units: Fleet TSI CSI 76 BMW 7100:03 5,189 81 Ford 3200:03 3,289 66 Chev 4340:03 389 42 Olds 2180:03 429 21 Suzu 550:03 689 91 Hond 21,100:03 18,189 Can this be done? Thanks, Champ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |