Searching Latest Records

[gautam.amitk]

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

 

[gautam.amitk]

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/micr...ctions/browse_thread/thread/23480a280bb53622#

Thanks Mr T Valko you suggested formula is working i.e.
=if(A3<>A2,"x","")

Regards
Akki