Forum

Notifications
Clear all

Formula to Increment Down 1 Row when Copying the Formula Across Columns

3 Posts
2 Users
0 Reactions
68 Views
(@kvnsully)
Posts: 9
Active Member
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
(@mynda)
Posts: 4761
Member Admin
 

Hi Kevin,

You can use this formula:

=INDEX(T,COLUMNS($A:A),COLUMNS($A:A))

 

Mynda

 
Posted : 09/09/2022 9:50 pm
(@kvnsully)
Posts: 9
Active Member
Topic starter
 

Thank you very much, Mynda.

 
Posted : 10/09/2022 1:48 pm
Share: