difficult excel formula

Hi I have a set of dates in the first 2 columns, from which I fill all the dates between. Results shown at the bottom. Problem is that it is taking too long to process. For30 set of dates it took 8 minutes, and I could have up to 12,000 sets of dates at any one time. I have tried looking for...

Hi, I need to reference the specific site name on column B, find out which entry for that site is the most recent from column A and return the value in C (whether it is "cleared" or "raised"). There will be duplicates in Column B (Source) but I am only interested in what the most recent...

I need 5 horizontal cells to automatically fill in based on the information that might be in 10 vertical cells without the 5 horizontal cells duplicating. https://www.dropbox.com/sh/l8fcalyjlbjrlh4/AAALvRoEbTDq4tGhk5BclGURa?dl=0 The link will take you to my dopbox where you can download a...

Hi All, My issue is as follows, I need to create a formula that says if it breaches a threshold (e.g. 5%) then you need to disclose. But if it breaches the additional threshold of (e.g. 1%) then you need to disclose also. If a number was above 5% then you would disclose, but you would also...

I'm not sure if this is even possible, but I have a table with approximately 4K rows, with each row listing a student and the grade that they received in a particular course. <tbody> A B C 1D 1 Student # Name Course Grade 2 12345 Jack ENGL 101 3.3 3 12345 Jack MUSIC 200 3.7 4 12346...

I have two tables pictured below: Table 1 <tbody> Columns Rows A B C D E F G H I J K L M N O P Q 1 2 Day of month 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 3 Date 2/18/2015 2/19/2015 2/20/2015 2/21/2015 2/22/2015 2/23/2015 2/24/2015...