Hello,
I have a number of different values in a column, For argument sakes there are many different values (txt).
1. I want to know what the different txt's are
2. Count the frequency of these as well.
I appreciate a pivot table would be best. However I was wondering if there was a formula that would do that in excel.
Many thanks in advance.
Does this help:
http://www.xl-central.com/count-unique-values.html
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks