I need help with a formula I have a spreadsheet that will have site names added as a header (ROW 1 "A through DJ")
Whenever row 1 is populated with a new site I need the name to automatically list on a separate sheet with the information from Row 9 going with it to make a list in Column A2 (Row1) and B2 (Row 2)Sheet1.PNGSheet 2.PNG
Put these formulae in A2 and B2 of Sheet2 and drag down as far as you need:
Formula:
Please Login or Register to view this content.
If you want to get rid of the zero values you get, surround the formulae with IF(ISBLANK( like this:
Formula:Please Login or Register to view this content.
Hope that helps.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you! this was what I was looking for!
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks