Hello everyone,
I have a problem finding a decent solution to write a function that checks for a combination of values in two different columns, but only if a certain value is existing in a 3rd column in that same row. As i have some problems describing the problem, i've just tried to build an example (picture-link bellow)
http://s75i.imgup.net/Excelquest704c.jpg
So I am trying to build a function that checks which colors and sizes of a specific shirt-type are available. It's not important to count results or get ammounts or anything - a "simple" does the combination of shirt-type, size and color exist (x) or not ( )
Hope i could make my question clear. thanks for all help already in advance
Bookmarks