anna

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

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

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

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

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