adjacent columns

  1. T

    Add Formula to macro to match with adjacent column

    Hello, thank you in advance for your help. I'm trying to add a formula to cell B2 (and going all the way down to match the number of rows in column A) to search for the "L0" in column A and replace both digits before "L0" with another "L0". Example, if the two digits before "L0" is "04", then...
  2. K

    Create unique ID based off of adjacent cell

    I am trying to use a forumla to look at the value in column b then create a unique id in column a based off of that value. In the table below I have a 3 digit value (in column B) that may be repeated any given number of times and if so I want the corresponding text in column "A" to equal that...
  3. D

    VBA macro help for project gantt chart timeline

    I am creating a gantt chart that I hope to use as a template for future projects. Cell C4 contains todays date Cell C5 contains project start date Cell C6 contains the deadline or end date E6 contains a formula to caclulate the number of weeks to complete project. I'd like a macro that...
  4. L

    How to lookup and remove data from adjacent columns?

    Hello there, I have been struggling with this and give in! Please help! What I need to do is remove the data from columns B and C from column A So that all I am left with is "ROMA CUSHIONS" and "ROMA COVER SETS" <colgroup><col><col><col></colgroup><tbody> A B C ROMA CUSHIONS 30X50CM GOLD...
  5. A

    Formula to count how many times adjacent cells in a row fulfil a certain criteria

    Hi, I’m using Excel version 12.1.0 for Mac. I’m having trouble making a formula that will allow me to recognize ‘episodes’ in rows of data. The criteria for an episode is that four or more adjacent cells (adjacent by column) need to have a value of 1,2 or 3. I’d like the formula to count...
  6. P

    Macro for Autosum if column A contains "total"

    I have a spreadsheet which contains a pivot table (A:D) with several columns of data adjacent to it. The adjacent columns (E:F) contain vlookup formulas based on the job# in column B. The pivot table is subtotaled based on the Foreman. A B C D...
  7. G

    Conditional Format on Non-Adjacent Cells

    This is basically what I have and what I'm trying to do A1, 4 D1, 10 A2, 2 D2, 8 A3, 9 D3, 6 I am trying to use the Icon Conditional format feature to show when cells in Column D show an increase, decrease or stays the same. I am not sure whether to use the number, percentile...
  8. A

    How to high-light consecutive numbers in cells

    I have a series of numbers in 10 columns. Would like to highlight cells that have consecutive numbers even if the numbers are not in adjacent columns. For example, numbers 8 & 7 and 1 & 2 should be high-lighted A B C D E F G H I J 4 8 2 10 7 1...

Watch MrExcel Video

This Week's Hot Topics

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
Top