Hi guys,
I would like you to ask if you would be so kind and explain me why it is working like it is. I understand HOW it is working, but i don't understand WHY.
I dont understand the part where it is:
---------
Example
---------
=INDEX(MATCH(AGGREGATE(15,6,Range1/(Range2&Range3=A1&A2),1),Range1,0))
I know that it will return only results from range that are equal to A1&A2 but why i am using "/" this in that formula and brackets? It's probably easy math logic but i am still learning excel and i am hungry for knowledge.
Bookmarks