Macro with Formulas

[negskord]

Hello,

I have a large dataset that I am trying to create a macro for. I want excel to do the following:

If cell F2 says "Match" and cell G2 says "Yes", then drag drag cell P2 to P3. (currently cell P2 may say an ethnicity, but cell p3 says 'not specified'. If the first two criteria are met (Match, Yes), then I cell p3 should have the matching ethnicity instead of 'not specified. Sample.jpg

I want this pattern to repeat in the entire data set which is over 19k lines.
Please advise with a formula. And how to have the macro repeat all the way down.

Thank you so much!

[Squeaky]

Hi negskord,
If the ethnicity is the same down the entire spreadsheet, you can put in P3 =if(and(f2="match",g2="yes"),P2,"Not Specified"). Then select P2 and P3, and drag/copy down to the bottom of your spreadsheet, or you can try selecting P2 and P3, then place your cursor over the bottom right corner square, and when you see the mouse show +, double click (fast) and it will copy down the length of the form as long as there are no spaces on both sides of the column.
If your ethnicity changes as you go down, copy paste values the entire P row to a new unused column (example the Z column), then in P2 put =Z2. Then copy P2 and P3 down. Hide Z if you want.
-Squeaky

[jolivanes]

Looks like you could AutoFilter on 2 Columns ("Match" and "Yes") and follow it up with:

Please Login or Register  to view this content.

If you don't have it solved by the time I get back (from the dentist!!!), I'll have a look.

[jolivanes]

Please Login or Register  to view this content.

[jolivanes]

Another possibility within memory. Should be faster.

Please Login or Register  to view this content.