Forum Discussion
Solved
Excel formula assistance
Countif / Countifs have issues due to the time format and pivot table options have not worked very easily either. Looking to create a list which other workbooks can use at the same time for statisti...
=COUNTIFS($C$2:$C$10000,">="&$G2,$C$2:$C$10000,"<"&$G3,$E$2:$E$10000,I$1)I'd apply COUNTIFS as shown in the screenshot.
What the entire procedure is? In general you may use Power Query to pick up emails from available mailbox(es), make the transformation and generate any metrics you wish.
If not Power Query, how do you import emails information to the Excel?
- We just copy and paste the outlook data into excel (ctrl C & V process)
