I would like to see if one cell is equal to any other cell in an entire row.
The row contains over 10,000 cells of data how can I insert a formula to do
this?

Use the MATCH() function. It will tell you both if its there and where it is.
--
Gary's Student


"Danbmarine" wrote:

I would like to see if one cell is equal to any other cell in an entire row.
The row contains over 10,000 cells of data how can I insert a formula to do
this?

thanks, will this also work if the target cell is not in the same row as the
list that I am comparing it to?

"Gary''s Student" wrote:

Use the MATCH() function. It will tell you both if its there and where it is.
--
Gary's Student


"Danbmarine" wrote:

I would like to see if one cell is equal to any other cell in an entire row.
The row contains over 10,000 cells of data how can I insert a formula to do
this?

yes
--
Gary''s Student


"Danbmarine" wrote:

thanks, will this also work if the target cell is not in the same row as the
list that I am comparing it to?

"Gary''s Student" wrote:

Use the MATCH() function. It will tell you both if its there and where it is.
--
Gary's Student


"Danbmarine" wrote:

I would like to see if one cell is equal to any other cell in an entire row.
The row contains over 10,000 cells of data how can I insert a formula to do
this?

I have a similar situation. I need the result to be a logical
TRUE/FALSE. I cannot figure out how to use the #N/A value in a logic
test. Basically I need to see if the reference cell value is in the
list and return TRUE if its and FALSE if it isnt. The only stumbling
block is how to deal with the #N/A error. Any suggestions?


--
quimrider
------------------------------------------------------------------------
quimrider's Profile: http://www.excelforum.com/member.php...o&userid=29009
View this thread: http://www.excelforum.com/showthread...hreadid=490747

I have a similar situation. I need the result to be a logical
TRUE/FALSE. I cannot figure out how to use the #N/A value in a logic
test. Basically I need to see if the reference cell value is in the
list and return TRUE if its and FALSE if it isnt. The only stumbling
block is how to deal with the #N/A error. Any suggestions?

You can test for the #N/A error with the function ISNA; for example:
=NOT(ISNA(VLOOKUP(G1,D:D,1,FALSE)))

But if you're using VLOOKUP (or similar), you might consider using COUNTIF
instead -- there are fewer error conditions to cope with. For example:
=COUNTIF(D:D,G1)0