COUNT UNIQUE NUMBERS WITH MULTIPLE LINE ITEMS WITH CRITERIA

[Tomo198]

Hi,

I'm trying to count the number of unique order numbers in each month, however each order can have a varying amount of line items. Trying to populate Column H with the number of orders for each month. I have tried a combination of COUNTIF and UNIQUE functions but keep getting errors when I'm entering the formula. Any ideas what formula I should use?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER($B$2:$B$100,$A$2:$A$100=G2)))

 

[Tomo198]

Hi & welcome to MrExcel.
How about

=ROWS(UNIQUE(FILTER($B$2:$B$100,$A$2:$A$100=G2)))

Working perfectly, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.