Log In
Register
Home
Active Member
July 17, 2019
Offline
Been struggling with making a Excel formula work, I'm using Excel 2007.
In sheet Marriages, I have a column Surname, there are 17 different spellings of McClellan, I need each to have a unique identifier from sheet FF# using the identifier only once per name spelling.
Formula is in sheet Marriages - Column K (K2).
Hope someone can help.
Much thanks!
See AnswerActive Member
July 17, 2019
Offline
Tried to upload and couldn't make it small enough for the limit, so here is a link on my GDrive. Great McClellan Database.xlsx
hope it works.
Thanks for taking a look.
VIP
Trusted Members
December 7, 2016
Offline
Hello Jay,
Not sure if this is what you want, it is how I understood it anyway. Please see attached sample.
I created a helper column to count each spelling version and is using that number added with one to get correct row line in the HLOOKUP formula.
Answers Post
Active Member
July 17, 2019
Offline
Hello Anders
Wow, thank you, that worked like a charm, never thought of using a Helper to count each first.
I changed on thing sheet 2 was FF# but I read # could lead to problems, changed it to FFN, I see you put in single quotes and it worked fine,
but I removed quotes and #, changed to FFN added helper column and it worked great. I was stumped for a few days, now I can move on to converting it to mySQL database.
1 Guest(s)
