Extract Data_Under certain Criteria

[manuel1991]

Hii!

I need a vba code to extract all of the dates that contain a "Yes" but also extract the complete list of dates.
See that only the 3-Jan-11 is repeated because it contains 2 "Yes". If it contains 3 "Yes" it will be repeated one more time and so on with all of the dates.

Sometimes the date not contain a Yes or No.

Here is an example:

Original Data:

2-Jan-11 Yes
3-Jan-11 Yes
3-Jan-11 No
3-Jan-11 Yes
4-Jan-11 No
5-Jan-11 No
5-Jan-11 Yes
6-Jan-11 No
7-Jan-11
Extract Data:

2-Jan-11
3-Jan-11
3-Jan-11
4-Jan-11
5-Jan-11
6-Jan-11
7-Jan-11

[arlu1201]

Your question is not very clear. Can you try explaining with some more details?

[manuel1991]

Hii

I need to extract all of the dates from a list of dates. But if a Date contains a Yes in the second column, duplicate it if is more than one Yes like the 3-Jan-11.

Or you can see in another way: Extract all of the dates that contains a "Yes" in the second column, but also includes only one time all of those dates that contains a "No" or a blank.

In the next example I extract all of the dates, but the 3-Jan-11 is duplicated because it contains two "Yes". Did you understand more now? Let me know.

2-Jan-11 Yes
3-Jan-11 Yes
3-Jan-11 No
3-Jan-11 Yes
4-Jan-11 No
5-Jan-11 No
5-Jan-11 Yes
6-Jan-11 No
7-Jan-11
Extract Data:

2-Jan-11
3-Jan-11
3-Jan-11
4-Jan-11
5-Jan-11
6-Jan-11
7-Jan-11

I have this code, but it only counts the dates that have a "Yes".

Please Login or Register  to view this content.