Thread
:
Match second occurance of value
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
John
external usenet poster
Posts: 2,069
Match second occurance of value
I am trying to match the second time a value occurs in a horizontal range.
This formula sometimes works and other times does not.... the value I am
matching is TRUE
=HLOOKUP(TRUE,$B$6:$K$7,2,TRUE)
Reply With Quote
John
View Public Profile
Find all posts by John