Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
(so this just looks up the Letter part that is unique to the chosen date and then the number of the column the offset is for).
="'Stat Table'!" & SUBSTITUTE(TEXT(ADDRESS(1,MATCH($Q$1,$4:$4,0),4),""),"1","") & ROW(D6)
But I get an error message of #VALUE! , any ideas? The offset value works if I just point it directly at the cell like this: =OFFSET(H3,0,0,,'Stat Table'!$Q$2) for example
|How do I get the final projected value when using the Excel VBA Trendlines.Add method to add a trendline to a chart?||4||28|
|VBA question, how many data set exists in the sheet||14||54|
|how to import result to CVS from sql server management studio without comma||2||14|
|How to copy formulas in 1 column through manual page breaks in Excel||1||23|