plz see to my attached sheet and revert to me
A arifanmol Member Feb 2, 2023 #1 plz see to my attached sheet and revert to me Attachments Skipped Space.xlsx 7.5 KB · Views: 13
P Peter Bartholomew Well-Known Member Feb 4, 2023 #2 If it is just a counter column that is needed Code: = LET( k, SEQUENCE(2*n - 1, , 0), IF(ISEVEN(k), 1 + k/2, "") ) or to distribute a list Code: = REDUCE("Header", list, LAMBDA(stack, item, VSTACK(stack, "", item) ) ) Either way, do not attempt to insert data within the blank cells.
If it is just a counter column that is needed Code: = LET( k, SEQUENCE(2*n - 1, , 0), IF(ISEVEN(k), 1 + k/2, "") ) or to distribute a list Code: = REDUCE("Header", list, LAMBDA(stack, item, VSTACK(stack, "", item) ) ) Either way, do not attempt to insert data within the blank cells.
A arifanmol Member Feb 6, 2023 #3 = REDUCE("Header", list, LAMBDA(stack, item, VSTACK(stack, "", item) ) ) HOW TO USE PLZ
V vletm Excel Ninja Feb 6, 2023 #4 arifanmol Did You read? Same directing text in a cell everytime I wish that in G11 and G12 cells, my formula and text remain the same all the time irrelevant of my worksheet or data so that i may not need to copy and paste every time chandoo.org
arifanmol Did You read? Same directing text in a cell everytime I wish that in G11 and G12 cells, my formula and text remain the same all the time irrelevant of my worksheet or data so that i may not need to copy and paste every time chandoo.org