LinkBack URL
About LinkBacks
Hi,
I would a formula which returns the string from column B in column AB if the string in column AA (same row as column B) has not appeared in preceding rows. If this is not fulfilled nothing should be returned.
Regards
Hi,
I would a formula which returns the string from column B in column AB if the string in column AA (same row as column B) has not appeared in preceding rows. If this is not fulfilled nothing should be returned.
Regards
Last edited by pvp1900; 11-28-2019 at 06:56 PM.
Hi,
Follow attachment.
Cheers!
John.
"I excel at jumping to conclusions"
Hi,
In AB2 put this formula (then drag down...)
=IF(ISNUMBER(MATCH(AA2,$AA$1:AA1,0)),"",B2)
Last edited by Tommy90; 11-29-2019 at 03:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks