Hello, my third post in two days but I'm gradually learning!
So, this time, I have product codes in column Q and fault descriptions in column Z. I have concatenated these in column AV and now need to see the most common value in column AV but only if the value in column V is 'Factory Quality'
I have got a formula for finding the mode but can;t add the condition relating to column V....
Thank you in anticipation of your help.
Last edited by milliemoo; 10-25-2011 at 07:29 AM.
So the resultant concatenated value in AV is text? If so try
=INDEX(AV2:AV1000,MODE(IF(V2:V1000="Factory quality",IF(AV2:AV1000<>"",MATCH(AV2:AV1000,AV2:AV1000,0)))))
confirmed with CTRL+SHIFT+ENTER
Audere est facere
Once again, you're a star! Thank you very much. it all works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks