count unique values in a row

[Fazila]

Any idea how I can do this? The values in the row are text values not numeric.

Thanks

 

[MUKESHY12390]

=IF(COUNTIFS($A$1:A1,A1)=1,"Unique ","Duplicate")

Change raw details "A" to according to need,.

 

[Fazila]

thanks Mukeshy12390 is there anyway the formula can give me the number of different values in the row?

 

[Fazila]

Found a solution but thank you for looking at this. For anyone else who might want to know/future reference:

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">=SUMPRODUCT((A2:A100 <> "")/COUNTIF(A2:A100,A2:A100 & ""))</code>

 

[MUKESHY12390]

replace "Unique" with A1 that's all.

 

[Aladin Akyurek]

Any idea how I can do this? The values in the row are text values not numeric.

Thanks

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(1-(A2:Z2=""),MATCH(A2:Z2,A2:Z2,0)),COLUMN(A2:Z2)-COLUMN(A2)+1),1))