Forum Widgets
Latest Discussions
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?)NikkiGaaApr 19, 2025Copper Contributor48Views0likes5CommentsAdding up column totals.
Hi, Trying to add up values in Column G2, G2772. Can't get autosum to work right. In cell 2773 I click "Autosum" and enter cell G2, G2772 and the value in G2773 comes up 0.00. I don't know what I am doing wrong. Someone please help. ThankscardsfaninmoApr 18, 2025Copper Contributor18Views0likes1CommentAuto-Sum
I got auto-sum to add the column but the total comes up with a line through it. How do I get rid of the line? ThanksSolvedcardsfaninmoApr 18, 2025Copper Contributor35Views0likes2CommentsExcel 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#M232629Jeremiah_Apr 18, 2025Copper Contributor20KViews0likes4CommentsPower 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.bradbeliveauApr 18, 2025Copper Contributor93Views0likes9CommentsSUMPRODUCT() 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:SolvedpalasubrApr 18, 2025Copper Contributor46Views0likes4CommentsExcel search for files with asterisk or percentage is not working
Hi there Can you please add on the roadmap to have a common way to search files by adding asterisk or percentage? Don't make sense to not be possible such simple query with the standard syntax. Thanks Ricardoricardok1Apr 18, 2025Copper Contributor54Views0likes6CommentsStock quotes from Refinitiv stopped working, any alternatives?
Hi, I've noticed that after March 3rd update to 16.95 on Mac my stock quotes from Refinitiv stopped working. There is no "stock" data type in the ribbon. Same thing with online app. Did you notice this? Are there any alternatives for stock quotes to this data type that gets data from RefinitivTomekGnomekApr 18, 2025Copper Contributor50Views0likes1CommentI need help with transforming data
I have been trying to move my data automatically instead of copy paste cells one by one, but because my data has lots of info, I'm failing in doing so. I added a picture, I only made 6 for the example but I have over 50 agents. I want this data to go automatically in the other format from the picture. So this other format of the table should show how many hours each of them has worked each day. As you can see I need to move the data from the first picture (different table formatting) to the other one. I have over 50 agents, and their time worked is put one by one based on the date. Now on the second one (the one I need to be filled automatically), the table is set on the way where I put the hours worked by agent, one by one for one month. How do I transform my data into that? What's the best formula to use? Please help!BlineraApr 18, 2025Copper Contributor33Views0likes1CommentExcel in OneDrive and on Mac.
Hi everyone, I am working in Excel on a Mac and I cannot add a logo in the header, or type in the footer. all of the ribbon is greyed out so I can't select insert date. I have checked on Microsoft 365 updates are automatic. I have put the spreadsheet in page layout view. I have checked the margins. I have downloaded both documents one contains the logo picture, and the spreadsheet, but still unable to click on the image to paste it in the header. I have checked help function, and worked on it for several hours, but still unable to use it. Cheryl.cheryl1710Apr 18, 2025Copper Contributor22Views0likes1Comment
Resources
Tags
- excel42,582 Topics
- Formulas and Functions24,698 Topics
- Macros and VBA6,402 Topics
- office 3656,020 Topics
- Excel on Mac2,652 Topics
- BI & Data Analysis2,371 Topics
- Excel for web1,917 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,633 Topics