| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Variable Sheet Name in Formula
This is a continuation of a question from Ajay.
Let's say we have 20 sheets named sheet1-sheet20 We have a column of data with each of the sheet names. A1=Sheet1 A2=Sheet2 and so on. In B1, I want to calculate the MIN of the values in column B on SHeet 1 In B2, I want the MIN of values in column B on Sheet2 In B3, I want the MIN of values in column B on Sheet3 How would I write the MIN statement to use a variable SHEET name? Thanks in advance, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| How do I drag a formula so 1 variable changes and 1 stays on a cel | Excel Discussion (Misc queries) | |||
| Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions | |||
| Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions | |||
Threaded Mode
