Forum Discussion
Custom Filter function
Hi guys, I am looking for a custom filter function A1 1 2 A2 1 2 A3 1 2 A1 1 2 A4 1 2 A1 1 2 A2 1 2 A2 1 2 I have sth similar to above table alr...
If I understand the translation correctly, look for a way to keep duplicates and delete individual entries.
If so, here is an example with VBA in the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hi Nikolino,
thanks for the answer - in retrospective my wording was maybe not correct. I want to keep all lines which are listed more than 2 times, i.e. delete all entries with only one or two lines. So keep everything =>3 and delete the others --> so the problem is that I do not simply need to delete individual entries.
The filter would also need to be within Power BI (i.e. the query I set up) otherwise it will make the whole automated output useless.
thanks for the answer - in retrospective my wording was maybe not correct. I want to keep all lines which are listed more than 2 times, i.e. delete all entries with only one or two lines. So keep everything =>3 and delete the others --> so the problem is that I do not simply need to delete individual entries.
The filter would also need to be within Power BI (i.e. the query I set up) otherwise it will make the whole automated output useless.
- Regarding Power BI, unfortunately I can't help you. My knowledge in this area is very limited.
Maybe, one of the specialists here who are very familiar with Power BI could help you.
I wish you continued success with Excel
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)