data arrays

  1. M

    how to remove blank columns and replace it with the value of the next non-blank cell in the row

    Hi, I need to format a data set for a mail merge. In essence I am looking for help on how to remove blank columns and replace it with the value of the next non-blank cell in the row (without the use of Macros). Blank values are allowed in the Widget columns are allowed Each email address will...
    • mrfrost
    • Thread
    • columns data arrays mail merge non blank cell in a row widget
    • Replies: 1
    • Forum: Excel Questions
  2. R

    Data Orientation Question, HELP ASAP!!!!

    Hi Guys, When I export data it orients the metrics in columns instead of row. Is there a way to move the data to read in each row (please see image to clarify). I tried to transpose but it did not work, please keep in mind that I am not a super advanced user. :) <tbody> I get this size1...
  3. N

    Populating Data from one Worksheet to another with conditions

    I have a data table on one worksheet. <tbody> Job Title<strike></strike><strike></strike> Department Course1 Course2 Course3 Bagging Supervisor<strike></strike> Packhouse Yes Yes Bin Filler<strike></strike> Yard Yes Yes </tbody> <tbody> Table above is an example of Data sheet but...
  4. A

    Fleet tire depth tracker

    Hi guys I am in the need of tracking tires depths in my fleet, i want to be able to put data in another sheet of all 6 tires on the trucks, and then it be updated on another sheet, i also need a conditional formatting for when the depths reach 4. <tbody> Truck# FR FL RR RL RRR RRL Date...
  5. O

    Flowchart data calculations

    Dear excel-vba user, For many years I’m using Excel and in case a certain action has to be repeated many times I’m using the macro recorder in which a vba code is generated. Then I insert a form-control from the develop-menu and with the right-mouse button I assign it to the recorded macro...

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