RE: cell ref

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

if there is only one occurance of the number
You can check by =countif(range,value)

you can get the row and column by
=sum(if(range=value,row(range),0))
entered as an array (control-shift-enter)
and
=sum(if(range=value,column(range),0))
also entered as an array


if there is more than one occurance, it gets more complicated
and depends on what you want to do with the information.


"ceemo" wrote:

>
> hi say i have in column a a list of numbers and i want to find the cell
> ref (column and row) of a specific number, can i do this?
>
>
> --
> ceemo
> ------------------------------------------------------------------------
> ceemo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10650
> View this thread: http://www.excelforum.com/showthread.php?threadid=383496
>
>
.

Relevant Pages

  • Re: regular expression question
    ... however you will need to manually build the array. ... You can use the following RegEx to parse the string: ... > find occurances of two double quotes and an occurance of < and an ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Search for an Presence of an XML element in a array
    ... actual XML document for your referance and suggestion. ... array so that from array size I can get the occurance. ... Further I shall get into every "<TXN value" element and search for SEND, ...
    (comp.lang.ruby)
  • Re: File parsing
    ... Build an array or associatiave array... ... I can NOT read until the next occurance ot "abc"- abc 5 ...
    (comp.lang.awk)
  • Count the occurance of upper or lower case letters
    ... Is there a way to distinguish between and count the occurance of lower and ... upper case letters in an array? ...
    (microsoft.public.excel.worksheet.functions)