I know I can write individual statements into a cell to get value from another cell/another page.
I have cells with formulas in them on one sheet I would like to copy the values from multiple roes and cells to another sheet, preferably in a single statement, but also not impact the formula(s) in the source cells. This could routinely be 6 or more columns and 40-50 rows od data.
(would definitely need to understand why you need such duplication, but )
the general principle of referencing arrays applies …
so in Sheet2.A1 you can have {Sheet1.B1:F50}
If you enter the array formula directly into the cell, you must use the key combination Shift + Ctrl + Enter instead of the Enter key. Only then does the formula become an array formula.
excelent fpy, thank you!
I am working on a Python 3D scatter app. The need to move stat stems from issues with sorting directly in the data affecting various functions, (at the moment K-means is the most 'touch". So by bulk moving values to a second sheet, I can sort in order to get averages from select groups of clusters, which in turn gives me the asininity to run ∆E calls. It is best to do this without disturbing the original order.Once I have the values, then I can make marker and color changes to the data points. (that’s probably more than you wanted to know!)
Cheers,
StainlessB