anna

  1. J

    Vlookup between 2 dates ?

    Hi, Not sure if vlookup is the correct thing to use for this but i have data like below: <tbody> Name StartDate EndDate John 12/05/2019 15/05/2019 Luke 14/05/2019 14/05/2019 Anna 11/05/2019 16/05/2019 Alex 14/05/2019 16/05/2019 </tbody> Now for example if a have a sheet with dates if...
  2. A

    Calendar Help

    Hi everyone, I am looking for help in creating a calendar for work I would like to get the following cells formatted so if there are 5 names the cells all colour red, 3 or 4 they colour yellow and 1 or 2 they colour green. Does anyone know if this is possible?. Thanks in advance Regards Alvin...
  3. L

    Calculated column to get a customer name

    Hi all; I am working with a power pivot report with a table showing the sales of specific products, if the product was already delivered to the customer and the estimated delivery date. This is the table: <tbody> Product Customer name Delivered Estimated delivery date TV Susan Yes 03/15/18...
  4. I

    Comparison Graph - Looking for an Idea!

    Dear Sirs and Madams, I am trying to build a comparison graph and I am kinda running out of Idea... I would like to track activities that are open. To simply the setup I have done an example of what I want to have as a Graph: <tbody> Date Task Responsible Status Monday Cleaning Adam...
  5. A

    Macro needed

    Hi, Would you please be so kind and assist me with a macro to extract specific data within a spreadsheet. The specs are. I have a list of students 30+ who rights exams every week and I want to extract the top 3 marks and names each week. Should there be more than 3 student with the same...

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