inserting a 'rank' using settings/Excel... Help needed.

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.

Hello moose.....

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

Cheers

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
 

I still can't find anything that will work here. Anyone?

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.

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.

Thanks for all your efforts guys. Guess it,s time to brush up on VBA?
Moose