J
J
JokeRsKinG2021-08-13 03:30:05
Google Sheets
JokeRsKinG, 2021-08-13 03:30:05

How to display the last 5 numbers from column A when entering numbers in column A in column C?

How, when entering numbers in column A (via enter), in column C, display the last 5 numbers from column A?
The numbers in column A are refillable and can go up to 100 lines, but the last 5 numbers must appear in column C.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-08-13
@JokeRsKinG

The formula is:

=ArrayFormula(
 array_constrain(
  sort(
   {
    filter(A:A;A:A<>"") \ SEQUENCE(СЧЁТЗ(A:A))
   }
   ;2
   ;0
  )
  ;5
  ;1
 )
)

You can see it in the demo table.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question