Forum Widgets
Latest Discussions
Help! I'm trying to pull and sort info from the same page!
Hello! I need help with Excel, I'm trying to pull info from U4:U18, X4:X18, AA4:AA18, AD4:AD18, and AG4:AG18 and put it into a chart starting on H6. I can do one with the formula =UNIQUE(SORT(FILTER(U4:U18,U4:U18<>""),1)) so I tried to see if I could add the other ones to this one formula, because I have 5 days (Mon-Fri) I need to reference, but it doesn't work out for me. I tried =UNIQUE(SORT(FILTER(U4:U18,U4:U18<>""),1)(sort(filter(X4:X18,X4:X18<>""),1)) etc. =unique(sort(filter((U4:U18,U4:U18<>"")(X4:X18,X4:X18<>"")(AA4:AA18<>"")(AD4:AD18<>"")),1)) I don't know what to do. I'm not super familiar with Excel, I've only taken classes, basically back in middle school (I'm 32) so I don't remember much, I'm trying to pull the formulas from my old managers original report to make my own report, but this is where I am. any help would be great!ledesma92Feb 06, 2025Copper Contributor33Views0likes1Commentnot pulling all numbers
So I've managed to get my formula working, I'm using =SUMPRODUCT(SUMIF(Monday!A17:A40,H19,Monday!E17:E40)+SUMIF(Tuesday!A17:A38,H19,Tuesday!E17:E38)+SUMIF(Wednesday!A17:A41,H19,Wednesday!E17:E41)+SUMIF(Thursday!A17:A33,H19,Thursday!E17:E33)) but for some reason, it's not pulling all the numbers (E17:E40) that correspond with the names (A17:A40). what am I doing wrong?ledesma92Feb 06, 2025Copper Contributor16Views0likes1CommentExcel - Vstack help.
I feel like I'm missing something simple. but here goes. I'm using the VStack function to search multiple tables on separate sheets. Its working wonderfully except as it runs through each filter function, If a table does not return results, it creates a blank row before running the next filter function on the row below. See below. Most of the data is irrelevant for the build. The first column contains the Filter criteria. The second column is a reference column that tells me which sheet the column is coming from so i can keep up with them inside the functions. My entire formula is below. =IFERROR(VSTACK(FILTER(Narkiewiecz[[House Code]:[Invoice Paid?]], Narkiewiecz[House Code] = Access!$B$4, ""),FILTER(Table47[[House Code]:[Invoice Paid?]], Table47[House Code] = Access!$B$4, ""),FILTER(Table48[[House Code]:[Invoice Paid?]], Table48[House Code] = Access!$B$4, ""),FILTER(Table49[[House Code]:[Invoice Paid?]], Table49[House Code] = Access!$B$4, ""),FILTER(Table410[[House Code]:[Invoice Paid?]], Table410[House Code] = Access!$B$4, "")),"") I've written in for each filter to return blank if no results are found, so I get that's why the columns are blank. Is there another [if_empty] I could write in that would allow it to stack each found result seamlessly while ignoring empty searches?PapaGooseFeb 06, 2025Copper Contributor25Views0likes1CommentWhat is the best practice for automating App-Creation?
1.) i am trying to rollout a CalendarSync to several different organizations, in an effort to reduce work by the organization admins. So to say I am looking for ways to automate the microsoft entra stuff: like first time App-Creation Manifest Editing (precisely: add permissions, change callback uris, ...) 3.) I have a working Authorization which needs TenantId + ClientId, BUT when rolling out the program to other organizations, they have not any ClientId for authorization. They have to create firstly an app manually and only than they can log in ... is there any way for first time organizations, to not manually loginto microsoft entra and create an application? 2.) What is the best practice to go about this? I would like to automate as much as possible with my c# code?codemainan123Feb 06, 2025Occasional Reader8Views0likes0CommentsIs there a way to create new App with Graph C#, as admin, without having access to clientId?
1.) i am trying to rollout a CalendarSync to several different organizations, in an effort to reduce work by the org. admins. So to say I am looking for ways to automate the microsoft entra stuff: like App-Creation Manifest Editing (precisely: add permissions, change callback uris, ...) 2.) I have seen there are several calls from Graph API c#, example to create an application. --> Which is what I need but the problem is authorization ... in every authorization i have tried by now there is only a login via tenantId+ClientId (and some use ClientSecret too) --> But as the organization does not have any apps created how can I login via code? 3.) Here is what I tried but i keep getting stuck because every auth method needs an app id (cleintid) and the organizations do not have any apps in entra (they are first time starting to use it) (my working Authorization, which I use for CalendarSync flawlessly) but the problem is in the App creation i still need the clientId to logonto via graph)codemainan123Feb 06, 2025Occasional Reader15Views0likes0CommentsHow to get Active Courses List
Good Day Everyone! I am trying to get a list of all active courses that are being offered by Microsoft as the https://aka.ms/CertPoster refers only to the ones with Certifications but there are many more that are offered as a learning path for example there is no certification on COPILOT but we have MS-4004,MS-4005,MS-4007 . Regards Vivek TrivediSolvedVivek_TrivediFeb 06, 2025Copper Contributor151Views0likes4CommentsHelp with Formula
Hello, This is my first post here and I can sure use the help. I work in the counseling field as an appointment coordinator. In my job I try to match people with the therapist that can best help them with their issue. What I am attempting to do is to create an easy way for my co-workers and myself to be able to quickly find the therapist based on the issue. Here is what I am trying but keep getting my formula wrong. Please help. RhondaSolvedRhondaFeb 05, 2025Copper Contributor115Views1like6CommentsHow to study for Excel MO-200 exam?
Hello, I would like to study for the microsoft excel specialist exam as I have zero to no experience with excel but both Self-led and Instructor formats don't seem to be available. Has it been like this? How can I study for the excel certificate exam to be successful? is there a route that people usually follow? +Also found there's Microsoft excel lectures on youtube: https://www.youtube.com/watch?v=buZR90nICFo&list=PL3191U3rAPzgA1yOwq82fOglcnZ1C8G_o would this be enough info/material to study for the exam? If you guys have any tips for the exam, I would be appreciatedsidamatmuleeFeb 04, 2025Copper Contributor6.3KViews0likes3CommentsIntune learning
How can we ensure that BYOD policy only applies to personal devices and not company owned devices. How can we ensure that company owned devices have windows autopilot/company policies applied only (not BYOD policy).intazarhussain309Feb 04, 2025Copper Contributor47Views0likes2Comments
Resources
Tags
- azure569 Topics
- microsoft 365530 Topics
- certification463 Topics
- Self-paced learning path259 Topics
- Community220 Topics
- power platform123 Topics
- Security Compliance and Identity120 Topics
- Dynamics 365112 Topics
- Instructor-led training102 Topics
- announcements98 Topics