Count if uniq id after a filter in a collumn

Hello,

Please help me as fallows i have a set of informations wich belongs to different dates (in this case i made an example for 2 dates), i would like to extract only duplicate number and bring the uniq count for it (like if i have 3 same numbers for date 1.11 it would return 1), To look in collumn a for this primary key.

As a helper i ascked you guys for formula in collumn E wich helps me to identify wich doubled or tripeled and so on primary key has no resolution(agent) (and i have to place it for further inspections). After this check in collumn e i need to extract uniq primari key (coll a) for each duplicated primary key and for each date in part.
In collumn F it s a way that i can say if an primary key is uniqe but it applys for all information.

Is there a way how i can sepparate this by date withouth moving my information with filter in another sheet and apply collumn F formula or make an infinite collumns with statements for every day and if a day is equal to something to start and apply the formula (i could also do this if information is always sorted in order) but it would be a pain in the *** and a lot of multplications of formulas.

Hope you understand what i wish.
Count IF uniq ids after a filter in a collumn.xlsx

I am a bit confused.... Was your original formula in column F giving the correct result? If NO, then an explanation PLUS correct results, manually calculated, is mUCH more useful.

This is a guess...


=SUMPRODUCT(($A$2:$A$49=A2)*(COUNTIF(A$2:A2,A2)=1)*($D$2:$D$49=D2)*(E2=TRUE))>0

No my F formula it was only a way i do check unique keys but i have no further knowledge in conditioning this formula.

Glenn, i need to evaluate each day, like if you filter on day 1.11 and in column E you chose false from your formula in E, Than it brings false for all my keys, but i would like to have the uniqe primary key in this case separately from all of the other ones (days).

I would like that this formula start only if day is selected and only to take in consideration information for that day. and return the unique ones.

My formula in f is just an example but as a whole. i need it to work for each day.

Please amend the sheet and add manually calculated results.

Originally Posted by Glenn Kennedy

Please amend the sheet and add manually calculated results.

Count IF uniq ids after a filter in a collumn.xlsx

Here you go MR Glenn! Thank you in advance!

Are you saying that the ONLY incorrect result in the sheet attached at Post 6 is cell F21??? If ONLY it should be FALSE, why should F2 be TRUE?

Unless you tell me what you expect to see, I have NO IDEA what you want.

OK Glenn i understand why you were confused,
because now i realise when i went true this i pushed this forward without making anysense and forget about the previous request.

So please try first make tham unique only conditionated by date, in this case we have to forget about f2 being true and f21 being incorect.

And next if is there is by anychance possible to extract from this only the uniques one that are also duplicated and are also separated by dates would be another good point.

Please upload a file showing EXACTLY what you want, where you want to see it. I want to see your actual EXPECTED RESULTS, and not a formula that does not quite work.

@Glenn
Seems to have been solved on one of the three cross posts I reported

@alexxi

You seem to have a major issue with respecting our rules. If you continue to disregard them, then your posting rights here will be terminated.

Cross-posted on THREE other forums:

https://chandoo.org/forum/threads/co...0/#post-290733
https://forums.excelguru.ca/threads/...58/#post-48342
https://www.mrexcel.com/board/thread...llumn.1223204/

Our rules are here - READ THEM NOW: https://www.excelforum.com/forum-rul...rum-rules.html

Well i didn`t do it on purposley i thought there are different communities that work with different people. I never mind this. But it make sense and now after i read your warning i understand how to do it. Thank you.