LinkBack URL
About LinkBacks
Assuming the data starts in Row 2, then:
A2:and copy down.Formula:
=IF(T(B2)<>"",B2,A1)
It's not checking for bold though and, AFAIK, you can't test for that in a worksheet function ... but I might be wrong.
Regards, TMS
Assuming the data starts in Row 2, then:
A2:and copy down.Formula:=IF(T(B2)<>"",B2,A1)
It's not checking for bold though and, AFAIK, you can't test for that in a worksheet function ... but I might be wrong.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks