filtering out a record for each user
hi, i have a report in excel.
For each user there are history of records... say "n' no. of records.
similarly the report contains records for many user. my requirement is for each user , i need to filter out the record which has a recent date ...
for example,
user log history
----------------
user1 23/10/2012
user1 25/10/2012
user2 21/10/2012
user2 22/10/2012
user2 24/10/2012
Please help me in achieving this
What do you mean by recent date?
When you say you want to filter out the data, where do you want to copy and paste that info?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
for example,
user log history
----------------
user1 23/10/2012
user1 25/10/2012
user2 21/10/2012
user2 22/10/2012
user2 24/10/2012
from this table, i need the output like
user log history
----------------
user1 25/10/2012
user2 24/10/2012
the record of each user with the recent date (in log history)
Arlette, also asked you " where do you want to copy and paste that info?"Originally Posted by arlu1201
If you don't want to copy somewhere else, then you can use auto filter with a helper column.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
i want the filtered data in the same sheet
Is problem for you if we use a helper and hidden column?
Where in the same sheet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks