| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup a value and count the number of associated occurences
I have 2 worksheets. I want to obtain the summary counts in worksheet 1 from
Worksheet 2. What formula should I use to poulate worksheet 1. Worksheet 1 2008 File counts by Lender and Month Lender Jan Feb Mar Aurora 3 2 4 BofA 6 7 8 CCM 8 9 5 Worksheet 2 Jan Aurora 1 Jan Aurora 1 Jan Aurora 1 Feb Aurora 1 Feb Aurora 1 Mar Aurora 1 Mar Aurora 1 Mar Aurora 1 Mar Aurora 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| How to count number of occurences of two different things at once? | Excel Worksheet Functions | |||
| count number of occurences on a particular date | Excel Worksheet Functions | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Threaded Mode
