How to filter depending on values in different columns and the same time

[ALBA]

Hello:

First of all , thank you for your time and for your great website.
I have an spreadsheet that I need to sort and extract data depending on the values in different columns

Let say I have

Col1 Col2 Date1 Date2 Date3

The first thing I need is to identify all rows that have Column Date1 with a date( not blank) and date 2 and date 3 are blank

The 2nd part is identify all row with Date2 and Date3 with a date ( not blank)

And the 3rd one is identify all rows with date1 date 2 and Date3 with dates ( not blank on any of them)

Can you pls help me???
Thanks a lot

 

[Somendra Misra]

Hi Alba,

Welcome to the chandoo forum.

It would be good if you can upload a sample file.

Regards,

 

[ALBA]

Hello:

First of all , thank you for your time and for your great website.
I have an spreadsheet that I need to sort and extract data depending on the values in different columns

Let say I have

Col1 Col2 Date1 Date2 Date3

The first thing I need is to identify all rows that have Column Date1 with a date( not blank) and date 2 and date 3 are blank

The 2nd part is identify all row with Date2 and Date3 with a date ( not blank)

And the 3rd one is identify all rows with date1 date 2 and Date3 with dates ( not blank on any of them)

Can you pls help me???
Thanks a lot

 

[Somendra Misra]

@ALBA

See the attached file I Had added three more columns give TRUE & False based on your three condition above, now what is your final goal?

Regards,

 

[ALBA]

@ALBA

See the attached file I Had added three more columns give TRUE & False based on your three condition above, now what is your final goal?

Regards,

I have to separate the information based on each condition:

- Separate all rows that have Filing Date and Serve Date and JDG Date are blank
- Separate all rows that have Serve Date and JDG Date
- Separate all rows that have all Filing, Serve and JDG Date

 

[Somendra Misra]

And where do you want to extract this data?
Regards,

 

[ALBA]

@ALBA

See the attached file I Had added three more columns give TRUE & False based on your three condition above, now what is your final goal?

Regards,

I was checking the formula , and I dont think is working properly???? For example...
On Condition1 =AND([@[FILING DAT]]<>"",[@[SERVE DATE]]="",[@[JUDGMNT DT]]="") , that means...if there is a date on Filing Date and serve date and judgm date are blank, then the result should be True , right????

 

[Somendra Misra]

Yes but in your data in some cells where you are seeing as blank actually there is a white space. Means "" this TRUE blank and " " is there in your cell. Press F2 in cell G20 And H20 you can see it, I think In one cell if you press Backspace key it will be deleted and in other it will not.

Regards,

 

[ALBA]

Yes but in your data in some cells where you are seeing as blank actually there is a white space. Means "" this TRUE blank and " " is there in your cell. Press F2 in cell G20 And H20 you can see it, I think In one cell if you press Backspace key it will be deleted and in other it will not.

Regards,

yes you were right i was able to fix it... now i have all my condition columns working... Now I want to separate all the row that have True on Condition 1, and then do the same for Cond 2 and 3. How do I do that?

 

[Somendra Misra]

We can do it in a couple of ways:
1. Advanced filter
2. Formula
3. VBA

If you can layout your desired output and suggest a method we can show a method to do it.

Regards,