high

  1. J

    Macro to Delete Rows (multiple criteria)

    I have a worksheet consisting of approximately 50,000 rows and 30 columns (A - AD). Each column has a heading. I need a macro that will quickly delete all rows that don't contain specific text in Column C. Column C will have names of schools, elementary, middle, and high. There are approximately...
  2. L

    One filter for high/moderate/low by using groups

    So basically I have three categories, high, moderate and low. I want to have one filter on the top where the "high" category would include all high, moderate, and low data points(working with text no numbers). The next category would be "moderate", but only includes moderate and low data...
  3. G

    Multiple URL and data extraction

    Hi guys/girls, I’m a newbie and this is my first post. Thanks for accepting. Hi have the following needs and I’m quite stuck since I know only basics of VBA, but I think this is an easy question for most of you: I need to extract data from a website, the URL is the following Dettaglio della...
  4. Prevost

    Automatic high/low data callout for nearest point to click on chart

    Hi There. This may be too much of wishful thinking. I have a chart that plots the supply and return temperature from a heat exchanger. The pattern resembles a sine wave, however there are many spikes/valleys within each sine wave cycle. I am trying to get the numbers from the lowest point to the...
  5. A

    I need to pull out high and low temps based on (weird) date, any help please?

    Hey guys! I'm working on my thesis, and I have a lot of files with the following data type: Date Time, GMT-04:00 Temp, °F 8/3/2011 17:40, 75.832 8/3/2011 18:40, 73.062 8/3/2011 19:40, 71.168 8/3/2011 20:40, 68.934 and I just need to pull out the highs/lows per date to graph. I'm having...
  6. Z

    Formula to check data in one sheet and show TRUE matches in second sheet

    Hi All, I have a list of companies that the company I work for use. These are all listed on a provider spreadsheet. However recently I was given an updated list with even more providers on the list. On top of this I have been adding providers to the list as and when I have been told to do...

Watch MrExcel Video

This Week's Hot Topics

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
Top