| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Double lookup count
I am trying to make either a VBA automation or a formula to calculate the
below. The data is found in two columns and every time there is a match it need to increment the matrix table. The matrix will have about 100 columns and 200 rows, so it is rather large. And the data will have about 2-3000 records. Can anyone solve this challenge? Data: Column 1 Column 2 DK 1A UK 1A UK 2B BE 2A NL 2A DK 2B BE 2C DK 1B NL 2A DK 1A DK 1A UK 1A BE 2A Matrix: |1A |1B |1C |2A |2B |2C BE 2 1 DK 3 1 1 NL 2 UK 2 1 Many thanks, Rene |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup and count | Excel Discussion (Misc queries) | |||
| count and lookup | Excel Worksheet Functions | |||
| count data but avoid double entries | Excel Worksheet Functions | |||
| Double entry lookup | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
