Apr 04 2022 05:04 AM
I am having problems with this formula, I need it to only pick up the code that has a value in cell B. But my formula in column F doesn't work as it duplicates the the cell underneath (as highlighted in red). Does anyone have any suggestions ?
many thanks
Apr 04 2022 05:11 AM
Apr 04 2022 05:17 AM
Apr 04 2022 05:24 AM
1) Adjust the ranges as needed, e.g. =FILTER(A1:A1000,B1:B1000>0)
2) Make sure that the cells below the cell with the formula are empty.
Apr 04 2022 06:48 AM
SolutionLike in attached
Apr 10 2022 03:18 AM
@Sergei Baklan thank you so much. It works perfectly, I didn't be realise that underneath the formula needs to be empty. Thank you again really works perfectly.
Apr 10 2022 05:15 AM
@Helen15 , you are welcome
Apr 04 2022 06:48 AM
Solution