I creating a sequenial number from the previous filled cell

[sailingaway]

I am trying to match two cells and put a unique number next to it. I have managed to recognize the two requirements and not fill the other cells unnecessarily but my equation will only output 1 and I cannot get it to add one to the previous cell that has a number, to end up with 2,3...


=IF(COUNT(IF(AND(B2=Sheet1!$A$5,'DRS Output'!L2=Sheet1!$B$5),MAXA($A$1:A1)+1,""))=0,"",COUNT(IF(AND(B2=Sheet1!$A$5,'DRS Output'!L2=Sheet1!$B$5),Maxa($A$1:A1)+1,"")))

 

[jarjarbingie]

I am trying to match two cells and put a unique number next to it. I have managed to recognize the two requirements and not fill the other cells unnecessarily but my equation will only output 1 and I cannot get it to add one to the previous cell that has a number, to end up with 2,3...


=IF(COUNT(IF(AND(B2=Sheet1!$A$5,'DRS Output'!L2=Sheet1!$B$5),MAXA($A$1:A1)+1,""))=0,"",COUNT(IF(AND(B2=Sheet1!$A$5,'DRS Output'!L2=Sheet1!$B$5),Maxa($A$1:A1)+1,"")))

you should be getting the MAXA() of the same column where you have the output of 1s..

 

[sailingaway]

Yes i see could you recomend a different function to use on this equation.

 

[jarjarbingie]

Yes i see could you recomend a different function to use on this equation.

so whenever the value in column B is equal to Sheet1!$A$5 and the value in column L is equal to Sheet1!$B$5, generate an increasing index?

say, put the following formula in column L:
=IF(AND(B2=Sheet1!$A$5,L2=Sheet1!$B$5), MAX($L$1:L1)+1,"")