Skip navigation

Ranking data in Numbers

291 Views 1 Reply Latest reply: Apr 18, 2013 11:51 PM by Barry RSS
SuperGeon Calculating status...
Currently Being Moderated
Apr 18, 2013 4:33 PM

Hello, I recently purchased an iPad 4 and the Numbers application. I normally do my spreadsheet work on a PC with Excel. I copied an employee rankings Excel spreadsheet over to Numbers and was given the following message.

 

Unsupported formulas were removed. The last calculated values were imported.

 

Everything in the spreadsheet looks correct except the ranking values are expressed three different ways in the three different columns.

 

Name     Overall Rank     Apples Sold     Rank     Oranges Sold     Rank     Bananas Sold     Rank    TOTAL

Mark              1                     5.2           300%           2.7                2          5.1                  1.00         13

 

So, even though the formulas are the same in all of the Rank columns, the rank results are expressed in very different ways

Numbers, iOS 6.1.3
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 18, 2013 11:51 PM (in response to SuperGeon)

    Hi SG,

     

    Looks like they're just formatted differently.

     

    Select each column listing ranks, open the Inspector, choose the Cell Inspector.

     

    Use the popup menu to select Number as the format, then set the number of decimal places to none.

     

    NOTE: Reply is specific to Numbers for Mac OS X. The steps should be similar for the iOS version, but the route t the Cell inspector is lkely different.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.