dynamic references

Hello, I have a main folder which consists of many student folders and 1 Admin folder and this folder is moved to various locations on the network as needed. The student folders are originally named 1, 2, 3.... but when the class starts the folder names may be changed. Usually, the names...

I have a company that has a list of accounts. I need to see how many lines were canceled and kept for each account as well as for the company as a whole. So for example, for Account 4, it canceled 33% and kept 67% and Company 1 canceled 8% and kept 92%==>8% = sum(0,0,0,.3333,.5,0,0,0,0,0,0)/11...

I want to use a dynamic look up array with match and have the below example: =MATCH(B$4,CONCATENATE("'",A5,"'!$E:$E"),0) The above formula result is #VALUE! Cell A5 has the value Sheet1, however, after testing this will change to a date e.g. 01-Jul-14 What am I doing wrong? I am going to use it...

Hi everyone, Can someone help with a formula for below scenario, The values in Cells D1, D2 and D3 are user inputs. A formula in B16 should sum values in database (ie sum of B6 to B11) Example : <tbody> A B C D E 1 Enter the column no B 2 Enter the start row no 6 3 Enter...

I have a lot of very large files that pull data from a number of different spreadsheets each month to do analysis on them, and I want to know how to make the references to those spreadsheets dynamic. For instance: In October I need a value from this chart at this reference...