Apologies for the incomplete question.
I want to ignore the row having all blank values. so as a result i want only 1st and 2nd row.
But the condition where A<>'' and B<>'' and C<>''; doesn't work, however the condition mentioned by Dinesh
not (A='' and B='' and C=''); works. Can anybody explain why?
Thanks and Regards,