03/01/2018

  1. W

    Fill down Question.

    This maybe a very simple question. I have 1 column. 01/01/2018 01/01/2018 01/01/2018 01/01/2018 I want the pattern to continue i thought i could highlight the 4 cells and fill down and it would look like the below but it does not let me it just duplicates the values in the first 4 cells. I...
  2. K

    Search copy paste from one sheet to another using only selected cells

    Hello, I have an inventory XL spread sheet, what I would like to do is search for a specific refference N°(code article SAP) that will be in column B sheet 1 and then copying only the data for that refference that is in rows, N,O,P,R. and then pasting that data to another sheet, i want this as...
  3. J

    Data sort/lookup issues

    Hello All, Sorry if this is a stupid question, I'm Fairly new to using Excel and having a bit of an issue with what I am hoping to achieve with a report I'm Creating. I have included a bit of the data below to hopefully help illustrate what I'm working with. I have a master file tab in Excel...
  4. J

    First day of Last month of the Calendar Quarter

    Hello, I need a formula for the first day of the last month of the quarter... Any thoughts on this? Value = 1/31/2018... Result = 03/01/2018 Value = 3/28/2018... Result = 03/01/2018 Value = 04/01/2018... Result = 06/01/2018 Value = 05/01/2018... Result = 06/01/2018

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