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!
