Search results

The contents tab is where I want to find cells D5:E6 I have tried {=MAX((Widgets!2:2)*ISNUMBER(Widgets!28:28)*Widgets!29:29="Fixed")} in Contents!D5 to no avail

I have dates running horizontal across sheet in row 2 from B2 to Unknown I have final calculation running horizontal across sheet in row 64 from B64 to unknown (same Row 2) I have a calculation type flag running horizontal across row 65 from B65 to unknown Calculation flags are Fixed < Calc <...

I was trying to use -- ISNUMBER(results) instead of ISNUMBER(results)*1 does same thing I was not entering it an an array formula, which is the error Thank You

I am trying to calculate the min date of available results Row 1 has possible dates Row 65 has possible results Col A has headings 1 A B C D E 11/1/13 12/1/13 1/1/14 2/1/14 : : 65 -...

Maybe the file that has the macro in it is causing the calculation... I have checked the settings though. What setting am I missing? I have checked in Excel Options > Advanced and Formulas ??

I am using the workbooks.open method to open a .csv file and it auto calculates... how can I stop this My code is: wb_path = wb_name = workbooks.open Filename:= wb_path & wb_name I have tried to use (1) Application.Calculation = xlCalculationManual before the open statement (2) UpdateLinks:=...

Thanks Narayan, At first glance it fits the bill chandoo has a tutorial http://chandoo.org/wp/2013/02/13/shaded-line-charts-excel/

how can I make a chart with shadows that show the high and low for the last xx days of data and a bright line with todays data an example is here http://www.eia.gov/oog/info/twip/twiparch/2013/130523/twipprint.html

If you could only use 10 functions what would they be? What formulas allow you do do the majority of your work? I use INDEX, MATCH, YEARFRAC, concatenate, IF daily how about you?