Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Trend Calculation
This will be a very easy problem for someone other than myself. I have
a table that includes, for example, widgets of different colors and values. By way of example, here is my problem: A B C 1 Blue 8 2 Red 6 3 Blue 7 4 Green 8 5 Red 7 6 Blue 6 6 Now, column A are the widget colors, B are their values and C would be the trend of the values for the colors on the corresponding rows. So, my formula in C6 would need to return the Trend in value for the Blue widgets only. Please, someone, HELP! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Trend Calculation
Try stating your question more clearly.
Jerry Smitty wrote: This will be a very easy problem for someone other than myself. I have a table that includes, for example, widgets of different colors and values. By way of example, here is my problem: A B C 1 Blue 8 2 Red 6 3 Blue 7 4 Green 8 5 Red 7 6 Blue 6 6 Now, column A are the widget colors, B are their values and C would be the trend of the values for the colors on the corresponding rows. So, my formula in C6 would need to return the Trend in value for the Blue widgets only. Please, someone, HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trend lines in charts under Excel | Charts and Charting in Excel | |||
Trend analysis calculation | Excel Worksheet Functions | |||
Excel TREND results | Charts and Charting in Excel | |||
dubbel trend line in excel? | Excel Discussion (Misc queries) | |||
Trend line in Excel | Excel Discussion (Misc queries) |