I would like to see last entry of "C" Column Rang wise by formula. Like Rang is C2:C30 or above & le

[Mohammad Younous]

I would like to see last entry of "C" Column Rang wise by formula. Like Rang is C2:C30 or above & less. Data like Text, Number, Date etc.


Younous
Dhaka
BD

 

[oldchippy]

Hi Mohammad Younous,

Try this

=OFFSET(C2,MATCH(MAX(C2:C30)+1,C2:C30,1)-1,0)

 

[Somendra Misra]

Hi Mohammad Younous,

Use below formula to return anything be text or numbers from column C (last entry):
=INDEX(C:C,COUNTA(C:C))

for returning last number or dates use:
=LOOKUP(9.99E+100,C:C)

Regards,

 

[SirJB7]

@Somendra Misra
Hi!
1st formula only works if there's no empty cells in column C.
Regards!

 

[Somendra Misra]

@SirJB7
Correct Sir.

Regards,

 

[Mohammad Younous]

Thanks a lot all.