3 ms·
> it is very non intuitive to write a formula that retrieves all the rows in another sheet that match this rule You can retrieve an entire range of data with a
by jsmith99 4y ago
> it is very non intuitive to write a formula that retrieves all the rows in another sheet that match this rule
You can retrieve an entire range of data with a single formula in either excel or Google sheets. The formula is caller FILTER https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759 https://support.microsoft.com/en-us/office/filter-function-f...
- adepressedthrow 4y agoThat's exactly what I did. Now separate out some columns and perform some additional transformation on that FILTERed data. Can you do it without repeating yourself (duplicating the FILTER statement, or any of the other transformations you need to do, besides just filling down a column). Can you perform these transformations only on the row height of the data, and not have extra rows with broken formulas? I honestly wouldn't even be surprised if the functionality to do the above does exist, but for all of my searching I couldn't find it.
- LasEspuelas 4y agoThis is something I faced in both Excel and GSheets (when working with formulae only). That is the need to repeat myself occasionally.
- deburo 4y agoI will ramble a bit, but for complex data transforms, you can use PowerQuery instead of formulas. For semi-serious programmers like myself, I started doing C# add-ins to Excel using Excel-Dna. There’s also Query Storm. :)