find number

  1. S

    Need help to find number between multiple range

    Hello Everyone, I have a following data table Batch No. Starting Ending 1 to 10 1 10 11 to 20 11 20 21 to 30 21 30 31 to 40 31 40 I am looking for a formula which would return the matched Batch no. depend on input value. For example, if i put 15 then the result should be...
  2. M

    Extract numbers/letters from a line of text with a twist

    I've read a few posts trying to solve this problem, but I think mine may be a little different than the ones I have seen so far. And please, by all means, if this has already been answered please guide me. Essentially I have strings of text about 5000+ rows long with names, account numbers and...
  3. R

    Formatting VBA

    I'd like my code to find any number in column A which starts with 3 (example 300049588007) and format it to add a 0 before the number (example 0300049588007). How can I do this?
  4. K

    Find last number in a column and find the corresponding last depth.

    Hi there- So my company uses an old school database (with Access 97 .mdb files) to create reports. I want to bypass this old database and create my own working excel spreadsheet. What I need to do with this is have a macro search the BHAID column and find the First #1 and the next...

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