PDA

View Full Version : match within countif ...



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.

Simon Lloyd
12-22-2012, 08:06 AM
A formula can't decide whether a cell was just edited or not, you'd have to use VBA and pass the edited cell address to a variable, also you state where the criteria "e4" I will need to replace with "e" the current row that a cell was just edited if you change the "E" you are changing the column NOT the row.