Thread
:
Unique count of text
View Single Post
#
8
Ola
Posts: n/a
...if it should be 6...
Group Count:
=SUM(--(A1:A8&B1:B8<A2:A9&B2:B9))+1
=6
Ola
Note:
Confirm the formula by holding down Ctrl and Shift, and then press Enter.
Otherwise the result will be 1.
Reply With Quote