| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of times a value is in another spreadsheet
Depends what you mean by 'spreadsheet'.
If you mean two worksheets in same workbook, then =COUNTIF(Sheet2!A:A,Sheet1!A1) If you mean sheets in different workbooks, then =COUNTIF('[test book.xls]Sheet1'!$A:$A,A1) and both book need to be open best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "klafert" wrote in message ... 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. |
| Reply |
| 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) | |||
Linear Mode
