Hacker News Reader

> 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-f...

View on HN

That'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.

This is something I faced in both Excel and GSheets (when working with formulae only). That is the need to repeat myself occasionally.

Reply on news.ycombinator.com