Hi,
I have been trying to increment cells with the same letter combination with no success. I have different letter initials and I want to make sure that cells with the same letters have sequential numbers and that if a cell has a different letter combination it starts with 1 and then increments cells with the same combination. Any ideas?
Here is an example of what I am trying to do:
OH-1
FN-1
OH-2
CK-1
FN-2
CK-2
CK-3
Thank you!
With A1:A7 containing this list:
These regular formulas, copied down, created incremented references:
Please Login or Register to view this content.
They return these results:Please Login or Register to view this content.
With A1A7 containing this list:
These regular formulas, copied down, created incremented references:Please Login or Register to view this content.
They return these results:Please Login or Register to view this content.
or these:Please Login or Register to view this content.
Is that something you can work with?Please Login or Register to view this content.
Assume your letters are in column A, starting in A2, you can use this formula in B2:
=IF(A2="","",A2&"-"&COUNTIF(A$2:A2,A2))
Copy this down as far as you need to.
Hope this helps.
Pete
First of all, re your profile: Google Excel is not a thing. This forum is about Excel. If you have Google Sheets and don't have Excel, then please use a forum for Google Sheets. There is quite a difference between these. If you do use Excel, please edit your profile and specify the version.
About your question: do you already have existing cells with initials and you want to change these existing cells? A formula cannot change existing cells. You can have a helper column with a formula.
=A1&"-"&COUNTIF(A1:$A$1,A1)
2020-01-27_11-19-21.png
Thank you. I will update my profile.
This formula is not working since I want to generate sequential numbers in existing cells. The initials are department abbreviations that I used the "vlookup" formula to generate. So I need to add sequential numbers for orders from the same department in the same cell so I have a unique identifier for each order.
Put the formula into a temporary column. Copy the results. Use Paste Special > Values to paste the new text over the original text. Remove the temporary column.
The user profile still hasn't been updated - please do this ASAP. As Teylyn has said, there is no such thing as Google Excel.
Is this query for Google Sheets or Excel?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I already stated, Excel. Why make such a big deal out of this? It’s a profile for God’s sake.
Because members tailor answers based on your Excel version.
Less of the attitude, please. We expect good manners at all time from all members, new or old.Originally Posted by mcosta
I am afraid I don't see where you specified that this is for Excel, but thanks for clarifying.
As Pepe said, the profile is important so that members know which version to tailor their answer to - answers can be very different as a result.
If you are asked a question or for clarification, there is a reason for it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks