Hello All
I have a column with repeated values. When this occurs I would like to append the number out of total number, see attached spreadsheet.
Is this possible?
Many thanks.
Adrian.
Hello All
I have a column with repeated values. When this occurs I would like to append the number out of total number, see attached spreadsheet.
Is this possible?
Many thanks.
Adrian.
Hi,
One way
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
=trim(a1&" "&(substitute(countif(a$1:a1,a1)&"/"&countif(a$1:a$7,a1),"1/1","")))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
A much simpler approach and I believe it works. Replace the "of" with whatever text you like, of course.
Brilliant, thanks All.
Glad to have helped and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks