Hi,
I want to extract a list of rows that fulfills both the condition.
If any row suppose N2="No" and BQ2="Yes",then extract whole row,
or,
If any row suppose N2="Yes" and BQ2="No",then extract whole row,
Similarly,likewise other rows as well.
Hi,
I want to extract a list of rows that fulfills both the condition.
If any row suppose N2="No" and BQ2="Yes",then extract whole row,
or,
If any row suppose N2="Yes" and BQ2="No",then extract whole row,
Similarly,likewise other rows as well.
Hi!
Could you attach your excel file.
One sheet with the raw data and another with the desired output.
Pls find in attachment.
Put into A2 on 'Exp Desired result':
Formula:Please Login or Register to view this content.
drag right and down as You need.
IMHO works fine.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Try this code
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you.
This macro will work as you described and add the data to a "Result" sheet. See attachment.
Code below (also in the attached workbook)
Please Login or Register to view this content.
try
Please Login or Register to view this content.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
Thanx all of you.It worked.Additional query mentioned here earlier in post#8 has been removed by me as it seems to be complicated.
Last edited by paradise2sr; 02-03-2019 at 06:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks