Prev: Already exists on the destination workbook
Next: Synchronous scrolling in all sheets of a wokbook.
From: heather on 23 Jan 2009 10:57
Is there a way to refernce the cell name, ie C3 instead of the contents in
it, using formulas in another cell
From: Niek Otten on 23 Jan 2009 11:03
Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"heather" <heather(a)discussions.microsoft.com> wrote in message
news:F4A60E52-9744-42F3-A32C-3223CB58D4B6(a)microsoft.com...
> Is there a way to refernce the cell name, ie C3 instead of the contents in
> it, using formulas in another cell

From: heather on 23 Jan 2009 11:20
ok, so I have multiple numbers in column A, some repeat, and corresponding
numbers in column B. I want to pull all the the corresponding numbers in
Column B by the number in Column A but since some of the numbers in Column A
repeat I get the number for the first number not the repeated number....What
can I do?

"Niek Otten" wrote:

> Look in HELP for the INDIRECT() function
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "heather" <heather(a)discussions.microsoft.com> wrote in message
> news:F4A60E52-9744-42F3-A32C-3223CB58D4B6(a)microsoft.com...
> > Is there a way to refernce the cell name, ie C3 instead of the contents in
> > it, using formulas in another cell
>
From: Niek Otten on 23 Jan 2009 11:36
I fail to see what this has to do with your initial question.

Please describe more clearly what you try to achieve. Give examples of data
and required results if possible.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"heather" <heather(a)discussions.microsoft.com> wrote in message
news:2FE50092-C268-462F-B539-3DD7E09A4A3A(a)microsoft.com...
> ok, so I have multiple numbers in column A, some repeat, and corresponding
> numbers in column B. I want to pull all the the corresponding numbers in
> Column B by the number in Column A but since some of the numbers in Column
> A
> repeat I get the number for the first number not the repeated
> number....What
> can I do?
>
> "Niek Otten" wrote:
>
>> Look in HELP for the INDIRECT() function
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>> Microsoft MVP - Excel
>>
>> "heather" <heather(a)discussions.microsoft.com> wrote in message
>> news:F4A60E52-9744-42F3-A32C-3223CB58D4B6(a)microsoft.com...
>> > Is there a way to refernce the cell name, ie C3 instead of the contents
>> > in
>> > it, using formulas in another cell
>>

From: heather on 23 Jan 2009 11:52
Well, it doesn't really have anything to do with it. The first question
didn't work so I am going about it from a different angle....Here is what i
would like to happen....
Col A Col B Col C col D
699875 0102802NTZG 699875 0102802NTZG
345666 0102802NUCU 699875 0107802OBEX
548986 0104802NWPZ 699875 0107802OBFA
699875 0107802OBEX 548986 0104802NWPZ
699875 0107802OBFA etc...
462083 0107802OBZY
472550 0107802OCDY


Column C and D I would like to get some formula to auto enter the info.
Number from largest to smallest which i used the Larger() ...and Column D to
pull the corresponding number/letter seq from column B.


"Niek Otten" wrote:

> I fail to see what this has to do with your initial question.
>
> Please describe more clearly what you try to achieve. Give examples of data
> and required results if possible.
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
>
> "heather" <heather(a)discussions.microsoft.com> wrote in message
> news:2FE50092-C268-462F-B539-3DD7E09A4A3A(a)microsoft.com...
> > ok, so I have multiple numbers in column A, some repeat, and corresponding
> > numbers in column B. I want to pull all the the corresponding numbers in
> > Column B by the number in Column A but since some of the numbers in Column
> > A
> > repeat I get the number for the first number not the repeated
> > number....What
> > can I do?
> >
> > "Niek Otten" wrote:
> >
> >> Look in HELP for the INDIRECT() function
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >> Microsoft MVP - Excel
> >>
> >> "heather" <heather(a)discussions.microsoft.com> wrote in message
> >> news:F4A60E52-9744-42F3-A32C-3223CB58D4B6(a)microsoft.com...
> >> > Is there a way to refernce the cell name, ie C3 instead of the contents
> >> > in
> >> > it, using formulas in another cell
> >>
>
 |  Next  |  Last
Pages: 1 2 3 4 5
Prev: Already exists on the destination workbook
Next: Synchronous scrolling in all sheets of a wokbook.