User Profile
BlueMoose
Brass Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Outlook Audit Logs
Full disclosure: I have never used PowerShell before. This is a classic rabbit hole situation where I started trying to figure something out, which led me to another and another and now we're here. I wanted to be able to know who was doing what in a shared inbox. I was then told that I needed the Audit Log. I pull the Audit Log and needed to arrange the data. I was told how I had to set it up. Now that it's all set and works, I just need a regular flow of the data from the Audit Log. I asked if the pulls could be automated and I was told that I'd need to use PowerShell and theSearch-UnifiedAuditLog cmdlet. I guess my question is: How indepth is what I have to do and where do I start?756Views0likes2CommentsAutomated Audit Log Reporting
Pretty sure I already know the answer, but: Is there any way to automate Audit Logs for shared inboxes in Outlook? Currently looking to create reporting for a large number of inboxes and we currently don't have the resouces to manually pull each of the reports each week.Solved1KViews0likes3CommentsHow to move entire row to another sheet based on cell value in Excel
Okay, so I think this is not something that can be done through formulas in Excel. I know this kind of thing can be done through formulas in Google Sheets; but, I think this is going to require macros or VBA (an area in which I have very little experience and slightly scares me). If there IS a formula for this, that's my preference. Basically, I want to pull entire rows from one sheet to another based on what is in one cell of the row. I've attached an example. Basically, every time the word "TIRES" appears in column X of the Cases tab, I want that entire row to show in the Tire Cases tab. Not that it's super important the why of it, but I'm trying to separate out data sections for overall statistics. Also, this is for a document that will be regularly added to and so will need to continue adding as new rows with "TIRES" in column X appear.Solved179KViews1like35CommentsNesting IFERROR inside AVERAGEIFS
I made this formula: =AVERAGEIFS(AM:AM,B:B,AH1) The problem is that there are cells within column AM that have #VALUE because at this time, the data is incomplete. This is a living document, so that will consistently be the case somewhere. What I need is for this formula to work, but disregard any instances of #VALUE. I think I need to put IFERROR inside of it; however, everything I've found online is about putting AVERAGEIFS inside IFERROR to give a binary result of correct or not correct data. I'm after an average of those that don't have #VALUE but also fulfill the requirements in the formula of the date column matching the date cell.Solved1KViews0likes2CommentsIFS Regarding Specific and Broad Values
I'm trying to find a way to say that if D4 shows as 0000 then if should add 600; but, for all other values other than that, it should show as 2359. I did =if(D4,2359,"") but realised that left me in the predicament for the lone value where I need the 600 added.Solved1KViews0likes5CommentsAlter Line from Plot Point to Plot Point
I'm creating a trending graph. The graph is dealing with data for the past number of weeks and then it goes into projected numbers after that. Is there a way to change the line after a certain plot point to go from a solid line to a broken line? So there's a visual marker for when it moves from actual data to projections.Solved1.2KViews0likes2CommentsCount Unique Words During Time Period
I am trying to count all instances of the words "COMPLETE" or "CLOSED" in column G; but, I only want to count them when column A has a specific date and column Q has a specific name. The date in cell AB1 needs to match column A and the person's name in AF2 needs to match what's in column Q, and then give me what's in column G. I've been trying COUNTIFS, but don't seem to be able to get it quite right.Solved589Views0likes2CommentsStatistical Reporting for Outlook Shared Inboxes
We have shared inboxes at work. Like email address removed for privacy reasons,where it isn't any specific persons inbox; but, people can have access granted. I'm describing it like that because I posted about something to do with them in the past and think I was using the wrong term which caused confusion. We have a number of people working on these inboxes; but, currently have no way to track who handles what amount of the volume. Is there a way to track amount handled by user?1.4KViews0likes1CommentMAXIFS & SUMIFS for time
I am attempting to do MAXIFS and SUMIFS for durations of time; however, it's currently not doing it. I have entered =MAXIFS(J2:J24901,A2:A24901,AH2) in order to get the highest duration on that given date and time period. It works fine for the cells that aren't dealing in time; but, just gives me all zeroes when I try it with time.Solved1.1KViews0likes3Comments
Groups
Recent Blog Articles
No content to show