Forum Discussion
Report only populated cells into another tab sheet
=IFERROR(INDEX(VISITS!$I$6:$I$201,SMALL(IF(LEN(VISITS!$U$6:$U$201)>0,ROW(VISITS!$U$6:$U$201)-5),ROW('COST SUMMARY'!$A1))),"")
You can try this formula for column I. For column U the INDEX range is adapted accordingly Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
peiyezhu
Thank you. I have attached the dummy version.
I need to report the populated cells of COLUMN U from the "VISITS" tab
into the "COST SUMMARY" tab (somewhere below the existing data)
I will also need it to then pull through the corresponding cell from COLUMN I
So kind of - If cell U is populated, report I and U
=IFERROR(INDEX(VISITS!$I$6:$I$201,SMALL(IF(LEN(VISITS!$U$6:$U$201)>0,ROW(VISITS!$U$6:$U$201)-5),ROW('COST SUMMARY'!$A1))),"")
You can try this formula for column I. For column U the INDEX range is adapted accordingly Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
OliverScheurich
Thank you so so much!
Absolutely spot on. I never would have arrived at that myself.