Unique Numbers from Date Column

[Mohan BR]

Dear Team,

I am new to this Forum i have have some Quires, In that Column A has Multiple Retailer Number Column B has Date, I need Formula for only Unique retailer Numbers Against >=8/25/2016. Refer attached File and please help me.

Thanks

Regards
Mohan

 

[ALOXAZ]

select column A&B go to sort & filter and press filter. Now you notice that there is a small filter near retailer heading press it and choice the retailer. Move to invoice data,press the filter, tick date filters ,select after and insert the date which you prefer

 

[NARAYANK991]

Hi ,

Another option is to use the Advanced Filter feature ; use the criteria as shown in the attached file to extract a list of all retailer numbers which meet the criteria.

Then create a pivot table to derive the unique retailer numbers.

Narayan

 

[Mohan BR]

Thanks for your Response, I need formula to the get output without using pivot table and filter please help me.

 

[Deepak]

Mohan BR

As Narayan said; Best option would be advance filter or pivot.
Formula might slowdown the sheet for large data set. You may also use UDF for the same.

 

[bines53]

Hi ,

That's what you're looking for,
=SUM(--(FREQUENCY((B2:B10000>=I2)*A2:A10000,A2:A10000)>0))

David

 

[p45cal]

Hi ,

Another option is to use the Advanced Filter feature ; use the criteria as shown in the attached file to extract a list of all retailer numbers which meet the criteria.

Then create a pivot table to derive the unique retailer numbers.

Narayan

You can skip the pivot table part by doing an advanced filter as you did, but use as the destination (Copy To: ) range a single cell with the header retailer_msisdn (this will produce only one column in the advanced filter result), make sure there's a tick the check box Unique records only, finally, click OK.

Mohan, a formula to get a list of unique retailer numbers would be rather long, probably an array formula, difficult to maintain/adjust (and create!) that even with only 10000 records would take a minute or minutes to update every time the sheet decided to recalculate. It is NOT A GOOD IDEA.
Why do you insist on a formula?