2018-01-01

  1. Weeble

    If date < = list range, return value

    I have a table with different dates in column A <tbody> a b c d 2017-01-15 Apples 5 2017-02-15 Apples 4 </tbody> I also have a list with different prices depending on the time of date. <tbody> 2017-01-01 25,5 $ 2017-02-01 27,6 $ 2018-01-01 32,4 $ </tbody> I want to make a...
  2. E

    Identify Pattern in a grid

    Hello Gurus, Hoping to get some solution to the issue below. In the production facility that I am working on, we have thousands of these working shift patterns and it is just getting challenging to understand what are the working patterns. See below: Pattern 1 is simple and visually possible...
  3. D

    Update table based on closest match on date

    Hi I have got 2 tables: "Orderlines" and "Pricedates" Orderlines Date of purchase Itemnr Price 2018-01-01 A 0 2018-01-02 A 0 2018-01-03 A 0 2018-01-04 A...
  4. K

    Excel formula - to look up each country of holidays in a range of dates

    This is my ever first post forum, really excited! I have basic knowledge of excel formula, hence, need some help here. I have a range of dates (Start date, End date) and countries code on Sheet 1. Sheet 2, with all the listed holidays in all the countries. How am I gonna match the holiday...
  5. R

    VBA - Script to search and replace values in rows between sheets based on criteria

    I want ascript to search for the values in column A in sheet 1 and try to find a match in column A in Sheet 2. If a match is found I want the script to copy the values in column F-J in sheet 1 and add those values to column F-J in sheet 2 on the matching rows. Anyone able to help? :) Sheet 1...

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