Not Show text in a cell

[Unexpc]

Hi guys
I have this code from a professional member of mrexcel, this code find last entered data in column A but not show text data, i have a problem with this, when last entered data is a text, this show empty, i want this show last entered number even a cell that fill with text be after that, anyone can a function in formula that doing this?

=IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",IF(ISNUMBER(LOOKUP(2,1/(A:A<>""),A:A)),LOOKUP(2,1/(A:A<>""),A:A),"")))

 

[RoryA]

Try:

=IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(A:A<>""),A:A)))

 

[Unexpc]

Try:

=IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(A:A<>""),A:A)))

no, that is show texts, i want not show text and just show number, it means when last entered data a text, it shows number before, not show text

 

[Fluff]

How about

=IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A)))

 

[Unexpc]

How about

=IF(MOD(ROW()-6,34)=0,"",IF(MOD(ROW()-7,34)=0,"",LOOKUP(2,1/(ISNUMBER(A:A)),A:A)))

Yeah, this is correct, Thank You

 

[Fluff]

Glad we could help & thanks for the feedback.