Forum Discussion
Solved
Duplicating cell value on another sheet
Hello, I am pretty new to excel and this community. I have some knowledge of doing formulas, but all pretty basic. So, what I would like to do is this: If the value of cell "i2" in "sheet2" is g...
You are welcome. After the formulas are entered in cells A14 and K14 you can drag them down. The results are then displayed in ranges A14:A29 and K14:K29 for example as shown in the attached screenshot and file.
This is the formula in cell A14 in sheet1:
=IFERROR(INDEX(sheet2!$D$2:$D$25,SMALL(IF(sheet2!$I$2:$I$25>0,ROW(sheet2!$I$2:$I$25)-1),ROW(sheet2!A1))),"")This is the formula in cell K14 in sheet1:
=IFERROR(INDEX(sheet2!$I$2:$I$25,SMALL(IF(sheet2!$I$2:$I$25>0,ROW(sheet2!$I$2:$I$25)-1),ROW(sheet2!A1))),"")Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.
If you work with Excel 2019 or later you can apply FILTER function.
Thank you! So the formulas work and will add the cell values into sheet 1, but only into Row 14. What it's doing is only taking the first value greater than 0 and adding it to Row 14. If any other values are greater than 0, they do not show up in Sheet 1 unless I erase the first value. Is there a way to have them added to the rows below when I have multiple values above 0?
Thank you for your help!
You are welcome. After the formulas are entered in cells A14 and K14 you can drag them down. The results are then displayed in ranges A14:A29 and K14:K29 for example as shown in the attached screenshot and file.
- Thank you for your help! It works great!!