# XL2007 new Function Parameter CELL("coord";ref)

#### galileogali

##### Well-known Member
Somebody know how works the function CELL("Coord";Reference)?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Interesting...

How did you get this parameter value? I cannot find it documented in any of my usual places.

The result I get is something very bizarre. It is always \$A:{cell referred to in the function} such as \$A:\$G\$2. It doesn't look like a valid range reference, does it?

So, unless someone else can make sense of the parameter value, I'd guess it's an error. Might be something left over from something MS was thinking of adding but didn't quite do it thoroughly.

Tushar:
(jeje)
very bizarre...good definition!!
You can find this issue in the help of Excel 2007.
You can to begin with the "Add Function Icon", together the formulas-Bar.
I"ve got a Spanish Office version.

It's not new to 2007. As far as I know it returns the cell reference in Lotus format - i.e. it's the equivalent of @COORD (whatever that does!)

Ah! Thanks for that info.
It's not new to 2007. As far as I know it returns the cell reference in Lotus format - i.e. it's the equivalent of @COORD (whatever that does!)

Somebody know how works the function CELL("Coord";Reference)?
Hi!

This function is available in Excel97...2003, 2007 as well, but the 1st string parameter depends from localization.

You can use, for example: "ROW", "COLUMN", "ADDRESS" parameter as you can type it in the Excel formula, taking into account localization.
Check its exact typing in Excel help for the CELL() function.

Examples for English version of Excel:
=CELL("ROW",D3) returns 3
=CELL("COL",D3) returns 4

For Spanish version use ";" instead of "," and use localized string codes instead of the English one.

Regards,

Last edited:

Replies
9
Views
297
Replies
13
Views
299
Replies
3
Views
330
Replies
18
Views
854
Replies
3
Views
122

1,196,512
Messages
6,015,628
Members
441,912
Latest member
Rayna_rahman00

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back