Recent Discussions
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?
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!
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??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.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.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/
Microsoft AutoUpdate error installing Excel 16.97
Hi, I am getting an update error installing Microsoft Excel 16.97 on Mac OS Sequoia. I am currently on 16.96. The install stops near the end of the progress bar for a long time and then I get an update error. I've had similar issues before and resolved by installing from the pkg file but I can't find the 16.97 install file.Power Automate Flow moving Attachments in Email to MS List - can it get a Email as an attachment?
Created a Flow to get Emails from Outlook using Graph API to extract all metadata into columns in a MS List including attachments of the Email into a column in the MS List with the name as a hyperlink in the same site as the list; but when there is another Email as an attachment it does not come into the MS List. Is there such a limitation in MS Flow where it cannot get the Email attached in an Email as an Attachment?problem with table of figures
Hello, I've been having problems with creating table of figures for some reason the figures are much more that they need to be and some of them are multiplied. I selected the cross reference button and it shows the same figure caption many times. Does anyone know how to help me? Thank you Kia
Access changing lettercase - redux
This has probably been beaten to death, but I'm fuming, so here goes. I want Microsoft to DO SOMETHING to help. Access has the highly annoying habit of changing lettercase on identifiers, seemingly at random. This is a real pain when using add-ins like MSAccessVCS, which makes it possible to use git for source code control. Here' what I've deduced is happening: There exists a dictionary/symbol-table containing every identifier used in a project. The symbol table contains ALL identifiers, including those defined by MSAccess, referenced libraries, and your code. Searching that table is case-insensitive, but it stores the canonical version of the identifier with case preserved. Normally, when you type an identifier that already exists in the table, the VBA editor "corrects" the lettercase of your entry to match the table's entry. The extremely annoying part is that sometimes that last step works in reverse. You type an existing identifier, but with a different lettercase. Instead of correcting what you typed to match the table, it instead updates the table with the version you typed, and decides that's the way future and existing identifiers should be spelled. Here's a recent example. I tried to create a class module constructor (Class_Initialize) but typed it "class_initialize" implicitly expecting that the VBA editor would "fix" it. Instead, it updated the symbol table and set the canonical lettercase to the all-lowercase version... and then proceeded to change the lettercase on the Class_Initialize() method in all my class modules. It has now decided the canonical lettercase is "class_initialize" and that's what it "corrects" to from now on. Of course, when I did the next MSAccessVCS export, git showed a bunch of unwanted (but cosmetic) changes. This pollutes the changeset and makes source control more difficult. THIS. IS. A. BUG. My workaround is, when starting a checkin, I go through the list of changes and group all such changes into one commit called "VBA Artifacts". But come on, this shouldn't be necessary. At least let us know WHY this happens, and give us some control of the process. A way to specify/correct the canonical casing would help.
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.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.Conditional Formatting Partial
Good morning, In need of a little bit of help. My current situation is I can't figure out a formula to highlight partial matches. In my current excel I gather information from a scan then I filter it out to give me the text I want. Now from there I want that filtered info to match another sheet that same text followed with text after. Due to privacy reason I cant share my excel sheet but will provided a similar example. So lets say column D is the filter info from my scan and my list is from column A (in real word list and filtered info are in 2 separate sheets but same book). on the top you can see a formula I have been trying but doesn't always work. I want both sides (or sheets to highlight when it happens).
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.
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
