Forum Discussion
Help With A Formula
Hello, I have a question that I can not find the answer to anywhere. I have a table to map out different things at work. I have the first three rows frozen to display the name of each column. ...
Hi Jordan,
If in your column O you put "x" one by one without skipping them in the middle, you may calculate how many "x" you have in column and take result by offset from first row with data (#4). E.G for P2 it will be
=OFFSET(P$4,COUNTIF($O$4:$O$1000,"x")-1,)
and drag it to the right.
