| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count # of times a value is in another spreadsheet
I have 2 spreadsheets. One has entries like: (Spreadsheet 2)
A B C D 5456 Mary 1 4 5456 Mary 2 3 2312 Mary 3 4 2145 Joe 2 2 2345 Joe 2 4 2345 Joe 3 4 The other one has entries like: (Spreadsheet 1) A B 5456 Mary 2312 Mary 2145 Joe 2345 Joe I want to put a formula in Spreadsheet 1 to count how many times the values in Column A is in Spreadsheet 2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Value in an External Spreadsheet | Excel Discussion (Misc queries) | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Threaded Mode
