Recent Discussions
Select Query values not showing in report - MS Access
I'm probably missing something simple, but.. I have a Table that has 4 field (plus key), Company ID, Join Date, Quit Date, Notes. This tracks agency membership I made a select query, with 2 IIF statements, and 2 conversions. My Datasheet view shows correctly, but when i put the fields on a report, YRSCALC is empty, and doesn't sum, which affects Grand Total. I have tried every type of formatting i can think of.. Select Query: SELECT tblJOINQUIT.[Company ID#], tblJOINQUIT.[Join Date], tblJOINQUIT.[Quit Date], tblJOINQUIT.Notes, Sum(IIf([Quit Date] Is Null,"0.00",DateDiff("m",[Join Date],[Quit Date]))) AS NumOfMonthsCalc, Sum(IIf([Quit Date] Is Not Null,"0.00",DateDiff("m",[Join Date],Now()))) AS NumOfMonthsCurr, [NumOfMonthsCalc]/12 AS YRSCALC, [NumOfMonthsCurr]/12 AS YRSCURR FROM tblJOINQUIT GROUP BY tblJOINQUIT.[Company ID#], tblJOINQUIT.[Join Date], tblJOINQUIT.[Quit Date], tblJOINQUIT.Notes; Report View: Help??
Delete extra row
I have a document with 95 people, where I fill in 1 row for each of them for each day. One day I fill in 91 rows, the second day 89 rows, the third 94... (each day a different number of rows to fill in). After that entry, for each person I need to have 24 filled in rows for the last 24 days when I entered data. The next day I enter data for 92 people, for those 92 people I will have 25 filled in rows (the 25th row is extra and I have to delete it, now I do it manually). How can I delete that 25th row at once for all 92 people, so that I have 24 rows left for everyone?
Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.
Data sort and Deletion
I am having trouble sorting this dataset and then deleting some data. Column C lists unique ID numbers, and column D is the data collection date. This database allows us to track data over time. However, I am working on a dashboard and only want to display the most recent data. For each collection data, there are 6 possible disability answers. I need to keep the most recent 6 for each ID number and would like to delete the rest. Does anyone have a suggestion on if it is possible to do this with a formula or some other way?
Shorten to certain characters and perform IF formula
Good morning/afternoon/evening all I'm sure this is probably something simple I'm missing but I'm in a spot where I am trying to add a manufacturer indicator based upon the first three characters of data, such as what is below: Basically, I'd like to remove the "Make" column. Currently I'm using a simple =LEFT(VINcell,3) to shorten it, and then =IF(MAKEcell="1GB","Chevrolet","GMC"). I'm probably missing something simple or it's not possible, but many thanks in advance!Conditional Formatting Formula
I am trying to create a formula for conditional formatting to check that if two individuals have the same day off and neither have coverage, then the rows for those two highlight red. If one does find coverage then the rows stop highlighting. So in the below example, John and Sarah both have 4/24 and 4/25 off; but Sarah found coverage for the 25th. So I would want the rows for 4/24 to be highlighted and the rows for 4/25 to NOT be highlighted.Comands not visible under some tabs unless I select arrow
The Alignment tab does not display the various commands like wrap text unless I select the arrow under alignment. I found that I am supposed to have a “Ribbon Display Options” arrow in the upper right corner of Excel, but I do not have this arrow. How do I restore this arrow? This is also true of the Number tab.Look Up for multiple sheets?
I wonder if someone would be so kind as to help me with a little problem... I have 12 different workbooks, one for each store, for labour and sales forecasting. On each workbook there are a few different sheets - one for each period and then a final sheet which shows the total for each week and period, giving a quarterly summary. The only problem with this is when I want to review these I have to open individually 12 different workbooks. Is there a way that I can create a new workbook, which shows the 'Quarterly Summary' page for each store. I initially thought a look up formula, but I think this only applies to particular cells and not an entire sheets? Thanks in advance!Conditional Formatting code help
I have 300o rows that I need code in, is there a faster way to write this so I don't have to write a policy rule for each row? What I need to accomplish: If "Dismissed" is selected in Column C I need it to turn Cells A,B, & C in that row Yellow but only that row. Above is the only way I can think to do it but then I would have to basically copy and change the row # from Cell 3 to 3003 and boy I'd really like to avoid having to spend the time doing that. I'm sure there is a way to do this in a much simpler faster way, I just can't think of how to get it done other than the way I don't want to do it.
Some Form questions are getting brackets [ ] around answers, \n at the end, and/or <br> at the end.
I have Form that triggers a flow when submitted. That flow puts the Form data into a SharePoint list. There's a couple questions on the form that consistently get brackets ["answer"] around the answer and sometimes the same question will have the brackets and a \n at the end like ["answer\n"]. There's another question that inconsistently gets a <br> put at the end of the answer answer<br>. I've tried deleting the questions with the problem(s) and re-creating them, but the issue persists. The problem seems to lie within Forms and not Flow or SharePoint because when I check the response details within Forms I see answers getting the extra stuff it shouldn't get. Here's some screenshots: Question and answers in Forms: The way the data submitted into a SharePoint list: Raw input in Flow: Any ideas whats causing this?
Find and replace mystery
I am attempting to replace all the occurrences of "$23" within a formula with "$43" [I'm not using the quote marks in the box]. Every single time, it replaces it with "$34" instead of "$43". For troubleshooting, I tried: Find "23" replace with "43" - it worked correctly. Find "$23" replace with "$6300" just to see if a different 'replace with' value would have a different outcome - it still replaces it with "$34" I have another find and replace in the same cell and same formula where I am replacing "$18" with "$38" - it works just fine! I do not have the SUBSTITUTE formula anywhere in this cell. I read somewhere that SUBSTITUTE could affect find and replace. I am stumped. If it matters, the "$23" I am trying to replace is within a SUMPRODUCT formula. I am using 365.
count some data
Hello My friend, Can anyone please inform me what is the Excel equation for the below details: I have 2 columns first one the state and it have two cells only with C or T....and the second column is for agent name which has many cells more than 3k...so i need to know like the cells on the right every agent how many total it have of c and t and how many separately. Thanks in advance.Custom Bullets Transparency Issues
So I've been using custom bullets for years, in January 2025 there was no issue. I was unable to work on my document since then because of issues with my PC. Yesterday when I opened my document, my bullets no longer had transparency. Normally, it wouldn't be a problem because the background is also white, but in this document, I have background images as well. As you can see the background on the bullets stand out. The file is a PNG with a transparent background. I have tried replacing it more than once, I have 2 different bullets in this document and they are both doing it. I checked another document that was fine in the past and it too is having the issue. I opened a brand new doc and changed the background color of the doc and it does the same thing. I contacted M365 support, it was painful they didn't even know how to do a custom bullet, they were looking for picture settings... Hehe. Anyway, they told me to post here. To me it's something in Word itself because it was working before. The doc is NOT in compatibility mode or anything like that. I can't find anything on the Internet and its frustrating me to no end. Of course I could take the custom bullets out but this is going to be a publish book, that little extra flair is everything, and this is the 4th book in the series, and having it differ from the first three.... Again it's in the details, readers might not care, but I care.Excel Data Model File Path Change
My boss created an Excel data model before I joined the company. He created the data model and queried the data from files within his personal drive. Now that I am here, he wants me to have access to these files and has moved them into a shared folder. The thing is, all of the queries now have the wrong file path. Is the only way to fix this to manually update the file path within the Source step of the power query editor? If there is an easier way, please let me know!An Account Blocked by MACE Credential Revocation is A Good Way to Start a Saturday Morning
The last thing you want on a Saturday morning is to find that Entra ID has blocked your account because of leaked credentials. Even though the account is protected by MFA, it’s still important to remediate the event by changing its password. A check against some beta sign-in metrics shows that no one has tried to use the leaked credentials, so that’s good. https://office365itpros.com/2025/04/21/leaked-credentials-sign-in-metrics/
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. The Microsoft 365 Community Conference is your chance to keep up with AI, build game-changing skills, and ta...
In-Person
Recent Blogs
- Ready to level up your Microsoft 365 and AI skills? Join us at M365Con 2025 in Vegas!Apr 21, 2025
- Measure and drive Microsoft 365 Copilot adoption in your organizationApr 16, 2025
