Hi
i have added the comments to the attached spreadsheet but basically
so if type was fire the first number would be F102.
if fire was selected again the number would be F103 and so on etc
Hi
i have added the comments to the attached spreadsheet but basically
so if type was fire the first number would be F102.
if fire was selected again the number would be F103 and so on etc
You didn't have a dropdown box... so I added it for you. See file. i created the ID number using this:
=IF(C2="","",VLOOKUP(C2,I:J,2,FALSE)&TEXT(COUNTIF(C$2:C2,C2),"000"))
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
Ooops. Should have been:
=IF(C2="","",VLOOKUP(C2,I:J,2,FALSE)&TEXT(100+COUNTIF(C$2:C2,C2),"000"))
Thankyou that is perfect for what I need it to do
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
You don't need the TEXT functionPlease Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks