if query
Hi all,
in sheet1 i have data like, A B C D E Name STD Roll Area Present 1 john 80 123 America Y 2 mike 90 456 Apac N 3 daniel 91 789 EMEA Y 4 barken 92 345 America Y 5 mark 93 765 apac N 6 brain 94 986 America N Result i requried, Sheet2 - Rename as America first has check the column(E) its present(=Y) means and have to check column(D) is equal is to (america) means entrie row should be copy and paste in the sheet A B C D E Name STD Roll Area Present 1 john 80 123 America Y 2 barken 92 345 America Y Note : result should come in continuely that means, result should be come like 1row and 2row..... In this case i requried only formula, kindly avoid macro. Regards Ahamed |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com