Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |