| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTA Function
I have the following list. Column A has the below formula and column B
contains a list of Names ColumnA Column B 1 ABCD 2 EFGH 3 IJKL 4 MNOP "" MNOP 5 XYZ I am using the following in Column A =If(B1="","",counta(B$1:$B1)). This is copied all the way down Column B. What I need to achieve is that the formula in Column A will increment only for Unique Values of Column B. Therefore when we get to Rows 4 and 5 in Column B we only count the name MNOP only once. Row 6 for Name XYZ will show "5" and NOT "6" as I am getting now Thank you all/sgl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTA Function | Excel Worksheet Functions | |||
| Counta function | Excel Worksheet Functions | |||
| Output of the =IF(COUNTA) Function | Excel Worksheet Functions | |||
| Using the COUNTA function | Excel Discussion (Misc queries) | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Threaded Mode
