varying

  1. R

    VBA Finding keywords then copying nearby rows of variable length

    Hi, thanks in advance for any help, I realize it's a lot. I'm trying to take one sheet and upload data to another. The task is: 1) Find Keyword 1 on Sheet 1 2) Skip 3 columns and copy a varying number (based on source sheet) of columns with data; below would be 4 columns (111 thru 114) but it...
  2. ajjava

    Procedure to add border around all data points, on all charts, on all sheets of a workbook?

    I keep getting it to work in little chunks. As soon as I try to make it loop, I get errors. Assumptions: 1 workbook Varying # of sheets Varying # of charts on some (but not all) sheets Some, but not all, charts are column bar charts Goal: Procedure that goes through all the charts, on all the...
  3. M

    Exclude numbers for cell that also has Text

    If I have the following all in cell A1 40 2 Apples and oranges How do I just get Apples and Oranges also the text could have varying number of text and the numbers at the beginning can also change to varying degrees. Thank you MM
  4. M

    transform array of varying lengths

    Hi, I have been fiddling with this logic, but I can't seem to make it work. Basically I just want to transpose arrays with varying lengths using the Ubound property. Here is the original code: Set rng = Range("VBAOutput") rng.offset(0, 229).Value = Application.Transpose(array) THANKS
  5. P

    Take contents of a cell and break into separate rows

    Hello, If A1 has the work TROPICAL, is there a formula that can break apart the letters so they appear as follows: (Note: A1 could have varying lengths of words) A2 = T A3 = R A4 = O A5 = P A6 = I A7 = C A8 = A A9 = L
  6. S

    Formula for extracting the first 6 digits of the cell?

    Hello, I am looking for some help on a formula that would give me the first 6 numbers of a cell from left to right. The difficulty is that the cells have varying amounts of letters before the first digit. Thanks!
  7. K

    Varying drop down list options based on an adjacent cell

    Hi all, I am trying to create two separate drop down lists on one worksheet and in the same column (N). One titled 'deliveries' the other titled 'collections' both contained in cells N2:N5000 and varying each time someone pastes in to it, I want the drop down list to look at the two options...
  8. W

    Match and Index From a Varying List of Lookup Values

    Hi guys I'm trying to find a formula that'll do three things: 1. Allow multiple criteria for lookup 2. Display multiple results from the lookup 3. Allow me to use a list of varying criteria for the lookup. I have found formulas that allow me to do 1 and 2, but not the 3rd. Here's...
  9. F

    Formula for removing characters before or after a specific symbol or phrase

    any assistance would be really appreciated , thanks !

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