All,
Trying to use lookup and address for the first time and think i am doing it wrong.
SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300))))
So i have a ton of stuff in coulmn G
I need to find the last value that isnt NA
=LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245)) this equation works
then i need to use only the last 300 data point
=LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))-300
so i tried to use the big equation above but it says something is wrong.
I am trying to count anytime there is text within the last 300 points that are good data points. Bad points start at NA.
Trying to use lookup and address for the first time and think i am doing it wrong.
SUMPRODUCT(--ISTEXT(address(7,LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))):LOOKUP(address(7(2,1/(G5:G15245<>""),ROW(G5:G15245)-300))))
So i have a ton of stuff in coulmn G
I need to find the last value that isnt NA
=LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245)) this equation works
then i need to use only the last 300 data point
=LOOKUP(2,1/(G5:G15245<>""),ROW(G5:G15245))-300
so i tried to use the big equation above but it says something is wrong.
I am trying to count anytime there is text within the last 300 points that are good data points. Bad points start at NA.
