Hi all,
Having a hell of a time trying to get a formula that will do the following
On one worksheet i have the following table
Item Number used Date
12345 2 18/07/06
56789 2 20/07/06
12345 1 18/07/06
On another worksheet i need to have:
Date (return on single date if used more than once on the same day)
The item number (return a single item code if used more than once on the same day)
The total number used so that what I get is the following:
item Number DAte
12345 3 18/07/06
56789 2 20/07/06
Normally this wouldn't be hard but i'm having a damn rough time trying to match all THREE criteria....
Thanks all
Sandi
Bookmarks