LinkBack URL
About LinkBacks
Hello everyone,
I need some help with a formula in Excel. Let's say this how a column looks like:
a
b
b
c
d
Is there a formula to get this outcome:
a 1
b 2
c 1
d 1
If not, is there a way to create a list of words that are in a column?
Thanks a lot!
Hello everyone,
I need some help with a formula in Excel. Let's say this how a column looks like:
a
b
b
c
d
Is there a formula to get this outcome:
a 1
b 2
c 1
d 1
If not, is there a way to create a list of words that are in a column?
Thanks a lot!
You could easily use a pivot table to show a list of the distinct text values, with a count of occurences.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
That's a start. Is it possible to see how many times are word is in the column? Now I only see what words are in there, but not how many times.
Thanks a lot!
Add Field1 as both a row field and a value field, summarized by count.
Worked out great. Thanks a lotOriginally Posted by OllyXLS
!
If U nee d for formulas, assumes your data from cell A1 and down :
put in B1
=IF(COUNTIF(A:A,A1)=1,A1&1,A1&COUNTIF($A$1:A1,A1))
Deleted Post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks