Answer the question
In order to leave comments, you need to log in
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
The formula is:
=ArrayFormula(
array_constrain(
sort(
{
filter(A:A;A:A<>"") \ SEQUENCE(СЧЁТЗ(A:A))
}
;2
;0
)
;5
;1
)
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question