1. J

    How do I edit rows based on criteria from an different table.

    I am working on a VBA code to do a couple things. The first is to add a new row and add the information I put into a seperate list. I want it to do this unless the Case Number and the Charge is the same. If those two things are the same then I want to fill in the rest of that row with that...
  2. M

    Conditional rounding between parameters

    Hi, I'm very new to Excel and need some help (with a maybe very basic function). I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score. What I...
  3. M

    Excel IF Formula & Remove Substring

    Hello, Could someone please help me with the IF statement in column Q? The formula should be If Column J is "Y" then remove substring "HM" from column P. The formula I'm trying is also deleting everything after the substring and if the substring doesn't exist then it's giving me #VALUE...
  4. Y

    Look up value and Return value of most recent date

    SKU STORE A A DATE STORE B B DATE 71011 1.87 2/21/21 1.69 10/7/21 71115 1.07 3/22/22 NA X FPF3 NA X 1.78 3/22/22 650876 6.34 9/21/21 6.08 10/8/21 503EZ NA X 9.00 3/22/22 72014 3.60 2/22/22 NA X 98823 NA X 5.05 2/21/22 PROBLEM: look up SKU and...
  5. T

    Cutting and Pasting individual cells that meet criteria to same row of different column

    I'm a n00b and I've been searching the forums and the closest thing I can find to my problem was addressed here: Simple Macro to cut and paste based on cell value I'm trying to have any cells in column M that are greater than 0 be cut and paste into a column 3 columns to the right of the...
  6. L

    Highlight 3 duplicates occurring within 3 days time

    I'm looking for a best way, most likely via Conditional Formatting, to highlight 3 reoccurring from B within 3 days time frame from A I've managed so far to get 3 reoccurring but for just 1 day So, all those 4 rows with PC should be highlighted, not just 3 of them Hope you can help
  7. S

    Filtering based on a dropdown list in Power Query

    Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...
  8. S

    Possibly an =IF statement??

    Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...
  9. F

    Help with Conditional Formatting

    Hey guys. I've attached a portion of a spreadsheet I'm hoping to get help on. In cell E6 I would enter the time a particular incident was created. I'm looking to use conditional formatting to turn that cell red if the incident runs longer than 9 hours. Cell A3 has the =NOW() formula in it...
  10. A

    Move rows when condition met

    Hi Gurus, I have been lurking for a few days trying to find a solution but nothing quite fits, so I am hopeful some bright spark will share their knowledge with me. I have a spreadsheet that is gathering data every day (31 sheets - one for each day of the month). At the end of the day I (or a...
  11. W

    Printing multiple worksheets with VBA based on Condition

    Good morning, I'm trying to figure out how to create a macro/button to print 2 worksheets, out of the several worksheets that exist in my workbook, but printing them under some conditions; 1. If cell S19=TRUE, and If cell P13=TRUE, then print 3 pages of each both worksheets. 2. If cell...
  12. B

    Change values in column C based on comparison of previous cells in column A

    I have a spread sheet with "Property IDs" that each have multiple "rooms" assigned to them. I need to change the "Room Name" in a seperate column based on how many times the Property ID has been Listed. Example: I need this: To be this: The reason I am looking for a macro or formula is...
  13. J

    Conditional grouping and summing of data

    I have a dataset that looks like this: Date Hour Water 1/1/2020 2 5 1/1/2020 3 45 1/1/2020 4 63 1/1/2020 24 35 1/2/2020 1 24 I want to total individual instances of the number of hours and liters. Each "hour" represents an hourly...
  14. M

    Conditional Formatting based on Column header and value

    Hello, I am currently working on a sheet where cells need to be highlighted when the header of the table is "x" and also if the cell is between two numbers. What kind of formula could i use for this? Screenshot down below is what i'm working with. So for example, if the cells in the LH Top...
  15. A

    Help for Nested Conditionals (IF/AND/OR/SUMIF etc.)

    Hello and Good Day! I have an issue with writing a proper conditional formula in Excel, so please help me Elaborating my issue, Column A are Fruits; They either have "Oranges", "Apples", or "Pears" Column B are Client's Names I'll input the gross income on C Result for net income will be...
  16. D

    Excel conditional formatting does not work!

    Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...
  17. R

    Conditional Formatting and Percentages

    Hi All, I have a spreadsheet which, in column L there is a percentage that is based on the numbers in columns D and G. I would like to create a conditional format that says: -if column L is less than or equal to 3% format the entire row green -if column L is between 4 and 6% format the entire...
  18. D

    Conditional Chart Data Range

    Hey guys, I have a workbook that charts data for various dates. I want the chart (called "Chart 6") to display different ranges of data as the years go on. When I select my chart and go to Select Data, then the Select Data Source window pops up. Currently, the chart is displaying data from the...
  19. D

    VBA Conditional Calling Based on Current Date

    Hello, I have a few different functions that are set up to do different things depending on the current date. List of functions: 2020_Tasks 2021_Tasks 2022_Tasks Is there a way, using VBA, to only call the '2020_Tasks' function if the current year is 2020, and then to continue moving through...
  20. J

    Conditional Table Array for Vlookup?

    Hello, I am trying to vlookup a value for a competitor product based on 3 criteria (that determine product group and its exact specifications). I was hoping I could use some logical function, that would then somehow choose(locate) and use a desired table array from which to look up the data...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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