Index(Collect add to formula page

L_123L_123 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
07/25/18 Edited 12/09/19

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.

Thanks!

Comments

Sign In or Register to comment.