Forum Discussion

Pierr1930's avatar
Pierr1930
Copper Contributor
Sep 21, 2020
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...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 21, 2020

    Pierr1930 

    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's avatar
Pierr1930
Copper Contributor
Sep 21, 2020

Pierr1930 
Maybe I was not clear, here is a small sample...I have tried using a countifs formula to get a value in Column E, without luck.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Sep 21, 2020

Pierr1930 

 

I now think that this could help you.

Please open file.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

Resources