Question

What was the earliest and what was the latest time of the day we sold a product on 14.04.2015? Use column A from tab Data and explain how you got to your result

Please Tell me the steps on how this would be solved using Excel. Note that this is not the full excel data but just a small sample.

date_sign_up	customer_id	product_name	marketing_channel	City
4/17/2015 13:11	71041	Classic - 3 meals per week for 2 people	Search Engine Marketing	San Diego
4/14/2015 11:32	103289	Classic - 3 meals per week for 2 people	Newsletters (internal)	Los Angeles
4/14/2015 9:53	107746	Classic - 3 meals per week for 2 people	Newsletters (internal)	Los Angeles
4/14/2015 16:08	157441	Classic - 3 meals per week for 4 people	Newsletters (internal)	San Francisco
4/18/2015 8:04	158646	Classic - 3 meals per week for 2 people	Newsletters (internal)	San Diego
4/18/2015 15:41	178843	3 Meals (vegetarian) for 2 people	TV / Radio Advertising	Miami
4/15/2015 9:45	179297	Classic - 3 meals per week for 2 people	Newsletters (internal)	Philadelphia
4/15/2015 8:21	182439	3 Meals (vegetarian) for 2 people	Newsletters (internal)	San Francisco
4/17/2015 6:57	186180	Classic - 3 meals per week for 2 people	Partnership Marketing	San Diego
4/19/2015 20:39	190396	Classic - 3 meals per week for 2 people	TV / Radio Advertising	Miami
4/14/2015 10:26	194229	Classic - 3 meals per week for 2 people	Search Engine Marketing	Los Angeles
4/13/2015 20:17	194353	Classic - 3 meals per week for 2 people	Search Engine Marketing	Washington
4/15/2015 14:43	200286	Classic - 3 meals per week for 2 people	Search Engine Marketing	Philadelphia
4/16/2015 7:35	201307	Classic - 3 meals per week for 2 people	TV / Radio Advertising	1San Diego
4/15/2015 6:54	203319	Classic - 3 meals per week for 2 people	Newsletters (internal)	San Francisco
4/14/2015 8:35	205233	Classic - 3 meals per week for 2 people	TV / Radio Advertising	Los Angeles
4/13/2015 12:08	205322	Classic - 3 meals per week for 2 people	Newsletters (internal)	Chicago
4/16/2015 5:04	205611	Classic - 3 meals per week for 2 people	TV / Radio Advertising	San Diego
4/15/2015 12:17	208066	3 Meals (vegetarian) for 4 people	Newsletters (internal)	Philadelphia

Answer 1

Solution

Go to Column B

write

"17-04-2015"

Now press "Flash Fill"

from the "Data" tab

Similarly

Go to Column C

write "13:11"

Press "Flash Fill"

now we got the both Date and time in seperate column

we can use the filter to get desired result

For better understanding we give column name

Date and Time

First we need to filter the date "14-04-2015"

to enable the filter

select the data

and

in the "Data" tab

Select "Filter"

now there is button will appear in every column

Click on the Date filter

Just select "14-04-2015"

Now we need to find the Latest time

Click on Time Filter

Select

"Sort Descending"

Now we can see the results

---

All the best