| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Hi! Put this in C1 (assuming your list starts at A1 and B1): =countif(A1:A2000,B1) This will tell you how many times B1 appears in the range A1:A2000. Need I say more? If so, come back. Alf -- AlfD ------------------------------------------------------------------------ AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785 View this thread: http://www.excelforum.com/showthread...hreadid=355844 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find last row with data in it | Excel Discussion (Misc queries) | |||
| Excel2000: Data Validation to restrict entries | Excel Discussion (Misc queries) | |||
| How can I compare two lists of data (channel lineups) - find what. | Excel Worksheet Functions | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
