Forum Discussion
Solved
Excel Formula help please....
I have spent a number of hours trying to make this work, without success. Trying to set up two different criteria to count. Column A is a list of order numbers, repeated by the number of item...
If your Excel version supports dynamic arrays, that could be
with formulas
in G2: =UNIQUE($D$2:INDEX($D:$D,COUNTA($D:$D))) in H2: =COUNT(UNIQUE( FILTER( $B$2:INDEX($B:$B,COUNTA($B:$B)), $D$2:INDEX($D:$D,COUNTA($D:$D))=G2) )) (drag it down)
If your Excel version supports dynamic arrays, that could be
with formulas
in G2:
=UNIQUE($D$2:INDEX($D:$D,COUNTA($D:$D)))
in H2:
=COUNT(UNIQUE(
FILTER( $B$2:INDEX($B:$B,COUNTA($B:$B)),
$D$2:INDEX($D:$D,COUNTA($D:$D))=G2)
))
(drag it down)Pierr1930 , you are welcome
Hey thanks I think that is it.....many thanks for continuing to try.
I will play with it, but this looks very promising!!
Pierre