Looking for index, small and row formula to extract all values in A4:O18. Rawdata is in Product sheet and desired ouput in Outcome sheet.
Sample file attached.
Looking for index, small and row formula to extract all values in A4:O18. Rawdata is in Product sheet and desired ouput in Outcome sheet.
Sample file attached.
Perhaps like this?
azumi: not exactly. Should extract all, but solution did not.
Thanks
Sorry formula change to this, put this on A4 sheet "Outcome" and copied down and cross
=INDEX(Product!$A$4:$O$18;ROWS($A$1:A1);COLUMNS($A$1:A1))
azumi: works like a charm. Thanks a million. Is there a way this part of the formula Product!$A$4:$O$18 can be turned to a dynamic range so that when new values are entered, it will auto expand 9or contract when data is deleted)?
Put in A4 sheet Outcome and copied doan and cross
=INDEX(Product!$A:$O,ROWS($A$1:A4),COLUMNS($A$1:A4))
azumi: great solution. Works like a charm. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks