Count unique value in dynamic column based on cell value

  • Hello,

    I have a document that has a specific Date in cell A1. the date is dynamic based on other variables but are not needed for this example. I also have Dates in B1: ?? based on the month in A1 (i.e A1= 6/8/2014, B1= 6/1/2014 C1=6/2/2014 -> 6/30/2014).

    I am wanting to create a formula that will count the column that matches cell A1 with al the matches to the value in cell A2 (A2= X).

    Please let me know if i need to clarify my question. Im guessing i will have to do some sort of countifs and match combination, but cant quite figure it out.

    Thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!