normal

  1. P

    Power Query AntiLog 10 function

    Is there a function in PowerQuery to return the antilog base 10 of a number please? I cannot seem to find the ^ operator either to do it the normal way. Thanks Peter
  2. N

    Conditional formating Pivot table row if subtal > x

    Hi, I need to know how can i conditionnal format a whole row based on value in subtotal of that row in a Pivot table. I tried normal Conditional formating that work great but whenever the pivot table is refreshed which add/remove columns it no more work as Subtotal Column changes Here is my...
  3. E

    Comparing Fails..

    Hello, I need to compare two columns with bank accounts generated by company applicaton and Im stuck.. Searching web does not help : ( The numbers even thou the same - are not. 12 3456 7890 0000 0000 1234 5678 9012 <> 12 3456 7890 0000 0000 1234 5678 9012 To excel both numbers has 32...
  4. D

    I'd Like to Switch From "Print View" to "Normal View"

    Hi all, Forgive me if I'm violating any forum rules: I'm new to this site and posting on forums in general. I've read the rules of this, I've searched through many SOLVED threads, and I still have a question. I really hope you guys can help. I'm working on a couple of sheets in Excel 2016, and...
  5. M

    Excel add-in Type button with two function

    Hi, I creating Custom tab for personal macros. Could you help me with XML code for button which will have two function: control ON: highlight- Show hidden columns control OFF: normal view - Hide grouped columns The code for normal button is: button id="1_111" visible="true"...
  6. K

    Marching Ants

    Hello, I work for a company and they just installed Office 2013 on my computer. As I opened excel to work my normal job; I noticed when I selected cells and hit copy....the outline of my copied cells was a dark green dash line like normal....The only difference was the dashes were not moving...
  7. T

    Dates

    I apologize up front as I know enough about Access to be dangerous. I have a database created with 2003 that I'm running on 2016 and Windows 7; keep getting the "in use" message when I try to save to 2016, but that beside the point. In a table, I have a date field using the numeric format...
  8. M

    Why my data does not give a bell curve graph? normal distribution formulas used

    Hi Guys, I have been trying to create a bell curve / normal distribution chart but my data does not give a belle curve. What do I do wrong ? Given X values, I use formula z= STANDARDIZE Fx = NORM.DIST <colgroup><col span="3"></colgroup><tbody> X z f(x) 490 0.9 0.029 490 0.9 0.029...
  9. R

    Spellchecker in Protected Sheet

    Hi All, I need to check the spelling of user input fields in a protected workbook. Users are only able to select and edit e.g. range E2:E21. I need the spell checker to work as the normal excel one, i.e, the cell with the misspelled word must be selected in order for me to know where the...
  10. L

    VBA Assign Vlookup Result To Variable

    Hey, I’ve searched around for this, what I’m trying to do is store a vlookup result inside my variable. At first I switched my sheet to R1C1 and put the VLOOKUP inside an EVALUATE which worked fine. However when I switched back from R1C1 on the sheet it gave me a type mismatch. So I tried to...
  11. russkris

    SUMIFS help with multiple criteria

    Hi, I have a project with a limited budget however one component is not included in the budget but still need to keep track of the cost. The project has 6 components and each component has Normal cost and overtime cost. This is the sheet supervisors are filling out [Table1]-[Table30] and...
  12. russkris

    SUMIF calculates number of cells not value of cells

    Hi, I have a couple of tables like the picture below and a summary sheet so I can create some pretty graphs etc. However the formula to separate the difference between Normal and Overtime counts are backwards and in number of cells not total time. So the formula for the above is...
  13. JenniferMurphy

    Asymmetrical Normal distributions

    Does Excel have functions that will enable me to calculate Z scores for Normal distributions that are not symmetrical? Suppose I have all of the data for all of the major league baseball teams going back over 100 years. Suppose I want to calculate the mean and std dev for win streaks of various...
  14. S

    is it normal for Excel and all other Office Products to get real slow when programming macros?

    I have coded several macros and straight vba code into a workbook and now every time I have this workbook open - everything MSOffice runs very slowly! And on my coworkers machine which happens to be win 7 - it freezes up and then shuts down Excel... Is this normal? Is there a way to make it...
  15. S

    Splitting a number for normal and overtime breakdown

    Hi, I am sure to have done this before but racking my brain has led me to actually take the plunge into the forum to get help. In creating a spreadsheet to simplify some tasks, I have managed to create it such that it will return the total number of hours required to complete a work package...
  16. M

    Box Muller Method with VBA

    For my job, I'm supposed to generated 'n' normally distributed random numbers and calculate only the frequencies using the box muller method. I can't seem to figure it out or get a good internet search on it. Here are some details about what I know and what I've found out so far: -Each...
  17. E

    Normal Distribution in Excel

    Hi, everyone, I have a quick question for normal distribution in Excel. There's a construction project with the following monthly expenditures: JUL 2008 $ 4,903 AUG 2008 $ 3,591 SEP 2008 $ 15,452 OCT 2008 $ 12,806 NOV 2008 $ 59,988 DEC 2008 $...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top