A
AndyCotgreave
Hi,
I'm trying to do a VLOOKUP, but I need the maximum value of a
particular column. For example, in the data below:
Col A Col B Col C
Name Start End
Andy 01 January 1997 03 February 2005
Belinda 02 April 1996 08 January 2000
Charlie 03 February 2001 10 October 2002
Andy 01 January 1997 01 March 2004
In column D I want the maximum End date for each person. So, for the
above:
Col A ...Col D
Name End
Andy 03 February 2005
Belinda 08 January 2000
Charlie 10 October 2002
Andy 03 February 2005
I'm sure the answer lies in VLOOKUP, or maybe it's INDEX/MATCHES?
Thanks in advance
I'm trying to do a VLOOKUP, but I need the maximum value of a
particular column. For example, in the data below:
Col A Col B Col C
Name Start End
Andy 01 January 1997 03 February 2005
Belinda 02 April 1996 08 January 2000
Charlie 03 February 2001 10 October 2002
Andy 01 January 1997 01 March 2004
In column D I want the maximum End date for each person. So, for the
above:
Col A ...Col D
Name End
Andy 03 February 2005
Belinda 08 January 2000
Charlie 10 October 2002
Andy 03 February 2005
I'm sure the answer lies in VLOOKUP, or maybe it's INDEX/MATCHES?
Thanks in advance