Have a look at the attached. Does this do what you need?

I've used this specific example as it points out a minor flaw in the process. But without more information on what you're actually searching for, it's hard to tell if it will be an issue for you.

thx you guy it works

Happy to help :)

dear i want help in one more thing

I have three cells first cell contains the following "forwardtopostapproval re-checking forwardtopostapproval"

the second cell contains staff names " georgesidhom,tamerxxx, kimomicho"

the third cell contins time & date " 12:55 april 2AM ,13:12 may ,15:20 august"

this cells come vertical positions beside each other

how can i analysise this data for example know that the georgesidhom do the action forwardtopostapproval @ 12:55 april 2AM

I'm not sure I fully understand what you mean. Could you post an example workbook?

here it is

the aim is to match the action with the date with the name

As per your additional post on the same topic:
http://www.excelbanter.com/showthread.php?t=447447

Your example file does not make it clear what you're actually trying to accomplish with this.

Perhaps if you could add a manually generated example of what you want it to look like after the macro/formula has been executed it would help someone understand your need more.

What i want is to know how many action done by the names and what is this action and the dates of each action by pivote for example