Large and Small

[matthewlouis]

I have a column of numbers I want to rank large to small. Large(E4:E37,1), etc..... but I'm getting a #NUM error. The cells I am ranking are linked to another tab in the workbook. In other words, it says 28% in Cell C3 . . . but what's in the cell is not 28% but the cell in another tab referenced as "XLB Cube'!$C$3 (that's where 28% is)

I even tried to name the cell range using the NAME function and then tried again . . . same thing, #NUM . . . I would like to have them rank as they change, too.

Does anyone have any suggestions?

Thanks in advance!!

 

[Fluff]

What exactly is in those cells?
With C3 what does =LEN(C3) return & what is in c3

 

[matthewlouis]

C3 contains a link to the XLB Cube tab that has a formula =TEXT(I119+J119,"0%").

I think that's the problem. I'll fix that and I believe that will do it. Thanks!

 

[Fluff]

You need to do it on the actual data (ie on the XLB Cube sheet), not on the link to that data.
That said, the reason you your numbers are not numbers is because of the formula that you are using.
=TEXT function returns a Text value.
Try using =I119+J119 and formatting the cell as percantage

 

[matthewlouis]

Yes!! Thanks, Fluff, for al your help, that TEXT thing was the problem. Appreciate it!

 

[Fluff]

You're welcome & thanks for the feedback