Link to home
Start Free TrialLog in
Avatar of CPH
CPH

asked on

How to use Excel COUNTIFS and COUNTIF with multiple criteria

HI,
Unique Sequence values comparing A:A (Unique) Multiples in (F:F) with Date variation in (C:C)

I was working on a simple logic, however while on Date() it do not provide the desired output.
As per the sample attached
The primary data needs to be compared based on earliest date concept.
 

Lets say, APPLE_1_55 & GRAPES_1_55 are unique duplicates based on condition "1_55". The countif() formula will give me the sequence in Col H which is highlighted in Yellow.
I need a solution where the unique sequence are generated based on date () in Column C, considering the date value as current to earliest.

The current date with the first sequence will be zero
The second sequence will be one, even if the date are exactly same.
Example (APPLE_1_55 & GRAPES_1_55 are with 4/2/2017)

to simplify Adding to the question, when SEQUENCE ON B occurs 2 and above, than SEQ ON C needs to be populated from latest date to the old date method.

PRIMARY DATA      UNIQUE_PRO_PUR      SEQ ON C      SEQUENCE ON B
APPLE 1_1               04/11/2017                                  0                              1
ORANGE 1_55      04/02/2017                                 2                               2
GRAPES 1_57      04/11/2017                                 0                               1
ORANGE 1_55      04/03/2018                                 1                                2
Unique_Sequence-on-Date-value.xlsx
Avatar of Paul Neralich
Paul Neralich
Flag of United States of America image

Hi CPH, I'm having some difficulty understanding the goal. Is there another way that you can explain it?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.