excelhjalp
New Member
- Joined
- Aug 7, 2018
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hello! I couldn't find any answers by googling the following question, and am hoping you guys can help me.
My problem is this:
In A column I have identidy numbers. They can vary from being one to several dozens in the column.
In column B I have a certain type of number, it can vary from 1 to 999.
In column C I have the same numbers and I have in B (1-999), but they have different meaning.
In column D I have either yes (Y) or no (N).
A: B: C: D:
-------------------------------------------
1: 111111 123 321 N
2: 111111 222 321 N
3: 111112 111 100 N
4: 111113 444 49 N
5: 111113 444 49 Y
6: 111113 111 65000 N
If an identidy number appears more than once, and two of the rows of the number have the same number for B and C column, and "Y" does not appear in one of them, I want to be able to filter them out from the several thosands of rows I am dealing with.
With a hope for answers and a kind regards,
My problem is this:
In A column I have identidy numbers. They can vary from being one to several dozens in the column.
In column B I have a certain type of number, it can vary from 1 to 999.
In column C I have the same numbers and I have in B (1-999), but they have different meaning.
In column D I have either yes (Y) or no (N).
A: B: C: D:
-------------------------------------------
1: 111111 123 321 N
2: 111111 222 321 N
3: 111112 111 100 N
4: 111113 444 49 N
5: 111113 444 49 Y
6: 111113 111 65000 N
If an identidy number appears more than once, and two of the rows of the number have the same number for B and C column, and "Y" does not appear in one of them, I want to be able to filter them out from the several thosands of rows I am dealing with.
With a hope for answers and a kind regards,
