1/1/2017

Can someone help me figure out the code for grouping 2 columns together before sorting by columns? example data: where columns A & B need to be grouped together, C & D together, E & F together, etc... When the sort is done it is only to sort by the name column (first column in each group of...

Hi there, I need to filter out the 1st day of the month (Jan 1, Mar 1, etc) from a series of dates spanning several years and am having trouble doing this in an easy way using custom date filters. Happy to add a 'helper column if needed). From example below, I would want to filter out 12/1/2016...

Hi all, here's another quandary I'm having in getting data to behave nice- I have a dataset with dates and times things start and stop. For Ex: <tbody> 1/1/2017 12:01 AM 3:00 AM 4:30 AM 9:00 AM 1/5/2017 1:00 PM 8:00 PM 1/6/2017 4:00 PM 8:00 PM 12:30 PM 5:00 PM 1:00...

Hi everyone, I am trying to implement a count formula using sumifs but I couldn't wrap my head around it. I want to be able to count member depending on the code column. Anything less than or equal 3. Also, date will be another criteria. Trickiest part is amount will be a criteria for counting...

Hello, I want to convert this: Excel 2016 (Windows) 32 bit NameDateHours Bob1/1/20174.5 Bob1/1/20173.5 Bob1/2/20174.5 Bob1/2/20175 Mary1/1/20173.5 Mary1/1/20173 Mary1/2/20176 Mary1/2/20172.5 Sheet: Sheet1 to this: Excel 2016 (Windows) 32 bit NameDateHours Bob1/1/20178...

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 either couldn't properly describe this to google, or wasn't looking the right way.. Basically, I'm looking for a formula, that for the given info below, will check in this type of way: For all of the same "ID Number", are all "Dates" the same, are all "Dates2" the same, are all the "Number"...