Hi I am requiring a formula that will take sub heading and allocate it to a list of data until the next sub heading appears and then allocate that to the next list of data and so on.
Please see attached sheet for details.
Any questions, please ask.
John
May be this??
In D5 Cell
=IF(A5="","",IFERROR(LOOKUP(2,1/($B$5:B5<>""),$B$5:B5),""))&C5
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this one
=IF(A5<>"",LOOKUP("zzz",B$5:B5)&" "&C5,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try this,
Please Login or Register to view this content.
Cheers guys, great responses both work equally well.
John
Thank you John for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks