View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Lookup Formular on Table

Hi

Try instead the array entered formula
{=MAX(ISNUMBER(B2:F2)*$B$1:$F$1)}

=MAX(ISNUMBER(B2:F2)*$B$1:$F$1) <=== Formula to be copied

To enter or amend an array formula, use Control+Shift+Enter (CSE), not just
Enter.
When you use CSE, Excel will insert the curly braces { } around the
formula.
Do not enter the braces yourself.
Copy the line I have pointed at, Paste it into the cell on your sheet and
use CSE
--
Regards
Roger Govier

Have encounterd a small problem
When I have numbers in March, blank in April and numbers in May it is
resulting in march rather than May?

Jan-01 Feb-01 Mar-01 Apr-01 May-01 Last came
Tom 1 1 1 1 1 May-01
Harry 1 1 1 1 Mar-01
William 1 1 1 Mar-01
James 1 1 Mar-01
Peter 1 1 Apr-01