a1234

  1. S

    cleaning up data in PowerQuery

    I have a column in PQ that needs cleaning up. I'ld like to keep values that end with a combination of 1-letter and 4-digits. Keep this pattern: ...A1234 Filter out this value pattern: ...A123 Help is appreciated. Thank you.
    • SOQLee
    • Thread
    • 4-digits a1234 cleaning filter pattern
    • Replies: 5
    • Forum: Power Tools
  2. M

    VBA macro to combine multiple sheets into 1 combined sheet

    Hello, I have multiple excel sheets from each sales person which has the below data. Each sheet is broken down into 2 different sections one for sales which has the sales info and the 2nd for leads info. I have 1 macro which combines multiple excel sheets into 1 excel sheet but it pastes in...
  3. G

    Products se vba to sum qty

    Help lol i have data in a sheet and it is variable number of rows always changes. within each row of data is various columns of data. i would like it to consolidate the data to a new sheet so that any identical product codes are consolidated so I just have number of products for each code...
  4. K

    Formula to lookup text and return when it first and last shows a value in the next column

    Below is an example of the data that I'm trying to analyse and I need 2 formulas to look up a style code and find the week when it was first stocked (i.e. the inventory column first showed a value for that code) and the week it went out of stock (i.e. the inventory was 0). A couple points to...

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