Pages:
Actions
  • #1 by moose on 31 Dec 2015
  • Hi,
    I import data into column N on my querysheets (horse races). I want to put a rank_order in column P by using settings/Excel or any other means. So far the best I can do is put

     
    Code: [Select]
    =RANK($N4,$N$4:$N$150,0)
    into cell P4, using settings/Excel and then fill down. Any ideas very welcome.
  • #2 by eduardoneco on 02 Jan 2015
  • Hello moose.....

    Have you try this: =RANK(N4,N$4:N$150,1)

    Cheers
  • #3 by londolozi on 02 Jan 2015
  • I did this in v7 but can't access my custom cells now.
    In Col: P put this in 1 of the three cells
    =RANK(cell_querymarket_id_N(sel_index*3+1),N$4:N$150,0)
    YOU may have to put and error capture IF statement preceding if the cell is null.

    In your trigger condition you can than use
    cell_querymarket_id_N(sel_index*3+1) equals 1
     
  • #4 by barniani on 04 Jan 2015
  • I still can't find anything that will work here. Anyone?
  • #5 by londolozi on 05 Jan 2015
  • Check the formulas in the spread sheets, are they showing as valid?
    Is excel accepting the customcell formula.

    Experiment with the cell_querymarket_id

    I've looked through all my past posts but I can't find the one where Oxa explained to me.
    It made sense. I don't use Excel Rank anymore but it was working fine. I can't read the xml files with my formulas in them from V7.

    Don't give up yet it can be done.


  • #6 by catwizud on 06 Jan 2015
  • HI Moose,

    I cannot check custom cells as my subscription is out and I am trying to get my head around the options before renewing.

    What I can confirm is that in Excel 2013 the function RANK() works.

    See attached png file.

    Formula = RANK(N4,N$4:N$13,1)

    Notice that the empty cells have #N/A, which is easily fixed.

    Hope this helps.
  • #7 by moose on 07 Jan 2015
  • Thanks for all your efforts guys. Guess it,s time to brush up on VBA?
    Moose
Pages:
Actions