Tag Archives: Worksheet function

Use array in a costomized worksheet function

We know there are a lot of worksheet functions that use an array as an argument. How can we use an array as an argument in our costomized worksheet functions? I’d like to address this question step by step. The … Continue reading

Share
Posted in Excel, Tips, VBA/ASP | Tagged , , , , , , | 1 Comment

Dynamic graphing in Excel

Problem: Data are in two columns: A and B.  I am plotting a graph which takes data from columns  A and B as its source data. I want to generate an Excel template that can use many times. That is, … Continue reading

Share
Posted in Excel, Graphing | Tagged , , , | Leave a comment

A smart way to use Excel INDEX and MATCH functions

Function review: INDEX is used to find value in an array in a given location (column and row). MATCH is used to find the position in an array by searching a given value in the array. We can use these … Continue reading

Share
Posted in Excel | Tagged , , | 1 Comment