wilg
12-22-2012, 07:12 AM
Hi there. I'm sure this could be easy for someone, but I cant get my head wrapped around it to figure it out.
I need a countif formula that will return the row number with a match funtion inside the countif formula.
I've started with this..
=countif(e4:e100,e4)
where the criteria "e4" I will need to replace with "e" the current row that a cell was just edited.
Any help is truly appreciated.
I need a countif formula that will return the row number with a match funtion inside the countif formula.
I've started with this..
=countif(e4:e100,e4)
where the criteria "e4" I will need to replace with "e" the current row that a cell was just edited.
Any help is truly appreciated.