Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Lookups with some Calculations and Sum Frequencies
32,000 lines of data on my 'Master Sheet':
LOT# # PASSES LOCATION ==================================== (plus many more columns of stuff I'm not worried about now) There are 15,500 different lots. There are 12 different locations. Each lot is only in one location. BUT, there can be many passes for one lot. (SAMPLE DATA AT BOTTOM) I used (SUM(IF(FREQUENCY(LOT1:LOT32000,LOT1:LOT32000)0,1 ,) to calculate the 15,500. Here's what I'd like: LOCATION # (DISCRETE)LOTS IN LOCATION SUM # PASSES How? How how how? =======SAMPLE DATA=========== LOT #PASSES LOCATION 100 1 B 101 1 A 101 2 A 102 1 C 103 1 C OUTPUT LOCATION # (DISCRETE)LOTS IN LOCATION SUM # PASSES A 1 3 B 1 1 C 2 2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum multiple lookups? | Excel Worksheet Functions | |||
multiple column lookups | Excel Worksheet Functions | |||
Multiple V Lookups | Excel Worksheet Functions | |||
Multiple Lookups | Excel Discussion (Misc queries) | |||
multiple lookups - xls2003 | Excel Worksheet Functions |