Actuarial Outpost treat for excel geeks
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

 DW Simpson & CoWorldwide ActuarialRecruitment Entry Level JobsCasualty, Health, Life, Pension,Investment --Insurance / Consulting Asian JobsHong Kong, China, India, Japan, Korea, Indonesia, Singapore,Malaysia, and more Registration FormBe Notified of New Actuarial Jobs

#31
05-04-2012, 11:13 AM
 ADoubleDot Member Join Date: Nov 2007 Location: Slightly Dusty South Studying for the rest of my life Posts: 35,657

Quote:
 Originally Posted by MountainHawk The sign function makes it obvious what you are doing. You are comparing the signs. Abs just makes the answer 1 or 3 instead of 1, -1, 3, -3 for easier comparsion.
yes, i know how excel works.

just not sure what function you would have me use since SUMPRODUCT is so 9 years ago when you are using cutting edge formulas like SIGN
__________________
def no_one(the_spanish_inquisition):

**** Juan.
#32
05-04-2012, 11:23 AM
 Anthemyst Member SOA Join Date: Jun 2010 Location: Springfield, MA Studying for MLC Posts: 6,884

Quote:
 Originally Posted by MountainHawk Only reason to use the sumproduct is if you are still using Excel 2003, and what kind of loser actuary is still using Excel 2003?
__________________
. . . . . . . .
P FM MFE MLC C
#33
05-04-2012, 11:45 AM
 campbell Mary Pat Campbell SOA AAA Join Date: Nov 2003 Location: NY Studying for Japanese Favorite beer: Murphy's Irish Stout Posts: 36,298 Blog Entries: 5

Quote:
 Originally Posted by MountainHawk Die in a fire ... array functions are the source of evil.
I wouldn't say they're a source of evil, but if someone needs help coming up with a formula for something like this, I wouldn't trust them to use array functions properly.
__________________

Now offering online seminars, live seminars, and everything else under the sun for actuarial exams.
#34
05-04-2012, 11:50 AM
 ElDucky Free Mason CCA Join Date: Jul 2004 Location: In a van down by the river Studying for Jeopardy Favorite beer: Space Coyote Posts: 25,592

What's wrong with Sumproduct? Nothing, that's what.
#35
05-04-2012, 11:53 AM
 FattyMcGee Member Join Date: Jan 2007 Posts: 9,114

Quote:
 Originally Posted by SamTheEagle Mine's the most elegant so far.
you didn't define "elegant", so nobody can decide that for you.
__________________
"I'm a man! I'm forty!"
Winner of the 2012 Riskie for Thread of the Year.
Winner of the 2012 Riskie for NAT/Reef Poster of the Year.
#36
05-04-2012, 11:56 AM
 John Connor Member Join Date: Jun 2010 Studying for Judgment Day Posts: 893

type this in A17:

"Hi Excel, its me again. Long time, how are you? I'm good, a little sleepy. I miss you buddy. Anyway, hey, I'm trying to figure out if the signs are the same in all the columns. Can you please hook a brother up and figure that shit out for me? You're the man, bra. See you at the BBQ this weekend."
__________________
No fate but what we make
#37
05-04-2012, 11:56 AM
 MountainHawk Member CAS AAA Join Date: Dec 2001 Location: Salem, MA Studying for Nothing!!!! College: Lehigh University Alum Favorite beer: Yuengling Posts: 55,661

Quote:
 Originally Posted by ElDucky What's wrong with Sumproduct? Nothing, that's what.
It has been replaced by countifs for the purpose it is being used for here.
__________________

"I am a most unhappy man. I have unwittingly ruined my country. A great industrial nation is now controlled by its system of credit. We are no longer a government by free opinion, no longer a government by conviction and the vote of the majority, but a government by the opinion and duress of a small group of dominant men." -- Woodrow Wilson

It doesn't matter who you vote for, the government always gets in. -- Elizabeth May

???? Jan 20: Freedom for the Bill of Rights

1 2
#38
05-04-2012, 12:09 PM
 Coyoterine Member SOA Join Date: Apr 2012 Posts: 628

Quote:
 Originally Posted by MountainHawk It has been replaced by countifs for the purpose it is being used for here.
Is that like being outsourced to India?
#39
05-04-2012, 12:13 PM
 asdfasdf Member Join Date: May 2004 Location: My perception of reality Studying for nication Posts: 20,070

I can't solve it in Excel, but I can lend you the intern to go count it by hand.
__________________
Your own conciousness blinds you to the true existence of all things external to it.
#40
05-04-2012, 12:22 PM
 Smart Actuary Member Join Date: Sep 2011 Posts: 7,795

Quote:
 Originally Posted by asdfasdf I can't solve it in Excel, but I can lend you the intern to go count it by hand.
I have more than 10 columns. More than 20 too.
__________________
I've always had a problem with the average macho man; they've always been a threat to me - Kurt Cobain

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -4. The time now is 03:46 AM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top