I`m a Microsoft Excel MVP (Most Valuable Professional) and have been since the inception of the program in 1995. I can answer every kind of Excel question except: API, Importing/exporting to other programs (powerpoint, word,...) Also check out my in-person training link at http://www.thumbtack.com/ny/new-york/excel-training/
Worked with MS Excel since version 0.99 (on the Mac!). Was contributing editor to Excellence Magazine, having written >300 articles. John Walkenbach said of me "I finally met someone who knows as much about Excel as I do."
Excellence, The Expert, Microsoft
BA in math, Hofstra University, 1965
Led sessions for the Convergence 2004-2006 seminar on Excel tips & tricks
See my book, This isn't Excel, it's Magic! at http://www.iil.com/iil/excelmagic
|ABDUL RAHMAN||10/06/16||10||10||10||DEAR MR. BOB NOW THE SOLUTION IS .....|
|ABDUL RAHMAN||09/29/16||10||10||10||THANK YOU VERY,VERY MUCH THE FORMULA .....|
For an 8th-degree polynomial, you will have 9 coefficients. So for example, select E5, then enter this: =INDEX(LINEST($B$5:$B$35,$A$5:$A$35^COLUMN($A:$H),,TRUE),,COLUMN(A1)) then fill right to M5. These
This will give the answer in Years (or fraction of years, like 1.5): Enter from date in a cell, say A1, and end date in A2, enter =Age(A1,A2) Function Age(From, Too) As Double Dim n As Long, From2
Dates before 1900 are only available through VBA. You'll notice that simply entering a date before 1900 is left-aligned, hence it's treated as text.
Let's say on sheet2 the dates are in row 2 and the first product (550) is in cell A5. Enter this formula in cell B5, but before pressing enter, hold the ctrl+shift keys down: =INDEX(Sheet1!$F:$F,MATCH($A5&B$2
Most likely cause is that the data you're summing is text. If your formula is =SUM(A1:A10), for example, try =SUM(A1:A10*1) but entered via ctrl+shift+enter (note the "*1" inside the formula). If that
Answers by Expert: