Actuarial Outpost
 
Go Back   Actuarial Outpost > Cyberchat > Non-Actuarial Topics
Reload this Page 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 & Co
Worldwide Actuarial
Recruitment

Entry Level Jobs
Casualty, Health,
Life, Pension,
Investment --
Insurance / Consulting

Asian Jobs
Hong Kong, China, India, Japan, Korea, Indonesia, Singapore,
Malaysia, and more

Registration Form
Be Notified of
New Actuarial Jobs

Reply
Page 4 of 6 < 1234 56 >
 
Thread Tools Display Modes
  #31  
Old 05-04-2012, 11:13 AM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is online now
Member
  
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 35,657
Default
Quote:
Originally Posted by MountainHawk View Post
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.
Reply With Quote
  #32  
Old 05-04-2012, 11:23 AM
Anthemyst's Avatar
Anthemyst Anthemyst is offline
Member
SOA 		 
Join Date: Jun 2010
Location: Springfield, MA
Studying for MLC
Posts: 6,884
Default
Quote:
Originally Posted by MountainHawk View Post
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
Reply With Quote
  #33  
Old 05-04-2012, 11:45 AM
campbell's Avatar
campbell campbell is offline
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
Default
Quote:
Originally Posted by MountainHawk View Post
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.
Reply With Quote
  #34  
Old 05-04-2012, 11:50 AM
ElDucky's Avatar
ElDucky ElDucky is offline
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
Default
What's wrong with Sumproduct? Nothing, that's what.
Reply With Quote
  #35  
Old 05-04-2012, 11:53 AM
FattyMcGee's Avatar
FattyMcGee FattyMcGee is offline
Member
  
Join Date: Jan 2007
Posts: 9,114
Default
Quote:
Originally Posted by SamTheEagle View Post
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.
Reply With Quote
  #36  
Old 05-04-2012, 11:56 AM
John Connor's Avatar
John Connor John Connor is offline
Member
  
Join Date: Jun 2010
Studying for Judgment Day
Posts: 893
Default
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
Reply With Quote
  #37  
Old 05-04-2012, 11:56 AM
MountainHawk's Avatar
MountainHawk MountainHawk is offline
Member
CAS AAA 		 
Join Date: Dec 2001
Location: Salem, MA
Studying for Nothing!!!!
College: Lehigh University Alum
Favorite beer: Yuengling
Posts: 55,661
Default
Quote:
Originally Posted by ElDucky View Post
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
Reply With Quote
  #38  
Old 05-04-2012, 12:09 PM
Coyoterine Coyoterine is offline
Member
SOA 		 
Join Date: Apr 2012
Posts: 628
Default
Quote:
Originally Posted by MountainHawk View Post
It has been replaced by countifs for the purpose it is being used for here.
Is that like being outsourced to India?
Reply With Quote
  #39  
Old 05-04-2012, 12:13 PM
asdfasdf's Avatar
asdfasdf asdfasdf is offline
Member
  
Join Date: May 2004
Location: My perception of reality
Studying for nication
Posts: 20,070
Default
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.
Reply With Quote
  #40  
Old 05-04-2012, 12:22 PM
Smart Actuary's Avatar
Smart Actuary Smart Actuary is offline
Member
  
Join Date: Sep 2011
Posts: 7,795
Default
Quote:
Originally Posted by asdfasdf View Post
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
Reply With Quote
Reply
Page 4 of 6 < 1234 56 >

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode 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.

Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.27534 seconds with 7 queries