Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Uniques in Column, put result in next blank cell andcontinue until last row
You could describe your problem better. An example
would probably help. Maybe the menu Data | Filter | Advanced Filter | Unique Records Only can get you started. Hth, Merjet |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Uniques in Column, put result in next blank cell andcontinue until last row
Let my try again.....for clarification:
Column A (now) A A A N N N N [blank cell] result should be "2" - keep going A A J L F F F [blank cell] result should be "4"- keep going until you get to the end of the spreadsheet. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count Uniques in Column, put result in next blank cell andcontinue until last row
On Jan 15, 11:43*am, merjet wrote:
You could describe your problem better. An example would probably help. Maybe the menu Data | Filter | Advanced Filter | Unique Records Only can get you started. Hth, Merjet A macro that does this: Let my try again.....for clarification: Column A (now) A A A N N N N [blank cell] result should be "2" - keep going A A J L F F F [blank cell] result should be "4"- keep going until you get to the end of the spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Uniques with a Couple Conditions | Excel Worksheet Functions | |||
count uniques anomaly | Excel Worksheet Functions | |||
Count blank cell in a column | Excel Programming | |||
Count Uniques within a list based on value of cell... | Excel Discussion (Misc queries) | |||
How to count uniques of a SUMPRODUCT subset? | Excel Worksheet Functions |