A
A
Alina Shah2022-04-08 00:41:01
Google Sheets
Alina Shah, 2022-04-08 00:41:01

How to make it take only 10 rows in the formula for the graph, and not all the counted ones?

https://docs.google.com/spreadsheets/d/1GP-U3daCDn...

How can I make the AG7 cell formula for the graph take only 10 lines, and not all the counted ones?
Those. the schedule must be built for 10 years.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2022-04-08
@Shah_Alina

=ArrayFormula(filter(0+AE7:AF106;0+AE7:AE106>=$B$6;0+AE7:AE106<=$B$6+10))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question