What was the earliest and what was the latest time of the day we sold a product on 14.04.2015?

F

fran180

New Member
Joined
Nov 22, 2019
Messages
2
Data in Google sheet
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.
I Know i can use sorting and filtering to get the answer but I am interested in getting the formula without using helper column for timestamp.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Looks like homework to me.
Have a look at using MINIFS and MAXIFS functions.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
VLOOKUP bottom to top
Replies
1
Views
179
awoohaw
awoohaw
F
  • Solved
How to format a vendor list when vendors offer several different products?
Replies
8
Views
148
Micron
M
S
  • Question
Calculating difference between Timestamps
Replies
1
Views
233
HighAndWilder
H
AOB
  • Question
Calculate the "true" duration of up/down times accounting for gaps and overlaps
Replies
1
Views
248
AOB
AOB
A
  • Question
Filter Function Problem Handling Negative Numbers
Replies
7
Views
640
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,591
Messages
6,120,429
Members
448,961
Latest member
nzskater

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top