Forum Widgets
Latest Discussions
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).
SUMPRODUCT() Formula Query
Hello, I'm facing issue while using SUMPRODUCT(). I have 2 different table (TableX and TableY). TableX = Contains Department, Candidates and Joining Date TableY = Department, Candidates and New Column under which I want to populate the count Candidates who will join in specific month. Below formula is not working. Can someone please help on this ? =SUMPRODUCT((TableX[Department ID])=A2)*MONTH((TableX[Joining Date])=6) Table1: Table2:
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.
Filter via checkboxes with multiple criteria
I want to make a feature/application matrix where you can choose features by clicking on a checkbox and the filter needs to show only the application where all the chosen (checked) are available. So instead of the inbuild header filter I want to choose by checking / unchecking the boxes . Example: Can some one tell me how to achieve this? (I prefer to have the features vertically and the application/platform horizontally but I think that's harder to achieve or I'm I wrong?)Excel to PDF images not included
I am experiencing an issue when I PDF an excel file that my images, within the table, are not showing up. My links are also not working anymore. All of this started with the last adobe and excel updates which hit at the same time for me. I found the link below on the Adobe forums. It seems to be pointing to Excel as the culprit. Anyone have a solution for this? https://community.adobe.com/t5/acrobat/excel-to-pdf-images-are-not-included/m-p/10800897#M232629
