Hi there!

My puzzle is to list revisions of multiple documents by date. I have three columns with number, revision and date that it's been issued.

With the help of pivot table, i sorted numbers in column and dates in a row and now need to show on what date what revision was issued.
Unfortunately pivot table lists just number, not the revision name itself. so instead of "AB" or somthing, it gives only "1". which is not good enough

It's not a terribly big table - only 38 dates and 2000-ish documents with multiple revisions.

I guess that it would be two criteria function - if or vlookup and match?

Please HELP!!!

Lina