ChatterBank2 mins ago
Excel Help Please
I have created a spreadsheet that is basically a record of marriages.
Line one has the year in cell A, date in cell B, Groom in cell C, address of groom in cell D etc
Line two has blank cells A and B, as the details are the same as the line above, cell C has Brides name, address of bride in cell D etc
Is there any way that I can format the spreadsheet so that line 1 and 2 'stick' together? (and lines 3 and 4, 5 and 6). So if you search for say, Joe Smith and it finds him on line 12, it will also pick up his bride on line 13 because they are associated?
Does anyone have a clue what I'm talking about and knows how i can do this?
No best answer has yet been selected by CheekyChops. Once a best answer has been selected, it will be shown here.For more on marking an answer as the "Best Answer", please visit our FAQ.
Its quite complicated to do that in Excel. You might be able to run a 'Query' (usually in tools menu i think) but read up on the function first.
Alternatively, get comfy with Microsoft Access, a proper database program. It's not as difficult as it appears and you can run functions, like the one you want, much more easily and quickly.
Sorry for not answering directly!
It sounds as you might be able to do this by "merging" the appropriate cells together. This could be quite laborious, but all you have to do is select the cells you wish to make one cell (they have to be next to each other), right clicking on them, selecting "format cells", then selecting the second tab along the top "alignment", and checking the little box next to merge cells.
Hope this works, if not let me know!