-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
01/02/2019
-
H
Count rows based on 2 dates
I have a table that contain a start date & time in column B and an end date and time in column C of different events, I need a formula to count how many rows fall within a certain time. For example below: I need to work out how many rows fall under a specific time being 13:00 each day, I can...- hailey123
- Thread
- 01/02/2019 03/02/2019 events rows time
- Replies: 1
- Forum: Excel Questions
-
U
Vlookup Question
Hi All, I hope someone can help me to save my sanity! I have created a spreadsheet which is basically a shut plan,from the shut plan a Gantt chart is created using conditional formatting. Because the shut plan needs to be hourly over a 3-week span,the Gantt chart was tricky for me (I’m...- UKFoolsGold
- Thread
- 01/02/2019 formula start time working
- Replies: 11
- Forum: Excel Questions
-
Formatting an imported CSV file.
Hey all, I have imported an CSV file and now i get this: Now this has all the information i want but theres too much information i wanna keep... So in the end i want it to look like this in a different sheet (master sheet) Now maybe you notice that i left out the SLB Individueel class. thats...- Ramballah
- Thread
- 01/02/2019 30/01/2019 31/01/2019 endvevent power query sequence0
- Replies: 13
- Forum: Excel Questions
