Hi All,
I have used a formula to transfer data based on a criteria from one sheet to another sheet using the IF formula. When the data transferred to the second sheet it leaves blank lines. I have tried using =IFERROR(INDEX($D$2:$D$10,SMALL(IF(ISTEXT($D$2:$D$10),ROW($D$1:$D$9),""),ROW(D2))),"") to remove the blank lines however due to the cells already having formulas in them the above does not work.
Can anyone help?
Thanks
Christine
Hi Christine
I have just answered a similar question for Meshell.
https://www.myonlinetraininghub.com/excel-forum/excel/iferror-formula-problem
See if it will help.
Sunny
Hi Thanks for that. The problem is the sheet im referencing the data is already apart of a formula.
Sheet 1 - Master Data
Sheet 2 - I have used =IF(MASTER!U:U="Y",MASTER!D:D,"") formula which is a criteria based formula.
Sheet 2 - then created blank lines.
When I try to use the IFERROR formula above it does not eliminate the blank lines (I think because it is seeing the lines as having formula, thus the line is not blank).
Cheers
Ohh I got it now 🙂 Thanks so much!!
