Excel Help Please

Avatar Image
CheekyChops | 22:55 Tue 15th Nov 2005 | Technology
2 Answers

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?



1 to 2 of 2rss feed

Best Answer

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!

1 to 2 of 2rss feed

Do you know the answer?

Excel Help Please

Answer Question >>