Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there such worksheet functions...
Hello all,
There are two things I'm trying to do. First, is there a function that will return (to the cell the function is in) the address of the maximum value in a range? I have a chart based on months over several years. I have the last several rows of the chart data left blank (for future input), but my chart includes these blank months in it. I'm hoping to dynamically set the range of the chart's source data based on the address that appears in a cell, so the chart will only show the months that have data in them. Second, is there a function that will extract unique values from a list? Like Auto Filter does: When you turn Auto Filter on and click the drop down in one of the columns, there are only unique values in the drop down list. If there is a way to create worksheet functions in VBA and then use them in the cells of the worksheets, please post sample code. Thanks for any help anyone can provide, Conan Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
Worksheet functions | New Users to Excel | |||
Worksheet Memory hog | Excel Discussion (Misc queries) | |||
Worksheet functions - Ajit11021225 | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |