Forum Discussion
Identical Order Analysis by Account (Is this possible in Excel?)
I have an analysis I am trying to perform but am unsure of what formulas to use, or if excel can even do this. I have a set of data containing ordering history from multiple accounts. The table lists...
To extract unique company use-
=UNIQUE(A4:A87)To count Total orders in Data set
=COUNTIFS($A$4:$A$87,E11)To Count of Orders with no identical match
=SUM(--(UNIQUE(FILTER($C$4:$C$87,$A$4:$A$87=E11))<>""))To Count of orders with identical part numbers
=SUM(--(FILTERXML("<t><s>"&TEXTJOIN("</s><s>",TRUE,FILTER($C$4:$C$87,$A$4:$A$87=E11))&"</s></t>","//s[preceding::*=.]")<>""))Check the attach file.