Forum Discussion

Copper Contributor

Aug 05, 2022

Solved

If Then Function Used to Copy and Fill Multiple Cells

Hi all, I don't know if it's possible, but I need help if possible. I'd like to make a checklist that is rather long, not all items will be worked on at once so I'd like to mark what is being worked...

excel

Formulas and Functions

OliverScheurich
Aug 05, 2022
alexahebbard
=IFERROR(INDEX(H$2:H$13,SMALL(IF($N$2:$N$13="continue",ROW($M$2:$M$13)-1),ROW(1:1))),"")
You can try this formula for the data layout of the example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. I've entered the formula in cell A2 and copied it across range A2:F10.
If you work with Office365 or 2021 you can apply FILTER function.

OliverScheurich

Gold Contributor

Aug 05, 2022

alexahebbard

=IFERROR(INDEX(H$2:H$13,SMALL(IF($N$2:$N$13="continue",ROW($M$2:$M$13)-1),ROW(1:1))),"")

You can try this formula for the data layout of the example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. I've entered the formula in cell A2 and copied it across range A2:F10.

If you work with Office365 or 2021 you can apply FILTER function.

alexahebbard
Copper Contributor
Aug 05, 2022
OliverScheurich
I didn't even think about filter. After looking into that option from this video(https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759), I think that will be the best function for my excel spread sheet. Thank you so much for your advise and quick response!