Searching Latest Records
hi friends,
I want your help regarding some excel work. Friends, I have a table of 10000 feedback records of various people.In this table some records are duplicates but their dates is different. What is want that I have to add a new column in this table to show the latest record of a particular. e.g. Date SrNo Name FeedbackCmt. Status (ddmmyyyy) 01/04/2008 1 Akki abddsddfffdfd NotLatest 02/04/2008 2 Ram dkldikdkdkkd Latest 05/05/2008 3 Akki hi this is feed NotLatest 05/01/2008 4 Prem dkdjdfda Latest 15/03/2008 5 Ram dfdsffsf NotLatest 15/06/2008 6 Akki eoemdkd Latest I have to design a function for getting the latest record status of a particular in Status field. plz help me... Thanks Akki |
Searching Latest Records
On Jun 26, 1:10 am, wrote:
hi friends, I want your help regarding some excel work. Friends, I have a table of 10000 feedback records of various people.In this table some records are duplicates but their dates is different. What is want that I have to add a new column in this table to show the latest record of a particular. e.g. Date SrNo Name FeedbackCmt. Status (ddmmyyyy) 01/04/2008 1 Akki abddsddfffdfd NotLatest 02/04/2008 2 Ram dkldikdkdkkd Latest 05/05/2008 3 Akki hi this is feed NotLatest 05/01/2008 4 Prem dkdjdfda Latest 15/03/2008 5 Ram dfdsffsf NotLatest 15/06/2008 6 Akki eoemdkd Latest I have to design a function for getting the latest record status of a particular in Status field. plz help me... Thanks Akki hey friends.. i have searched the solution for it in a post replied by Mr T. Valko, giving link below: http://groups.google.com/group/micro...80a280bb53622# Thanks Mr T Valko :) you suggested formula is working i.e. =if(A3<A2,"x","") Regards Akki |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com