# inverse

1. ### Inverse Percentage

Hi All, I'm trying to show the inverse percentage of a number, and I am struggling to figure out how to do it. Can you please give a it a look and let me know if you can help me. So basically what I'm trying to achieve is if its comes up as 99% I would like it to show as 1%. Here is the Macro...
2. ### Values from a weighted average

Hi all, I am new to the forum so hopefully this is posted in the correct place. I am trying to three derive values from a weighted average that I know. The below data starts in A1. I know the weighted average value of my data is 473.27, I need a formula to calculate the three missing values in...
3. ### Making an 18x18 Matrix

Hello! I have to make an 18x18 matrix calculator using excel for my math project. It should be able to solve the determinant, the inverse, the answers if there were a given system of equations, and the L&U of the matrix. I know I could easily do those by using the built-in matrix functions, but...
4. ### Flipping a cell content in Excel 2007

Hello How can I flip the content of a cell in Excel 2007 For example:- I want to have Trim Motors : Electrical System : Honda Outboard as Honda Outboard : Electrical System : Trim Motors I have thousands of cells with data in this order that I need to reverse/ flip. Please advise Thanks a lot
5. ### Reverse Poisson?

Not sure if anyone can help with this. Basically I'm trying to find out how to apply the reverse of the Poisson function in excel. So as of now I have poisson(x value, mean, true-cumulative) and that lets me get the probability for that occurence. Basically I want to know how I can get the...

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...