3. Remove duplicates from Column A, but only remove the duplicates that have Blank ...

Remove duplicates from Column A, but only remove the duplicates that have Blank entries in all other columns

A1:C21

URL Keep? Stuff
www.USRoboticsandMechanicalMen.org Chaff
www.TipTopCafe.edu Wheat XYZ
www.FakeBrothers.edu Wheat XYZ
www.AcmeInc.com Chaff
www.AlliedBiscuit.org Wheat XYZ
www.Compuglobalhypermeganet.edu Chaff
www.Roxxon.edu Wheat XYZ
www.MammothPictures.com Wheat
www.ZiffCorp.com Wheat XYZ
www.AcmeInc.com Wheat XYZ
www.Roxxon.edu Chaff
www.AcmeInc.com Chaff XYZ
www.TipTopCafe.edu Chaff XYZ
www.SiriusCyberneticsCorporation.com Wheat XYZ
www.USRoboticsandMechanicalMen.org Wheat XYZ
www.GalaxyCorp.com Wheat
www.FakeBrothers.edu Chaff XYZ
www.AcmeInc.com Chaff XYZ
www.AlliedBiscuit.org Chaff XYZ
www.Compuglobalhypermeganet.edu Wheat

with B2

=IF(COUNTIFS($A$1:A1,A2,$B$1:B1,"Wheat")=0,IF(COUNTIF($A$2:$A$21,A2)<>COUNTIF($A$2:A2,A2),IF(AND(C2:Z2=""),"Chaff","Wheat"),"Wheat"),"Chaff")

entered as an array function, control+shift+enter, and filled down. Sort by B. Keep the wheat, delete the chaff.

/r/excel Thread
Previous
Next

Recently removed from /r/excel

Excel Solver either keeps changing the answer or gives the same wrong answer. How do you get rid of the blasted format painter icon that obscures text - Excel/Mac 16.72 - Microsoft 365 What’s the easiest way to share an excel document with Reddit? How do I set a character max and format? Calculate total number of years months and days from already calculated set of individual results displayed as years months and days. Dynamic Scheduling Based on Rotation and Start Day Is there a way to turn my date range in text form to a two-column number form date range? Is there any way to freeze the top row by default or otherwise save the state of frozen cells? Why is my rounding bugging? Vlookup issue with value that exists completing the excel exposure Complicated MOD function that possibly might just be algebra.. Comparing two workbooks for differences Microsoft Money for Excel released today How do I insert a number of blank rows between every row of data, and then copy each row down?

More Random Comments

A true purpose of the recently erected statue in Warsaw, Poland YouTube Captions have Revealed the Truth!!! Crimes are no longer a disqualification for Republican candidates EM LAMEGO COM AS OPERAÇÕES ESPECIAIS DO EXÉRCITO (II) Who TF raised y’all? Genghis Khan?? Any toolkits for creating games? The MyDigitalSSD SBX SSD Review: NVMe On The Cheap Save 25% on car insurance with one weird trick Kanye thinks slavery was a choice Delays on everything now... Ofo joins Spin and LimeBike warning Seattle riders of brake lines deliberately cut Why do we have Magic Johnson over Kobe when discussing who's better all time when Kobe Bryant is a better over all player than him? PayPal is trying to say I need to pay my account’s negative balance for an unauthorized transaction. Inexpensive meal ideas (lunch) for 8-13 people. I'm in love with this person. He has difficult character, is that related with his chart? And is there anything that i should be aware of?