Forum Discussion
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 on and if it's marked to have a copy listed in a short list next to other task's marked as being worked on. Example below: If anything in Column N say's "Continue", I'd like that correlating row through columns H to N (exclude J) to be copied over to columns A to F. This would allow me to always see a short list we are focusing on and once marked as "Done!" it'd removed from Columns A to F.
Any help is greatly appreciated, thank you.
=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.
2 Replies
=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.
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!
