Thread: Median formula in microsoft.public.excel.misc

  Try the below formula in Sheet4 A1 and copy to the right and down as required..The formula will populate date with reference to Sheet1; if the same colA info is present in Sheet2 and Sheet3 =IF(AND(COUNTIF(Sheet1!$A:$A,Sheet1!$A1), COUNTIF(Sheet2!$A:$A,Sheet1!$A1), COUNTIF(Sheet3!$A:$A,Sheet1!$A1)),Sheet1!A1,"")

  Set the cells to wrap text and the rows to autofit. Gord Dibben MS Excel MVP On Sat, 12 Dec 2009 09:40:01 -0800, lostsoul62 <lostsoul62@discussions.microsoft.com> wrote: >I will edit a cell by taking some info out and then I have a cell with 100 >points of space and I only need 14 because I'm doing 14 point fonts. So I do >a text wrap and the info just jumps up and down but the cell...

  =SQRT(SUM(INDIRECT("F"&M3&":F"&N3))/(N3-M3))

  If you're sure you're not looking at formulas, then reformat the cell as General and reenter the formula--selecting the cell, hitting F2, then enter should be enough. Saved from a previous post. Excel likes to help. Try this on a test worksheet. Select A1 and hit ctrl-; (to put the date in the cell) now select B1 and type: =a1 Notice that excel changed the format of B1 to match the format in A1. Now format D1 as Text. put...

  Assuming you've already calculated the amount of overtime in cell C2 (something like =a2-a1-"8:00") The formula you need for desired result is: =MROUND(C2-1/288,1/48) Explain: 1/288 ~ 5 minutes. This is subtracted to cause numbers in the 15-19 range to get knocked down to the 10-14 range (similarly is knock 45-49 down to 40-44). 1/48 = 30 minutes. The formula then round the difference from previous operation...

  You're welcome. Thanks for the feedback!

  Hi, The answer depends on what you want to do with this prefixed number if it's purely for show then apply a custom format of (say) "99999"&# Now any number will have the prefix of 99999 If that doesn't do it for you then post back Mike "Sherees" wrote: > I have in column A, 1000 numbers, now i need to prefix an identical number to > all the 1000 numbers in A...

  Text

  Sorry for the TYPO. Change the third row into: For Row = LR To 2 Step -1 Micky > Follow, slowly, and try to understand the code in the attached picture: > http://img130.imageshack.us/img130/8758/nonames.png > Micky > > > "John mac" wrote: > > > I am trying to write macro that will loop through a worksheet active rows and > > insert a...

  Assume that you are having values in A1:A10 like the below (A1:A10) 66 0 88 0 (Blank) 0 0 99 (Blank) 0 Use the formula like this, which will ignore blank cells and 0 (zero) values. =SUM(A1:A10)/(COUNT(A1:A10)-COUNTIF(A1:A10,0)) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Shawn S." wrote: > Have a workbook where each worksheet is a day of the month....