Rank every second cell

    I have a table that has a total (SUM) along the bottom at every second cell,


    What i would like to do would be to rank them 1-10


    but at the moment it looks like


    [TABLE="width: 592"]

    [tr]


    [TD="class: xl67, width: 134"]Ranking [/TD]
    [TD="class: xl68, width: 98"]2[/TD]
    [TD="class: xl68, width: 90"]#N/A[/TD]
    [TD="class: xl68, width: 94"]1[/TD]
    [TD="class: xl68, width: 84"]#N/A[/TD]
    [TD="class: xl68, width: 92"]#N/A[/TD]

    [/tr]


    [/TABLE]

    Re: Rank every second cell


    It would be better if you can give a full example so we can see why you are getting the #N/A errors in the first place.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Re: Rank every second cell


    [ATTACH=CONFIG]68537[/ATTACH]


    Please find attached an excerpt of my excel sheet, in it i have an area where the user of the form would enter the percentage and this then totals in the cell next to it, i then want the total column ranked based on score.

    Re: Rank every second cell


    Try something like:


    [COLOR="#0000FF"]=IF(C9="","",RANK(C9,$C$9:$H$9))[/COLOR]


    adjust references and ranges to suit.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login