I am trying to convert the following formulas into Access expressions:
=IF(ROWS($1:1)>MAX(G:G),"-",MATCH(ROWS($1:1)-1,G:G)+1)
=IF(OR(I2="",I2="-"),"",COUNTIF(I$2:I2,I2))
=IF(OR($I2="",$I2="-"),"",INDEX(A:A,$I2))
I tried several times to convert these but the "$1:!" part is where I run into trouble. Any help would be greatly appreciated.
Thanks in advance.