Help on Circular Reference,

[MIVELD]

Please help me, I have been using my tried and trusted method for years,
Now it says it is a Circular Reference

When i download data off our Data base it appears like this

CUSTOMER PRODUCT CUST FORULAE
Customer 1 Product1
Product 2
Product 3
Customer 2 Product 1
Product 2
Customer 3 Product 1
Product 3


Imagine this are Cells A1 to B8

In C1 I would normally write the trusted IF(A2="",C1,A2) Then auto fill
down the C Column

This for some reason has become a circular ref, although both C1 & A2
are text and not linked to any other cell

Please help, i am losing my mind

PS The Products will all appear in the B col. Would be great if we
could Paste in this forum

 

[Niek Otten]

<In C1 I would normally write the trusted IF(A2="",C1,A2) Then auto fill
down the C Column>

I guess that you used to use
=A1
in C1, and then
IF(A2="",C1,A2)
in C2

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Please help me, I have been using my tried and trusted method for years,
| Now it says it is a Circular Reference
|
| When i download data off our Data base it appears like this
|
| CUSTOMER PRODUCT CUST FORULAE
| Customer 1 Product1
| Product 2
| Product 3
| Customer 2 Product 1
| Product 2
| Customer 3 Product 1
| Product 3
|
|
| Imagine this are Cells A1 to B8
|
| In C1 I would normally write the trusted IF(A2="",C1,A2) Then auto fill
| down the C Column
|
| This for some reason has become a circular ref, although both C1 & A2
| are text and not linked to any other cell
|
| Please help, i am losing my mind
|
| PS The Products will all appear in the B col. Would be great if we
| could Paste in this forum
|
|
| --
| MIVELD
| ------------------------------------------------------------------------
| MIVELD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24562
| View this thread: http://www.excelforum.com/showthread.php?threadid=565928
|