Excel: Mark duplicate values by filter?
Good morning!
The question says it all.
I have the following list:
The conditional formatting already marks two entries.
Now I would like the conditional formatting to display the duplicates based on the filter.
Unfortunately, that doesn't work.
I have also tried it with such formulas;
=UND(ZÄHLENWENN($C:$C; C1) > 1; TEILERGEBNIS(3; C1))Unfortunately it doesn't work so far.
For your information, this is column C.
The data is loaded from JSON and is modifiable. Therefore, formatting the column would be great.
Thank you if you can help me. 🙂
(1 votes)
Loading...
Add to this
Alex
Then nothing is marked at all.
Ashes on my head. Of course not. I ran into an old Excel shell. VISIBLE is a self-written VBA function that is not implemented natively in EXCEL:
This should
I’ll go.
Moin, I just tried. Doesn’t work. No more lines are stored.
I assume that the vote on various decks, etc. should be taken.
I would therefore designate the condition for conditional formatting in a “search field” and of this the function e.g. =WENN(C1=G$1; NUMBERS(C:C;G$1);” (in an auxiliary column).
The result, for example, >1 would then be used for the Conditional Formatting.
Simply mark column and …
No, this should only be duplicates of a column to compare whether one of the ancestors is present and whether the horses can be paired.
There can and must not be a search here, especially since we want to compare several animals at the same time.
see picture in the answer
Of course not if you filter by column A. Why don’t you filter according to column C… and then, for example, by color red
Yes and this does not fulfill her job because she ignores the filter. See pictures..
There is also the necessary formatting. So far we were already
It is about the color mark, not the display of entries.
It’s easy to find out about the car filter and to present it. Select the ancestors and all reference animals are displayed.
This is not relevant here. It’s just about watching the two animals share ancestors. The generation doesn’t matter here.
You have the opportunity to introduce several generations (fathers, grandfathers, great-grandfathers, etc.) into different columns and thus represent a kind of (seed)an gallery.
There’s only one filter – by name. You select two animal names and get several posts as the same horses each have several ancestors.
The duplicates of the ancestors should then be stored in color. However, the current filter view should be used.
In the example, it was only Foal Doe to clarify the problem. Because there is no duplicate, but it is displayed.
You want several filters for several criteria… and everything in one?
What are you missing?
As I said:
I have a list of values that duplicate can be. Depending on which filter I have active, the duplicates should be stored dynamically in accordance with the filter.
This is actually perfect on the basis of the picture of my question. On the first picture: Right. On the second: Wrong, as there is no duplicate in the view.
That’s not how we get on.
Either it becomes more concrete, (for me) more understandable or I am outside.
No, the data is further formatted, which they should not.
In the example shown, the display together with conditional formatting takes place very flexibly. Basically also filtered.
In addition, the autofilter can be used to select/filter the formatted cells by color.
That the colors are removed or occur according to the filter. I want to have double values if they are in scope. I mean, if I were to show all, the double values would be displayed, I select a horse with one of these double values, should it no longer be marked in color.
What dynamic do you want?
Don’t give me anything because it ignores the filter and/or is not dynamic.