Hi there,
I have two columns, both holding results of other formulas:
AB
John TRUE
George TRUE
Paul TRUE
Ringo TRUE
Yoko TRUE
Sean FALSE
I need a formula that will find the last TRUE value in B and return the corresponding value in A. For this example, the result will be "Yoko"
I have found a formula that does this when one column is number but not with text
Thanks
does this help?
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Yes it does! Perfect,
Thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks