Index(Collect add to formula page
Can we get an index(collect example added to the collect formula page? I have found it extremely useful in finding specific iterations of data, and I only stumbled upon it trying random things to solve a specific issue I had a while back. It could have saved me quite a bit of time if I had seen an example of it when looking at the formula page.
This is the best way I have found to get filtered data between sheets, and I have a feeling that a lot of users haven't seen this functionality yet.
Help Article Resources
Check out the Formula Handbook template!