Forum Discussion
Highlight FIRST EVER row ONLY
Hi Jesling
you could use a combination of MATCH and ROW. Here is one example:
=MATCH(C4;$C$4:$C$16;0)=ROW(C4)-3
(depending on your local settings, you probably need to use commas instead of semicolons)
The MATCH gives the position of the first occurance of every value within the list.
And this position is then compared with the row number. Please note, that you have to subtract the number of lines above your list.
In my example, I have 3 lines above my list, so I subtract 3 at the end.
Martin_Weiss, I am not able to use your formula above. This is because some may get the "Financial Free" at row 10 but me may get it at row 26 instead. The column stated either "Financial Free" or "Keep On Going" is calculated by the formula. It may vary by their age, living expenses, income, returns and etc. In this case, I am not able to minus 3 as the "Financial Free" is not fix at certain row. Do we able to modify your formula above to fit the situation?
Anyways, thank you so much for your reply. Hope to hear from you soon.Hi Jesling
maybe you misunderstood me, or I misunderstood you ;-).
It was clear, that the values "Financial Free" and "Keep on Going" may occur on any given row.
My formula takes this under consideration. The row three in my example is just the number of rows above the list, so how many rows you have before the very first entry of your list.
I give you two more examples:
My list starts at C4 with two empty records at the beginning. But still, the range starts at C4, which means there are 3 lines above my list. Therefore the 3 in my formula.
And if you want to cover the complete column C, the formula would be even simpler:
=MATCH(C1;$C:$C;0)=ROW(C1)
It does not matter where in column C it occurs the first time.
But maybe I have misunderstood your requirments.
