Forum Discussion
Autofill data from in excel
I have 9 column and several rows but i have less value in the same rows. I need to fill the data from R1, R2, R3 if have more then R4. But if R value in first row is blank and I need to ...
=IFERROR(INDEX($A2:$I2,SMALL(IF(NOT(ISBLANK($A2:$I2)),COLUMN($A:$I)),COLUMN(A:A))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell K2 and filled across range K2:S14.
Thanks for your help and awesome, the formula works for me.