MacRumors Forums Resolved: Numbers Equation Help...
 User Name Remember Me? Password

 Thread Tools Search this Thread Display Modes
 Mar 27, 2013, 08:56 AM #1 ArtOfWarfare macrumors 603     Join Date: Nov 2007 Numbers Equation Help... I don't normally consider using Excel or Numbers to be programming but I know other people do and I feel like this might be beyond the people who frequent the other sections of the forums so here goes. I want to be able to write a simple spreadsheet for calculating my grade in a class that has the following 3 input columns: A: Names for all my assignments B: The grades I got on each assignment C: A list of weights Now here's where it gets a bit confusing: The weight and grade in a given row aren't necessarily related to each other. Instead, the highest grade in column B gets the highest weight in column C, the second highest grade in column C gets the second highest weight in column C, and so on. I don't want the table sorted automatically by any column (I'll manually drag stuff around as necessary.) I want an output column D which contains B, from the same row, multiplied by the correct value from C, as described in the preceding paragraph. Does anyone know how I can do this in Numbers? I've looked up and down the available functions nothing is jumping out at me. Edit: Naturally, it's right when I post the question after weeks of searching that an idea comes to me... I see there's a RANK function and an INDEX function... I feel like between these two things I almost have an answer... Actually, never mind, I just found an even more obvious function, LARGE... D = B * LARGE(C:, RANK(B, B:, TRUE)) Now I just need to remember how exactly formatting equations works and this will be totally solved... Edit 2X: All done! Here's what the properly formatted formula looks like: = (Scored Set 1) * LARGE((Available Weights), RANK((Scored Set 1), (Scored))) It seems that getting the value from a specific cell in the same row of a different column is just ( ) and getting all the values from a specific column is just (). Edit 3X: Actually... it's not quite done yet... given multiple scores of equal value, it'll consider them to have the same rank, and so a single weight could be used multiple times. I may have to hack together a solution... __________________ Don't tell me Macs don't last: 2007 iMac, 2007 Mac Mini, 2008 MacBook Air, all Vintage. (iMac obsoletion: April 28, 2015, MBA: October 14, 2015, Mac Mini: March 9, 2016) Last edited by ArtOfWarfare; Mar 27, 2013 at 10:01 AM. 0

 MacRumors Forums

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Similar Threads thread Thread Starter Forum Replies Last Post Knisse Mac Basics and Help 0 Oct 25, 2013 10:08 AM clyde2801 MacBook Air 13 Sep 17, 2013 05:19 PM jcmguitar iMac 12 Dec 19, 2012 02:52 PM badboyz31 iPad Apps 3 Jul 26, 2012 06:05 AM

 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home News and Article Discussion     MacRumors.com News Discussion     Mac Blog Discussion     iOS Blog Discussion iPhone, iPod, iPad, Apple Watch     iOS         iOS 8         iOS 7         iOS 6         iOS 5 and earlier         Jailbreaks and iOS Hacks     iPhone         iPhone Tips, Help and Troubleshooting         iPhone Accessories         iPhone Launch Meetups         iPhone Wallpapers etc.         iPhone Apps     iPad         iPad Tips, Help and Troubleshooting         iPad Accessories         iPad Launch Meetups         iPad Wallpapers etc.         iPad Apps     iPod touch         iPod touch Hacks         iPod touch Accessories         iPod touch Apps     iPod     Apple Watch         Apple Watch Accessories         Apple Watch Apps     Alternatives to iOS and iOS Devices Apple Applications     iPhone and iPod touch Apps     iPad Apps     Apple Watch Apps     Mac Applications and Mac App Store Apple Hardware     Desktops         iMac         Mac Pro         Mac mini     Notebooks         MacBook         MacBook Pro         MacBook Air     PowerPC Macs     Apple TV and Home Theater     Mac Peripherals     Buying Tips and Advice Apple Systems and Services     Mac Basics and Help     OS X         OS X Yosemite (10.10)         OS X Mavericks (10.9)         OS X 10.8 Mountain Lion         Mac OS X 10.7 Lion         Mac OS X Server, Xserve, and Networking     iCloud and Apple Services     Windows, Linux & Others on the Mac     Programming         iPhone/iPad Programming         Mac Programming         App Store Business, Legal and Marketıng Special Interests     Mac and PC Games         Console Games     Digital Audio     Visual Media         Design and Graphics         Digital Photography         Digital Video         Web Design and Development     Apple Collectors     Distributed Computing Mac Community     Community Discussion         Apple, Industry and Internet Discussion         Current Events         Politics, Religion, Social Issues     Picture Gallery         UI Customization     Site and Forum Feedback         Mac Guides Private Forums Archive     Wasteland     Archives of Old Posts         MacRumors News Discussion (archive)         MacBytes.com News Discussion         Buying Tips, Advice and Discussion (archive)         Community         Daily Tunes Site Discussion and Feedback         Event Archives             Macworld San Francisco 2008         Games         General Mac Discussion         Hardware Rumors         iPhone Purchaser Meetups         Leopard Event Meetups         Mac Help/Tips         Mac OS X 10.3 (Panther) Discussion         Mac Scene         Macintosh Computers         MacRumors Old Skool         Marketplace Archive 1 (Posts count)         Marketplace Archive 2             iPhone Marketplace Archive         Music Discussion         New Mac Application Announcements         Product Recommendations/Reviews         Site News         Switch Stories         Web Design and Development (archive)         Past Contests             1,000,000 Post Contest             2,000,000 Post Contest             3,000,000 Post Contest             4,000,000 Post Contest             5,000,000 Post Contest             Ten Million Post Contest

All times are GMT -5. The time now is 12:41 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps
 Contact Us - MacRumors Forums - Archive - Privacy Statement / DMCA Agent - Top

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2015, MacRumors.com, LLC