Show the current value

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

Guest

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

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up) from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced
 
=IF(MONTH(TODAY())>5,Sheet2!J40,IF(MONTH(TODAY())>3,Sheet2!G40,D40))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Param said:
Hi, Please guide me how to use formule for the below function;

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up)
Click to expand...
from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced
 
Although a bit fancy...

=LOOKUP(9.99999999999999E+307,IF(MOD(COLUMN(D40:J40)-CELL("Col",D40)+0,3)=0,
D40:J40))

Param said:
Hi, Please guide me how to use formule for the below function;

I have 2 worksheets. At worksheet2 I will enter the latest number of students by term. e.g
cell D40 (number of students from Jan-Mac),
cell G40 (number of students from Jan-Mei)
cell J40 (number of students from Jan -Oct)

My question how to display the latest population of students (pick up)
Click to expand...
from D40/G40/J40) on cell B2 at worksheet1. Thanks in advanced
 
Back
Top