Forum Discussion
Solved
INDEX MATCH function, avoid duplicate returns
Hi everyone! I'm working on a sheet for work. I am on my last task and can't seem to figure this one out. I'm hoping someone can help: I have a data sheet with all the data. In my current she...
If you are on Excel with dynamic arrays that could be
=UNIQUE(FILTER('Horse data'!B2:B100, (I$13='Horse data'!C2:C100) * ($K$13='Horse data'!D2:D100) ))
This is what I see after clicking Open full text editor. Note the "cloud" icon at the very bottom for attaching files.
byundtAs seen from my photo, there wasn't such a button. But i've realized that i could have just directly dropped the file into the text editor and it'll attach the file.
Thank you anyway. Both formula works wonderfully!