Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
68
Views
Topic starter
I'm looking for a formula that increments 1 row down when copied across columns. I have several matrix type data sets and I do not want to have to edit each formula as I copy it across.
I want to retrieve the values highlighted in yellow. I have also included a sample file attached.
Thank you in advance.
Posted : 09/09/2022 3:00 pm
Hi Kevin,
You can use this formula:
=INDEX(T,COLUMNS($A:A),COLUMNS($A:A))
Mynda
Posted : 09/09/2022 9:50 pm
Topic starter
Thank you very much, Mynda.
Posted : 10/09/2022 1:48 pm