excel can not calculate circular reference

[geeky1]

As you can see on the picture excel shows that it can not do the calculation. You will also find the regarding file attached. Please, can anyone explain me why it doesn't work?

kindest regards

 

[Marc L]

Bad logic !

Formula is in F1 cell and within this formula MATCH(F1 :
this is your circular reference …
​

 

[geeky1]

what do I have to replace it with?

 

[Marc L]

As I'm not a mind reader, it depends on the purpose of the formula,
what are you exactly experimenting to do ?!
​

 

[geeky1]

I have done cells F and G manually, while I want to do it with a formula.

 

[NARAYANK991]

Hi ,

See the file. This will work only with the 3 customers that you have at present ; beyond that , the formula will have to be revised , and if there are many more customers , then we will need a different approach.

Narayan

 

[geeky1]

thanks a lot! I need to insert way more customers and values, a plane formula would be the best to do so.

 

[NARAYANK991]

Hi ,

70 times 40,000 equals 2,800,000 entries , which is way more than what one column in a worksheet can accommodate !

What do you want done ?

Can you split up the dates month-wise into separate worksheets ?

Narayan

 

[geeky1]

Thanks for your response. I don't know actually, I will ask the teacher tomorrow, Luckily we have till Friday.