PDA

View Full Version : result of filter



amrane
09-15-2015, 08:19 AM
Dear forum,
I am looking to get the result of filter using formula under excel!!!

so far I found 1/2 response: the brown cells are the result of each column independently.

==> what formula to get result as per the yellow cells: result based on two column in the same time??

Looking for your support,
br, Amrane

p45cal
09-15-2015, 09:45 AM
would a pivot table do? See attached.

amrane
09-15-2015, 10:53 AM
dear Mr p45cal,

thank you so much for your feedback,

but, I want to get some array formula to mange this case of calculation,
Br, Amrane

p45cal
09-16-2015, 04:33 AM
With a helper column I.