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.
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.
