# No trend lines please

Status
Not open for further replies.

#### RIZVI

##### Active Member
I do not need trand lines as this does not suits my requirements. I have the following query

I am using Excel 2007.

I have a table wherein I have

1. Customer names in coumun EB7 till EB101.
2. Heading EB3 is "Customer Name".
3. Row ED3 till EO3 is the name of months viz: April, May, June......till March.
4. Cell EP3 is heading "Total".
5. Sales billed to each customer is fiiled in table range ED7 till EO101
6. Total sales made by the customer is calculated in clumn EP7 till EP101.
7. Total sales of each months is calculated in row ED102 till EO102.

Now each sustome buys as per their requirements, but seem to be having a pattern. Some buy every month, some alternate month, some once in a three months etc. Pattern varies from customer to customer.

Based on the pattern and their usual off-take I need to know
A) The likelyhood of a customer buying or not buying in next month.
B) Value a customer is likely to buy.

A) If I can know this then we can depute our sales person or call our customer well in advance before they plan to go to other store / supplier. (Also save our sales staff's effort, time and money by avoiding the vsits to the customer who are not likely to buy that month)
B) Plan our inventory acordingly so that as and when the customer places the order we are able to supply them in time.

Trendline does not works propelry as:

1. I have to make chart for each and every customer.
2. Have to make it every month.
3. Does not provides me with the value a customer is likely to buy.

Can you help me with some way wherein I can get a figure of 0 if customer is not likely to buy and with a value if the customer is likely to buy in cells in some column against each customer name. Say in row EC???

Pleas help.

With regards,

Rizvi.M.H.
<!-- / message -->

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Status
Not open for further replies.

Replies
65
Views
3K
Replies
5
Views
499
Replies
2
Views
336
Replies
0
Views
224
Replies
4
Views
406

1,202,987
Messages
6,052,932
Members
444,616
Latest member
novit19089

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back