Recent Discussions
PivotBy or GroupBy
Dear Experts, Quick question, I have a data like this from Column A~F, and want to make a data like in Col J~L So, I want a summary , that for the slot0 && txnum==1, what are the unique values of numOfPrb, but in case of slot5, we have more than one unique value and it spills, could you please suggest a solution for this, I tried Filter function etc.. may be there's solution within , or if Groupby or Pivotby can help here. Attached is the worksheet, Br, AnupamCan't print this document! Print preview not matching Page Layout or Page Break Preview
I'm trying to "print" this to PDF, but can't get all my tables and graphs to fit nicely when printing This is my view in Page Break Preview This is my view in Page Layout This is the Print Preview screen, I think when it's scaling the rows to fit on one page, it's not scaling the graphs as well so they keep moving around. How do I make this look nice when I print? I have 16 tables with graphs plus a footer, so they aren't going to fit all on one page, that's why I set it to print over 4 pages.
Advanced Excel Formula discussion - Problem with dynamic range
Let's assume I want to rent a house. For each house, if the landlord has an agent, I'll contact the agent; If not, I contact the landlord directly. As below: Landlord Agent House Landlord James Mary W James Linda Michael X David Y Linda Z James Column F: =IFERROR(XLOOKUP(E2:E5,A:A,B:B,E2:E5),E2:E5) This is correct Column G: =XLOOKUP(E2:E5,A:A,B:B,E2:E5) #VALUE! for X-David Column H: =XLOOKUP(E2:E5,A:A,B:B,CHOOSECOLS(E2:E5,1)) Wrong value for X-David, because it returned the first value in range of XLOOKUP([if_not_found]) field My question is: the only difference between G and H is CHOOSECOLS(). If I put =CHOOSECOLS(E2:E5,1) or =E2:E5 in a separate cell, it gives me same result. However, in XLOOKUP, they are recognized differently. What is the logic behind this? Thank you for spending time on reading this.
Using Upper and or Proper Function - not working properly
I am trying to use the UPPER function on my Excel sheet. I was able to format my first column, but when I try the next column, it won't convert. I have tried several times, and it will not convert the function. I have included two screenshots to show the progression. I formatted the column to text, and have tried to troubleshoot any tips I have come across. I have tried both on my desktop and uploaded to my 365 and both have the same result. What am I missing?
How to add a new field to existing XML Mapping
Hi, everyone! Good day! I've made an XML file which I imported to my doc using XML Mapping Pane -> (Add new part...) and I used it to map some texts. How could I add new fields to this XML Mapping? What I tried: I tried editing the XML file and then importing it again. As a result, I have two XML Mappings with the same name that act as completely separate mappings. I couldn't even find a way to delete the older one.How to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, AnupamIndex and Match command is return results from the wrong column
Within Excel I'm using the Index and Match command to search an array. I've provided copy of the workbook. Here is the command =IFERROR(INDEX(D7:H11,MATCH($D$13,L7:L11,0),MATCH($E$13,M7:M11,0)),"") Here is an added twist on sheet 1 I use this formula and it works correctly. This formula is on sheet 2. The results for the Average column returns correctly. The other columns appear as if the were flipped. When the Marginal column is selected I get results from the Above Avg column. The opposite happens if I choose the Above Avg column I get the Marginal results. The same thing happens if I choose the columns on the ends. As shown in the image above the Extreme row is selected and the One column is chosen. The result should be "Caution", but instead the result is "None6". FYI, this is part of larger workbook where the results will be posted on a different worksheet, but to simplify everything I've placed it on its own page. Regards
Recent Blogs
- Rich alt text is automatically generated when you insert an image, making your content more accessible from the get-go.Dec 22, 2025
- Powered by Microsoft 365 Copilot, Explainer offers instant summaries and explanations of text.Dec 19, 2025
