How do I find the first occurence of a series of data in a range and return the value
I need to find the first occurrence of 3 consecutive cells in a range that contain the same # in the cell and then return the value of the header in the column with the 3rd occurrence. See spreadsheet for details.
Any help would be appreciated!!
Thanks
Becky
From the dat you provided
=INDEX($C$1:$N$1,MAX(IF($C2:$N2=3,COLUMN($C$2:$N$2)-COLUMN($C$2)-1))+2)
Confirm Control+Shift +Enter
But this will work for three consecutives 3.
Is this what you after?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
That's exactly what I needed!! THANK YOU VERY MUCH!!
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks