Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of textual values in a row
Hi everyone, I am getting a little confused...infact...I am really struggling.... What I am trying to do is count the number of textual values in a row (omitting any duplicates and counting them as one value)? For example. ABCD-1234 <<Blank Row ABCD-1234 ABCD-1234 <<Blank Row <<Blank Row ABCD-1235 CB1234567 ABCD-1236 ABCD-1236 In the above example, I would expect the result to be 4. Any help would be most appreciate, genuinely. Thanks, Steve (confused) -- c99sg1 ------------------------------------------------------------------------ c99sg1's Profile: http://www.excelforum.com/member.php...o&userid=36207 View this thread: http://www.excelforum.com/showthread...hreadid=559932 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of textual values in a row
=SUMPRODUCT((A2:A200<"")/COUNTIF(A2:A200,A2:A200&""))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "c99sg1" wrote in message ... Hi everyone, I am getting a little confused...infact...I am really struggling.... What I am trying to do is count the number of textual values in a row (omitting any duplicates and counting them as one value)? For example. ABCD-1234 <<Blank Row ABCD-1234 ABCD-1234 <<Blank Row <<Blank Row ABCD-1235 CB1234567 ABCD-1236 ABCD-1236 In the above example, I would expect the result to be 4. Any help would be most appreciate, genuinely. Thanks, Steve (confused) -- c99sg1 ------------------------------------------------------------------------ c99sg1's Profile: http://www.excelforum.com/member.php...o&userid=36207 View this thread: http://www.excelforum.com/showthread...hreadid=559932 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of values between plus signs in addition calc | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Count number of values in a cell | Excel Worksheet Functions |