Where cluase filter based on data

[#1]

Hi All,

             This requirement seems easy to most of them, but i need this as i attached in excel with input and output, Please put your valuable answers on it.

Regards,

Ravi.

[jagan]

Hi,

Check the attached file for solution.

Regards,

jagan.

[#3]

Hi Jagan,

              I really appreciate your work, for this input of data output is correct and let me use the same thing in my live data and get back to u on it. Hopefully it will work there too.

Regards,

Ravi.