You guys seem to have a wealth of knowledge that I'd love to tap into for a project I'm on. I had to have a spreadsheet with phone numbers. The system needs to know that it's 1 or 2 entries per person, so if Jenna has just a home phone she'll just have a 1, but if she has a work and home phone she'll have 2 rows of data and should have a 1 and 2 in front of her numbers to let the system know they're both associated with her.

I have thousands of these people with 2 numbers, and I can't find a good formula to express what I need. I have spaces between each person, so I know that if I see 1,1, next to each other (like HH14 and HH15 both have a 1) I know that it's really supposed to be 1 and 2 but I can't change it, because all I can do is drag down the one.

I need a formula to state if HH14 and HH15 = 1, make HH15 =2, if not leave blank. Does this make sense? Sorry for the long-winded question.

Thanks for any help you can provide.