Search results

Sorry Excel 2007 not 2003. No I don't know to sort.

Hi Kanti, I have around 7,200 records and I am not sure how to sort. Can you please give the code so that I will test. I would like to have a marco and later I would like to add some functionality as well. Thanks.

Hi Kanti, Here the key is combination of Code and Description. And I am taking date and time into consideration for finding latest record. A record can change its status any number times in a day. So I need to find what is last status on that record ie., finding latest data and time of the...

Hi Kanti, Hope it should be clear now. Time| Code| Description| Status| User 10/03/2008 8:15 |A123| Main Data| Read| M 11/03/2008 6:15 |A123 | Main Data | Write| M 12/03/2008 3:15 |A123 | Main Data | Read | M 13/03/2008 7:15 |A123 | Main Data | Write | M 12/03/2008 3:15 |A123 |...

I have a file containing date and time in one column, code, description, status and user in other columns. I will have code and description same or different with different dates and status changed on each date. I need a macro which can find out the status and user of the record with latest...