based on another cell

  1. P

    Need to copy cells after last used cell in same column based on the value of the cell in the adjacent column on the right

    Hi, I need to duplicate values in a column based on the value of the cell to the right of it, for example if the Quantity column is 1 then no values are duplicated, if the quantity is 2 then the cell to the left (the salary) is copied and pasted at the end of the salary column once, if the...
  2. J

    Conditional Format Several Cells Based on Content of Another Cell

    I've searched the stickies and FAQs and haven't found anything -- after 20+ hours of dedicated research I HAVE to ask you folks how to do this... Initially, I was searching for a formula to set the format of Cell H3 if Cell C3 contains "0 - Completed" as a text string. Then if C4 contained "0...
  3. M

    Sum values in one column based on unique, filtered values in another

    Please help me! I'm trying to sum filtered values from column J (course credits) based on unique values from column F (unique course ID). The desired result would return a count of 3 unique values (courses) for column F and a subtotal of 10 (credits) for column J. <tbody> A B C D E...
  4. G

    VBA code to find most recent date in column A that match a value in column B

    I'm trying to find VBA code to be able to set the value in column U to "TRUE" when the Date in column A is the "most recent" based on a value in column B. So what I have is a list of numbers in column B and a date in column A against each number. The numbers in column B may be repeated once or...
  5. K

    Conditional Formatting only formats first cell in selection

    Hello! My conditional formatting only works in the first cell of the series, or the entire series changes based on one cell change. I cannot figure out what is wrong! Below I describe how I set up the CF. Please help! I use Excel 2010. I want an empty cell in Row E to shade red if, from...

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