

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
DW Simpson Global Actuarial & Analytics Recruitment 

Thread Tools  Search this Thread  Display Modes 
#11




Quote:
As for the people who submitted formulas, i'll try them later and see if they work. Thanks for all your input 
#12




yall are lazy
put this in C1 =IF(SUMPRODUCT(($A$1:$A$8=A1)*($B$1:$B$8=B1))=1,FA LSE,TRUE) drag down, adjust ranges if needed
__________________

#13




Quote:
Countifs($a$1:$a$8,a1,$b$1:$b$8,1), and then filter on the 1's. alternatively take your formula out of the if, and also filter on the 1's 
#14




Did you verify that your solution works before calling other people lazy?

#16




Quote:
I thought s/he wanted a oneformula method. and I was calling the remove duplicates/sort thing lazy lol
__________________

#17




Quote:
Step 1) Destroy the data
__________________
the president replied, "I don't care. I believe Putin." 
#18




You should have checked twice.
Quote:

#19




Use an array. If the minimum B column value for a particular A column value is different to the maximum, then you have more than one distinct value. Copy this formula down column C (using Ctl + Shift + Enter, when you enter it in C1) 
{=IF(MIN(IF($A$1:$A$8=A1,$B$1:$B$8))<>MAX(IF($A$1: $A$8=A1,$B$1:$B$8)),1,0)} 
Thread Tools  Search this Thread 
Display Modes  

