Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if query2- urgent requried
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if query2- urgent requried
Copy/paste means macro. If you don't want macros just use datafilterfilter
on y and America -- Don Guillett Microsoft MVP Excel SalesAid Software "deen" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Urgent please help!! | Excel Discussion (Misc queries) | |||
Sum IF-Urgent! | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
not urgent | Excel Discussion (Misc queries) |