- Subscribe to this page:
- RSS
- Email Alert
formula
(113 results)-
Discussion Threads
Transposing Excel data via the fixed and live methods
April 2, 2013 7:57am PDT
Transposing Excel data via the fixed and live methods article root Fixing Formulae Fixing the formulae ($ signs before and after the Column reference in each formula) retains the linkages after...
1 Started by rki@... |
-
Discussion Threads
Determine the remaining number of days in the same year
March 24, 2013 2:19pm PDT
Determine the remaining number of days in the same year article root Follow on question Thanks, Susan, this is great info! Now, how about if I want to enter a starting date in $E$3 on an Excel...
7 Started by myMary | Latest comment by lee_dimambro@...
-
Discussion Threads
Highlight Excel list values when they change
February 6, 2013 12:20am PST
Highlight Excel list values when they change article root Excel 2003 Those commands are not available in Excel 2003....or the version I have in work Other formula I think it's better use range...
23 Started by 1000048875 | Latest comment by ssharkins@...
-
Discussion Threads
EXCEL FORMULA W/O using pivot table
September 7, 2012 2:57pm PDT
EXCEL FORMULA W/O using pivot table Need to sum up the top three costs by brand. As you can see toyota is indicated twice in two different amounts so I would need the formula to rollup brands...
-
Discussion Threads
An alternative Excel averaging formula that doesn't evaluate zero
June 29, 2012 5:10pm PDT
An alternative Excel averaging formula that doesn't evaluate zero article root Good one, thanks Useful. In my Excel manual it include it as: [b]Ignore zeros when averaging[/b]...
-
-
Discussion Threads
Three ways to hide zero values in an Excel sheet
June 21, 2012 8:50am PDT
Three ways to hide zero values in an Excel sheet article root Accounting format While it doesn't remove the 0, using the Accounting format with no Symbol. This then shows a "-" instead of a zero....
12 Started by hometoy | Latest comment by hws1947@...
-
Discussion Threads
10 creative uses for Excel's conditional formatting feature
April 16, 2012 9:23pm PDT
10 creative uses for Excel's conditional formatting feature article root Question about your last tip Hi Susan, great tips for Excel users. But what do you mean "This rule is unstable if you use...
2 Started by jberezinski@... | Latest comment by mark@...
-
Discussion Threads
Count the number of Excel records that fall between two dates
March 27, 2012 7:07am PDT
Count the number of Excel records that fall between two dates article root pre Excel 2007... you can do this with an array formula: =SUM((A5:A12>=B1)*(A5:A12
11 Started by jbenton@... | Latest comment by N / A
-
Discussion Threads
10 tips for troubleshooting Excel formulas and functions
March 2, 2012 4:04am PST
10 tips for troubleshooting Excel formulas and functions article root Thanks Susan! Your articles are always very helpful, and I wanted to let you know how much I appreciate them. A Second...
7 Started by sissy sue | Latest comment by ssharkins@...
-
Discussion Threads
Office challenge: How would you sum every other value in a column?
February 17, 2012 12:18pm PST
Office challenge: How would you sum every other value in a column? article root SUMPRODUCT(MOD(ROW())) is one answer The formula =MOD(B1,2) would return 0 if the number is even and 1 if it's odd,...
11 Started by Darryl~ | Latest comment by sk.tomar@...
-
Discussion Threads
Scheduling
January 30, 2012 9:51pm PST
Scheduling Hello, Do you take into consideration the AHT, weekly offs, unplanned leaves and annual leaves too? Is there a formula to calculate roughly the number of techs required to support...
1 Started by ds4312@... | Latest comment by ds4312@...
-
Discussion Threads
Use Earned Value Management (EVM) to determine project status
November 20, 2011 9:20pm PST
Use Earned Value Management (EVM) to determine project status article root Important EVM formulas Find out important EVM formulas to learn here:...
1 Started by user_786@... |
-
Discussion Threads
10 ways to improve Excel performance
November 18, 2011 7:52am PST
10 ways to improve Excel performance article root Congratulations! Great hints, truly helpful! forward referencing "Formulas should always reference forward, to the right or below. Avoid...
23 Started by david.mapelli | Latest comment by Rob-dawg!
-
Discussion Threads
Use SUMIFS() to sum by multiple conditions in Excel
November 15, 2011 8:24am PST
Use SUMIFS() to sum by multiple conditions in Excel article root syntax in sumifs Susan: I used the wizard and this is what my formula looked like: "=SUMIFS($C$6:$C$13,$A$6:$A$13,D$1)". (the...
8 Started by zimmerwoman | Latest comment by peter.r7
-
Discussion Threads
Create a dynamic Excel chart and make your own dashboard
October 17, 2011 3:34am PDT
Create a dynamic Excel chart and make your own dashboard article root Dynamic Chart "1.Select A3:A6. 2.Hold down [Ctrl]. 3.Select F3:A6. You just created a non-contiguous selection" I think you...
23 Started by sandra.scrivens@... | Latest comment by dljohn7
-
Discussion Threads
Troubleshoot VLOOKUP() formulas gotchas
September 28, 2011 1:11pm PDT
Troubleshoot VLOOKUP() formulas gotchas article root hi hi Match and Index I've pretty much stopped using vlookup over the last few years and now use Match and Index instead. You get more...
7 Started by JohnsLaurel | Latest comment by Marshwiggle
-
Discussion Threads
Office challenge: Why aren't my formulas calculating correctly?
September 14, 2011 8:29am PDT
Office challenge: Why aren't my formulas calculating correctly? article root Is it because ... the formula has used absolute cell references e.g. b10 > =SUM($b8+$b$9) copy/paste or fill/right...
16 Started by nrobinson5@... | Latest comment by mrsmithatraytheon
-
Discussion Threads
Five tips for troubleshooting formulas in Excel
September 6, 2011 8:31am PDT
Five tips for troubleshooting formulas in Excel article root Love the info... Hate the blog format I simply don't understand why TR puts this info out by the various authors/correspondents and...
5 Started by rwbyshe@... | Latest comment by Jody Gilbert
-
Discussion Threads
Excel Help - copy formula but incrementing column rather than row
August 17, 2011 10:18am PDT
Excel Help - copy formula but incrementing column rather than row I have a standard spreadsheet with 3 tabs which is to be used by several users (not particularly IT savvy ??? so needs to be...
1 Started by alainforbes@... | Latest comment by alainforbes@...
-
Discussion Threads
Use Excel's table nomenclature to quickly create dynamic formulas
July 26, 2011 12:36am PDT
Use Excel's table nomenclature to quickly create dynamic formulas article root These Helpful hits were Previously Available as PDF Downloads What happened that the items are not directly...
5 Started by wwgorman | Latest comment by LonMcClure
