Newbie Date cells so most recent is on top

M

Mitymack

Is there a way to reverse the date or cell count so the most recent
input appears on top instead of the bottom of the page so I don't have
to scroll down. thank you for any help you may render.
 
M

Max

Mitymack said:
Is there a way to reverse the date or cell count so the most recent
input appears on top instead of the bottom of the page so I don't have
to scroll down. thank you for any help you may render.

Here's one play to try ..

Assume source sheet is named: X,
with data being input in A1 down to a max expected A50 (say)

In another sheet: Y (say)

Put in A1:
=IF(ISERROR(LARGE(Y!B:B,ROW())),"",INDEX(X!A:A,LARGE(Y!B:B,ROW())))

Put in B1: =IF(X!A1="","",ROW())

Select A1:B1, copy down to B50
(cover the expected extent of the data in X's col A)

Y's col A will auto-return the inputs made in X's col A in reverse
order
(Hide away Y's col B, if desired)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top