How to find the formula inside #REF error
 

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

How to find the formula inside #REF error
 

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

#REF error wrote:

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

--

Dave Peterson

How to find the formula inside #REF error
 

Hi Dave,

Thank you for your quick reply. But I want to know what are the referenced
rows which were deleted or moved.

"Dave Peterson" wrote:

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

#REF error wrote:

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

--

Dave Peterson

How to find the formula inside #REF error
 

Take a look at the previous version if you still have it.

If you don't, then you're out of luck. Excel doesn't keep track columns that
you delete.

#REF error wrote:

Hi Dave,

Thank you for your quick reply. But I want to know what are the referenced
rows which were deleted or moved.

"Dave Peterson" wrote:

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

#REF error wrote:

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

--

Dave Peterson


--

Dave Peterson

How to find the formula inside #REF error
 

Hi Dave,

My bad luck,I don't have a previous version of it.

Regards,

MKJ


"Dave Peterson" wrote:

Take a look at the previous version if you still have it.

If you don't, then you're out of luck. Excel doesn't keep track columns that
you delete.

#REF error wrote:

Hi Dave,

Thank you for your quick reply. But I want to know what are the referenced
rows which were deleted or moved.

"Dave Peterson" wrote:

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

#REF error wrote:

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

--

Dave Peterson


--

Dave Peterson

How to find the formula inside #REF error
 

Maybe you could look at headings to see what kind of data was being brought
back. If the header says "Customer ID", then look at the "sending" sheet and
see if there's still a column marked "customer id" (or close to it).

#REF error wrote:

Hi Dave,

My bad luck,I don't have a previous version of it.

Regards,

MKJ

"Dave Peterson" wrote:

Take a look at the previous version if you still have it.

If you don't, then you're out of luck. Excel doesn't keep track columns that
you delete.

#REF error wrote:

Hi Dave,

Thank you for your quick reply. But I want to know what are the referenced
rows which were deleted or moved.

"Dave Peterson" wrote:

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

#REF error wrote:

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson