Latest Input To Appear

[Param]

Hi

Please guide me how to use formule for the below function

A B C
Jan Jun Oct No.of Students
24 25 25

x = how to display the latest population of students; example Jan-Mei (data from A2), Jun-Sept (data from B2) and so on

Thanks in advanced

 

[Jason Morin]

One way:

=OFFSET(A2,,COUNT(A2:C2)-1,)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

Please guide me how to use formule for the below function;

A B C D
Jan Jun Oct No.of Students
24 25 25 x

x = how to display the latest population of students;

example Jan-Mei (data from A2), Jun-Sept (data from B2)
and so on.

 

[Domenic]

Hi,

Another way,

=LOOKUP(9.99999999E+307,A2:C2)

Hope this helps!