| 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 | |||
Linear Mode
