OK, here it goes. I'm a helicopter pilot and in the operator's manual of the aircraft is a performance section. What I'm trying to do is take the performance charts and convert them to excel. basically its a scatter chart with different variables. In short you take the temperature match it up to...
Morning all.
I have a column on sheet 1 with different numbers in it (150, 300, 600, 900, 1500, 2500) ad would like to filter it based on the number given on sheet 2, cell B5 (I have the criteria listed on sheet 2 as well). I've tried manually writing the advanced filter macro, and when that...
Mornin Ya'll.
I've got a question on sheet 2 asking for a pressure, and a column on sheet 1 with multiple flange ratings. What I'd like the script to do is filter the flange ratings based on the pressure entered.
For example, if the user entered 350 psi it would filter out everything below...
Hello,
How can calculate the Humidity with Enthalpy, Temperature, and pressure given
Enthalpy= 71.4, Temperature= 32, Pressure= 1013.25
I need an equation to calculate the humidity using Enthalpy, Temperature, and pressure
thanks in advance!
Hi I have a machine log of 10000 events. I previously got help on this forum to count the events, see below (apologies about dots working on mobile) :
Event . . . . Count
start . . . . . . . 0
Over pressure 1
over pressure 2
start . . . . . . . . 0
over pressure 1
start . . . . . . . . 0...
I am trying to count how many times an event (over pressure) occurs between a recurring event (start), I have >10000 entries. My column looks like,
start
over pressure
over pressure
start
over pressure
start
over pressure
over pressure
start
start
start
over pressure
start
In some instances...
Hi all,
A skills assessment questionnaire has been sent to staff and I now need to collate the information for each different site. I am a bit unsure the best way to set up the spreadsheet and then how to combine the information for all sites
<tbody>
Name
Job Title & Team
</tbody>...
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.