Hi, I'm having a lot of trouble trying to get some values in some documents I have
What I need to do is, get the amount of duplicate values that are in a column, for example
In this table I need to do this calculation
All the repeated values in the Column "L" are basically a single Item, but due to format reasons they need to repeat the row and add some extra info to that row, but I'm not taking that into account
So we can say that the repeated values in column A are a single item, but are a different kind of item due to modifications, so this we call them as ITEMS TYPE A
The Items that have unique values are also items but without any modifications so the don't repeat but we call this items ITEMS TYPE B
So here what I need to do is get the amount of ITEMS TYPE A that are in the column, only the type A just by looking at the image there are 12 items TYPE A in the image
I also need to get the amount of TYPE B items, again just by looking at the image there are 10 items TYPE B
I also need to get the total number of items there are in general so TYPE B and TYPE A,
I have tried a bunch of formulas that i found online, but I think these only count the total amount of duplicate values in the column, so intead of giving me 12 TYPE A items it gives me 28 which is the amount of duplicated cells.
For the type B items I haven't tried it
But the count of Type A and B items I tried using this formula but it wont work properly, it gives me 10 instead of 11, not sure if it is for the blank spaces or due to the background color
I'm really desperate to get this i have tried a lot of formulas, but those simply won't get me the data I actually need. I also need to kida sort the colored cells, because the grey cells are "cancelled" and the white ones are "active" so later I'm gonna need to get the amount of "cancelled" and and "Active" items, so here the problem is not just sort them by color but sort them by color and also get the distinct values in those colors.
I have tried a lot of formulas but all of them simply won't work the way i need them too I don't know if the black spaces or if the color background is what is messing things up.
I would really appreciate some help
What I need to do is, get the amount of duplicate values that are in a column, for example
In this table I need to do this calculation
All the repeated values in the Column "L" are basically a single Item, but due to format reasons they need to repeat the row and add some extra info to that row, but I'm not taking that into account
So we can say that the repeated values in column A are a single item, but are a different kind of item due to modifications, so this we call them as ITEMS TYPE A
The Items that have unique values are also items but without any modifications so the don't repeat but we call this items ITEMS TYPE B
So here what I need to do is get the amount of ITEMS TYPE A that are in the column, only the type A just by looking at the image there are 12 items TYPE A in the image
I also need to get the amount of TYPE B items, again just by looking at the image there are 10 items TYPE B
I also need to get the total number of items there are in general so TYPE B and TYPE A,
I have tried a bunch of formulas that i found online, but I think these only count the total amount of duplicate values in the column, so intead of giving me 12 TYPE A items it gives me 28 which is the amount of duplicated cells.
For the type B items I haven't tried it
But the count of Type A and B items I tried using this formula but it wont work properly, it gives me 10 instead of 11, not sure if it is for the blank spaces or due to the background color
I'm really desperate to get this i have tried a lot of formulas, but those simply won't get me the data I actually need. I also need to kida sort the colored cells, because the grey cells are "cancelled" and the white ones are "active" so later I'm gonna need to get the amount of "cancelled" and and "Active" items, so here the problem is not just sort them by color but sort them by color and also get the distinct values in those colors.
I have tried a lot of formulas but all of them simply won't work the way i need them too I don't know if the black spaces or if the color background is what is messing things up.
I would really appreciate some help