Bit of a complicated one here.
In column A I have the type of work being carried out, selected from a dropdown. In column B I would like to see the abbreviation of that (see M1:N7 for this data but it's pretty obvious) plus a number. I would like these to increase and populate automatically, without resetting the count.
It should make sense in the attached sheet.
Thanks!
Like this??
=IFERROR(VLOOKUP(A2,M:N,2,FALSE)&TEXT(COUNTIF(A$2:A2,A2),"000"),"")
copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You can adjust the number of leading 0s from the bit in red.
=IFERROR(VLOOKUP(A2,M:N,2,FALSE)&TEXT(COUNTIF(A$2:A2,A2),"000"),"")
if you don't want ANY leading zeros, use:
=IFERROR(VLOOKUP(A2,M:N,2,FALSE)&COUNTIF(A$2:A2,A2)
but this may cuse problems later (C1, C11 and C111 may be more difficult to distinguish... depending on what you're doing).
Amazing! Thank you Glenn, perfect.
I don't fully understand how it works though.... might you be able to explain please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks