Looking for some help in order to increment a cells value by one depending on how many seperate rows there are for a specific instance. Ill try and demonstrate rather than babble.
Report 1(Spreadsheet 1)
Employee# Reason
123456 Late
123456 Late
654321 Late
654321 Late
654321 Late
This example shows two seperate employees, the first was late twice, the second three times. As of right now I have a formula that will return a value in numerical form but I need it to increment for each time an employee is late. The output is on a seperate speadsheet and based on the example above should read like this:
Employee# W/E 3.10.12
123456 2
654321 3
Here is the formula I have without a way of incrementing. I appreciate any help.
Thanks,
Steve
=IFERROR(IF(VLOOKUP(B3,[3.10.12.xlsx]3.10.12'!$E$6:$I$33,5,FALSE)="Late",1,""),"")