mary

Hi Desperately need a help to find two closest dates to today from the list of different people and dates. So the column C & D should show as follows. <tbody> a b c d e 1 Nick <tbody> 9/1/2016 </tbody> 1/1/2017 10/1/2017 2 Nick <tbody> 1/1/2017 </tbody> 0 0 3 Nick <tbody>...

I need an array function that works much like the column grouping function of a pivot table. For example: Referencing the list of items below... <tbody> Mary Mary Bob John John John </tbody> ...is there an array formula that would return the three distinct items ("Bob", "Mary"...

Hi, I'm trying to grade quines and need some help with conditional formatting. Is there a way to do conditional formatting for all answers to match the key that is in the top row? I can set the conditional column by column, but I have a more than 100 columns, and wondering if there's a faster...

Can someone please let me know what the best formula to use for this example. I have data from A1:D5 that comes in from another work sheet that's usually in no particular order Joe Mary Bob Steve Lucy If I wanted to have in F1:J5 it to be sorted in a order I've selected. Say I always need it...

I am about to set up a macro for a report I need to download weekly that has employee address information in order to stay current on their addresses for a mail merge I use weekly. Basically there are unneeded columns and then sorting that needs done. Unfortunately, the report comes with their...