Is there a way to refernce the cell name, ie C3 instead of the contents in
it, using formulas in another cell

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"heather" wrote in message
...
Is there a way to refernce the cell name, ie C3 instead of the contents in
it, using formulas in another cell

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" wrote in message
...
Is there a way to refernce the cell name, ie C3 instead of the contents in
it, using formulas in another cell

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" wrote in message
...
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" wrote in message
...
Is there a way to refernce the cell name, ie C3 instead of the contents
in
it, using formulas in another cell

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" wrote in message
...
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" wrote in message
...
Is there a way to refernce the cell name, ie C3 instead of the contents
in
it, using formulas in another cell

heather wrote:
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.



One possible way...

C2 = LARGE($A$2:$A$1000,ROW()-1)

D2 = IF(C2=C1,INDEX(INDIRECT(ADDRESS(MATCH(D1,$B$2:$B$1 000,0)+2,2)&":B1000"),
MATCH(C2,INDIRECT(ADDRESS(MATCH(D1,$B$2:$B$1000,0) +2,1)&":A1000"),0)),
INDEX($B$2:$B$1000,MATCH(C2,$A$2:$A$1000,0)))

Adjust the "1000"'s to include all of your data, then copy both down as far as
needed.