I need an excel expert -- 2
Budget: $10 – $30 AUD
I have a spreadsheet with 140,000 lines. Each line represents a 5min window.
Each window has a price.
I need to know the following .
On an hourly basis
And from 10 am to 4 pm
How much time the price is-
1. Zero and below
2. $5 and below
3. $10 and below
4. $20 and below
5. $40 and below
6. $80 and below
Also from 5pm to 11pm
Again every hour, how much time the price is above :-
1. $130
2. $160
3. $200
4. $240
5. $300
6. $360
numbers need to be in qty and percentage
Each window has a price.
I need to know the following .
On an hourly basis
And from 10 am to 4 pm
How much time the price is-
1. Zero and below
2. $5 and below
3. $10 and below
4. $20 and below
5. $40 and below
6. $80 and below
Also from 5pm to 11pm
Again every hour, how much time the price is above :-
1. $130
2. $160
3. $200
4. $240
5. $300
6. $360
numbers need to be in qty and percentage