http://speedy.sh/Z2XX8/Forward-Dated-Rows-130213-workings.xlsx
I have saved my file above. All I need to do is delete the rows below the highest sequence, now that we have used to formula to identify the highest sequence.
The problem I am facing is that I cannot individually delete the...
Hi Kaushik
Thanks for your response. I applied your formula, it correctly identifies the sequence and the magic works :). However I am not able to delete the duplicate rows below the highest sequence as going through the spreadsheet which has so many records and deleting one by one will be so...
Hi,
Please can anyone help.
I have rows of multiple lines of records of employees within my organisation and out of those some employees are duplicate records. What formula can i use if within the duplicate record rows I need to pick up the employee with a higher sequence number?
For example...