Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Counting unique cell values
Thanks Deniall Yes I agree the "unique combinations" method requires constant maintenance but I seldom need this data so the "formula" method is simplest for me. However I will archive this thread with your macro and just may give it a try.- BetaChick
- Post #10
- Forum: Microsoft: Office
-
Counting unique cell values
Brilliant Andrzejek Thank You- BetaChick
- Post #8
- Forum: Microsoft: Office
-
Counting unique cell values
Took me a while to figure it out but "The unique feature in the Data tab" was my answer. Now my =COUNTIF(A:A,B1) gives me what I want. Thank You Tricia- BetaChick
- Post #6
- Forum: Microsoft: Office
-
Counting unique cell values
Sorry I didn't know I used my husbands logon ID to respond, apparently he had TekTips set to "remember me".- BetaChick
- Post #4
- Forum: Microsoft: Office
-
Counting unique cell values
A B 1 Debit 3 2 Withdrawal 2 3 Credit 1 4 Withdrawal 2 5 Check 1 6 Debit 3 7 Debit 3 I have XP and Excel ver. 2003 In the above short example Column A has data...- BetaChick
- Thread
- Replies: 10
- Forum: Microsoft: Office
