M
Maxime Maugeais
Hi! I have a spreadsheet with the following info:
Date Time Profit
03/10/2003 0132 65
03/11/2003 0358 -22
03/12/2003 2135 120
.....
.....
10/29/2004 1826 -18
So there are hundreds of rows of data.
1-How can I generate a list of all the MONDAYS to the side of this list?
2-How can I get the average value of PROFIT when Time is <= 14:00)
Thank you
Maxime
Date Time Profit
03/10/2003 0132 65
03/11/2003 0358 -22
03/12/2003 2135 120
.....
.....
10/29/2004 1826 -18
So there are hundreds of rows of data.
1-How can I generate a list of all the MONDAYS to the side of this list?
2-How can I get the average value of PROFIT when Time is <= 14:00)
Thank you
Maxime