Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching and displaying records that match criteria. | Excel Discussion (Misc queries) | |||
Latest LOOKup | Excel Worksheet Functions | |||
Searching for particular records | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Excel2000: The latest value | Excel Worksheet Functions |