Hi,

I have a data set which I am trying to analyse in different ways. I have four columns (B to E) which act as filters to help aggregate the data accordingly in column F. The combinations could mean only 1 column in B to E is completed or up to all four. I have written this formula but wondered if there was a way to do it without arrays.

Please Login or Register  to view this content.
I would really appreciate your help.
Thanks
James