View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] gautam.amitk@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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