Forum Discussion
filter formula frustration
Hi, I'm wondering if someone can help me. I want data from spreadsheet B (invoice tracker) to auto populate lines in spreadsheet A (invoice request). Sounds simple and the FILTER formula I've appli...
You may need BYCOL() or MMULT() function with FILTER(). Please attach a sample file and show use your desired output then we could suggest you better solution.
Harun24HR Thank you, problem solved!