Hi
I two tables in excel. One table has 10 columns with the headings
Dates, HUK, HBUK, IMG, Bentley, MAN, BMW, HBE, HNL
The second table is below. The numbers in the second table below are the max of each of the object columns above
HUK 5
HBUK 7
IMG 2
BGBL 8
MAN 9
BMW 10
HBE 7
HNL 9
However i need to add a column to the second table which displays the dates listsed in the first table. However the dates need to be for the max numbers below. For example if the huk max is 5 then the date on the corresponding row is 12/04/2011 e.g.
Does anyone know how to do this?
Thanks
Jeskit
Bookmarks