How to Auto Increment the ROWS Function Horizontally

Hi, is there a way of making this formula so the ROWS bit at the end increases by one with each cell I drag it to (horizontally)? This works vertically but not horizontally. I did have a list of numbers in another block of cells and tried using the INDIRECT function but to no avail.

=IFERROR(LARGE(IF($D$2:$D$31=$M$35,$C$2:$C$31),ROWS($1:1)),"—")

Have you tried using COLUMNS?

Formula:

Please Login or Register  to view this content.

Use the COLUMNS( ) function.

Typically, you want to use the cell address of the first cell that the formula is entered in. For example, if the first cell the formula is entered in is cell B2 then use:

=IFERROR(LARGE(IF($D$2:$D$31=$M$35,$C$2:$C$31),COLUMNS($B2:B2)),"—")

If the first cell the formula is entered in is cell H25 then use:

=IFERROR(LARGE(IF($D$2:$D$31=$M$35,$C$2:$C$31),COLUMNS($H25:H25)),"—")

You're welcome. Thanks for the feedback!