Forum Widgets
Latest Discussions
XLOOKUP not working for multiple criteria
Hi all, I am setting up a workbook for boardgames played for someone and he wants to see the high score returned for each game. I have tried xlookup in multiple ways and have had no success. Here is an image of the first worksheet which shows the formula in the cell I have had no success in any form with xlookup so far. This is the worksheet I am referencing: Any suggestions or insights into what I am doing wrong will be appreciated here is the formula written out so you don't have to try and parse it from the image. =XLOOKUP(1, ([High Score]=GameStats[Score])*(GameStats[Board Game]=[Board Game])*(GameStats[Board / Scenario]=[Board / Scenario]),GameStats[Player],,0,1) Thank you for your help. Regards, Larry
Excel Tables and Conditional Formatting
I am trying to format my data by either creating a table or conditional formatting. The data has a common Team ID number with different amount of players. If I create a table, this is what I get: What I really want is to group the team numbers together so it would look something like this: I've tried everything I can think of but the only thing I came up with is this formula =AND(LEN($B3)>0,MOD($Q3,2)=0), but this means that I have to drag the formula every time new teams join. Any suggestions?
Simple property management system
I am developing a simple property management system that would calculate the remaining rent days from the last date of payment. i have design date column from K5:AT5 with headers as 31/03/2024, 30,04,2024 ..... 31/01/2026. the Tanents payment details are just below each date reference i.e. first client K6:AT6, ..... Last client K30:AT30. Now i need a formula that will check the latest payment to the right and reference it to date directly above it and substrate today's day from that date and return of the number of remaining days or due date. Thank
Signed macros are blocked without notification.
Following problem: if the security policy "Disable all except digitally signed macros" is enabled in Excel, signed macros usually work, but sometimes they are simply disabled without any message and cannot be executed, even though the signature is valid. Have already tried the following: re-inserting the signature, recreating and recompiling the macros, saving the file in a different format – all without success. The signature in the macro is valid, but Excel blocks execution without any message. How can this problem be solved? Can i attach an affected file hier?
Pivot Table Elements
I'm looking for documentation that defines all of the various table elements for creating custom Pivot Table Styles. Some are pretty obvious (Whole Table, Header Row, Grand Total Row, etc.), but there are some that seem to have more complex settings. For instance, I applied a Fill format to "Row Subheading 2" and not only did it change the background color of the row, but it also added that background color to every other column. I do not want the columns colored, so I'm not sure how to fix it. Is there any documentation anywhere that explains all of the available Table Elements for creating/modifying an Excel PivotTable Style?? I want to know what each and every setting does so that I can get my PivotTable to look the way I want. Below is a snapshot of the first group of Style Settings. There are more, so I'm not just looking for those in this one snapshot. All help is greatly appreciated!
mac Excel: can't select form Group Box
Hi, I'm using Excel 16.107 on a Mac. I have Developer mode enabled and placed form elements, including group boxes. What I've found is if I delete the text label for a group box, the group box then becomes impossible to select -- there's nothing to click on with my pointer. See attached. Any attempt merely selects the cell, not the group box. How can I select group boxes like this, so that I can delete it or edit its properties?Recurring issue I'm experiencing with charts that are moved to a dedicated chart sheet.
This is also happening to my students in my Excel for Agriculture courses: they send me their assignments, and while the charts look perfectly fine in older versions of Excel, in my Excel 365 I cannot see them properly. As a test, I even opened files that were working perfectly just a week ago, and now my own charts appear exactly like the image I attached. Needless to say, these are not corrupted files, the data source is fully verified, and everything else is in order. The only workaround I found was to insert a new regular worksheet, move the charts to that sheet (where they display correctly), and then move them again to a new chart sheet. After doing that, they look fine again, just as before. Before anyone asks the obvious questions: I have written four Excel books and have been teaching Excel for Agriculture for 20 years, and this is the first time I’ve ever seen something like this. I urgently need a solution. At this point, it makes no sense to keep paying for a Microsoft 365 subscription if this continues to happen. Please, if possible, translate any replies into Spanish. Thank you!
