| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find repetive data and calculate
I have a Sheet 1, column A with random multiple items/data, some repeated.
In Sheet 2 Column A, I have a clean list with no repeats of those items. I need a formula that will identify how many times an item appears in Sheet 1 column A. Ex. if ABC123 appears 14 times in column A. I would like my output to show: ABC123, 14 Thanks, Ty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find repetive data and calculate
Use a Countif in Column B of Sheet 2 (this would be the formula for cell B1)
=COUNTIF(Sheet1!A:A,A1) -- If this helps, please remember to click yes. "Ty" wrote: I have a Sheet 1, column A with random multiple items/data, some repeated. In Sheet 2 Column A, I have a clean list with no repeats of those items. I need a formula that will identify how many times an item appears in Sheet 1 column A. Ex. if ABC123 appears 14 times in column A. I would like my output to show: ABC123, 14 Thanks, Ty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! Find Data in columns next to known data then Calculate | Excel Discussion (Misc queries) | |||
| very repetive formula needs looking at | Excel Discussion (Misc queries) | |||
| Repetive Formatting/Creating a Toolbar button | Excel Discussion (Misc queries) | |||
| Find and Calculate Function? | Excel Discussion (Misc queries) | |||
| find the same entries and calculate sum | Excel Worksheet Functions | |||
Linear Mode
