Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic recognition of a starting point for a column calculation
Hi Group,
I'm having difficulties finding a way that will automate my calculation of Standevp as shown in image (Column AC). The variable is the starting date of the Monthly Performance as shown in image (Column V) What I'm looking for is a way that automatically finds the starting point for that calculation so I don't have to go into each tab and manually change the starting date. The image is located in this post i just created. http://excelproblems.wordpress.com/2...0/hello-world/ Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic recognition of a starting point for a column calculation
try this
=STDEVP((INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+1) ):V90) hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "GK" escreveu: Hi Group, I'm having difficulties finding a way that will automate my calculation of Standevp as shown in image (Column AC). The variable is the starting date of the Monthly Performance as shown in image (Column V) What I'm looking for is a way that automatically finds the starting point for that calculation so I don't have to go into each tab and manually change the starting date. The image is located in this post i just created. http://excelproblems.wordpress.com/2...0/hello-world/ Thanks for your help. . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic recognition of a starting point for a column calcula
replace the v90 for the INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+5)
sorry -- pleae click yes if it was helpfull regards from Brazil Marcelo "Marcelo" escreveu: try this =STDEVP((INDIRECT("v"&MATCH(SMALL(W:W;1),W:W,0)+1) ):V90) hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "GK" escreveu: Hi Group, I'm having difficulties finding a way that will automate my calculation of Standevp as shown in image (Column AC). The variable is the starting date of the Monthly Performance as shown in image (Column V) What I'm looking for is a way that automatically finds the starting point for that calculation so I don't have to go into each tab and manually change the starting date. The image is located in this post i just created. http://excelproblems.wordpress.com/2...0/hello-world/ Thanks for your help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data being corrupted by excels automatic date recognition re-forma | Excel Discussion (Misc queries) | |||
Automatic copy recognition in columns | Excel Discussion (Misc queries) | |||
calculating a date using the day of the week as a starting point? | Excel Worksheet Functions | |||
bar chart starting point | Charts and Charting in Excel | |||
Bar charts with a differing starting point | Charts and Charting in Excel |