Excel Formula Curiosity - Actuarial Outpost

		Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
Excel Formula Curiosity

Meet the Employees of D.W. Simpson & Co.
Lindsey Nelson, Becki Tobia, Angie Wachholz, Diane Vanik, Katherine Hays
Alex Babic, Paul Castro, Steve Davis, Lesley Traverso, Tom Troceen, James Lecoutre
Aaron Benton, K.C. Cho, Patty Jacobsen, Dave Simpson, Bob Morand, Dave Retford, Carol Datu
Maureen Matous, R. Hicks, Marianne Westphal, Kim Skora, Kristyn Sakelaris, Ellen Hoppenjan
James Gardner, Lorraine Cully, Sarah Cleveland, Bethany Rave, Amy Trapp, David Benton, Jennifer Retford
Dan Karrow, Ginger Hassler, Rhonda Glick, Bryan Duffy, Derek Mulder, Barclay Burns, Barb Rave
Chris Hicks, Valorie Etheridge, Tom Munar, Julie Garwood, Margit Vogele

Thread Tools

Display Modes

12-28-2006, 01:56 PM

Expunge

Member

Join Date: Jul 2003

Posts: 8,674

Excel Formula Curiosity

I just used the formula =SUM(LARGE(C4:C16,{1,2}))

just curious if i wanted to sum more than the top 2 values if there is a much better way of doing this. say the top 1000 values. Potential ties exist at the cutoff point exist.

__________________
John 3:16

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded 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 07:48 PM.

Page generated in 0.28299 seconds with 6 queries