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
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...
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...
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...
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"...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 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.