Latest Input To Appear

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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;
Click to expand...
example Jan-Mei (data from A2), Jun-Sept (data from B2)
and so on.
 
Back
Top