irregular

  1. O

    VBA Extracting Data from multiple workbooks, with varying sheet names

    Hi All, I am looking for vba code that allows me to collate data from varying excel workbooks, however there are multiple sheet names within each workbook (of varying amounts) and the sheet names are different. I need to collect the raw data from these workbooks which do not always follow a set...
  2. F

    Sum Values over 30 minutes for Irregular Time Intervals

    Hello, I have some data that has been recording values every 3 minutes. However due to computer error some of the recordings are taken every 2,4 or even 20 minutes in some cases. The vast majority however are taken over 3 minutes. What I would like to acheive is to be able to record and sum...
  3. A

    Counting multiple letters in cells

    Hi, I have a large list of policy numbers with different letters held within (eg MT/1/PD/101271A, 07BV/17345057, BL/1/ /635663A, MALZ32741) all have different formats and some contain /'s. They have all been manually added so each line differs slightly. I have a list of letter prefixes i wish...
  4. S

    Transpose irregular data from columns to rows

    I have a two column set of data with ZIP codes in one and order numbers in the second. In some ZIP codes there is only one order number, but some have two and up to six. I have used the Copy/Paste Special-Transpose, but this worksheet has hundreds of rows and is quite time consuming. Is...

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