Recent Discussions
Max of Fiscal Year in pivot table Value section is not working
There are three data columns in the shared Excel file at the link below. Membership ID formatted as text Num (billing id) formatted as text FiscalYear formatted as numeric The pivot table values for the MAX of FiscalYear in the Value section are all 0. I expected to see the most recent fiscal year for each unique membership id. The FiscalYear data column: has no blank cells has no text cells has no mixed numeric/text cell values The pivot table has been refreshed. Would you please explain why the most recent fiscal year for each membership id is zero? Once I understand what the issue is and resolution, I will expand the pivot table range to reference the entire column for each of the three columns instead of a ranged specified by specific row numbers. The link to the Excel file is: https://docs.google.com/spreadsheets/d/16B3JJ_Zn1848R4THgxYcz1piwju5Zlg7/edit?usp=sharing&ouid=111420556245583625384&rtpof=true&sd=true Thanks in advance for your help!Solved56Views0likes3CommentsMAX of numeric data column in excel pivot table returns 0
There are three data columns in the shared excel file - a Membership ID column formatted as text, a billing number in column Num formatted as text, and a FiscalYear column formatted as numbers. As I want to see the most recent fiscal year in the pivot table for each unique membership id, I added MAX of FiscalYear in the pivot table Value section. In the FiscalYear data column: There are no text entries. There are no blank cells in the column in the pivot table range. The formatting in the Value Field Settings for MAX of Fiscal Year is numeric. I have refreshed the pivot table. Yet I am seeing a zero for each Membership ID rather that the most recent fiscal year. Would you please explain why the Max of FiscalYear is not working correctly, and once I understand how to correct the problem, will the correction also work when I expand the pivot table range to reference the entire FiscalYear column rather than the column cell values in the first 29 rows? There will be blanks in the unpopulated FiscalYear column cells as the remaining rows will be blank for all three data columns until more rows are added over time. Link to the Excel file on OneDrive https://docs.google.com/spreadsheets/d/16B3JJ_Zn1848R4THgxYcz1piwju5Zlg7/edit?usp=sharing&ouid=111420556245583625384&rtpof=true&sd=true Thanks in advance for your help?Solved66Views0likes3CommentsCalculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.Solved67Views0likes4CommentsTechnical Question: Is a Range argument passed to SUM as a Reference or an Evaluated Array?
Hi everyone, I have a technical question regarding the internal mechanics of the SUM function's arguments in Excel. Specifically, I’ve noticed that in the ODF (OpenFormula) specification, the argument is defined as a NumberSequenceList. However, I am unsure how Excel’s internal engine implements this. When a formula is written as =SUM(A1:B5), what exactly is passed to the function? I am trying to understand which of the following conceptual models is correct: Reference Passing: A Reference to the range A1:B5 is passed, and the SUM function iterates through the cells internally. Pre-evaluation: The range A1:B5 is Evaluated into a sequence (or array) of numbers before it is passed as an argument to the SUM function. I am authoring a technical manual and want to ensure I describe the relationship between cell references and function arguments accurately. Does Excel follow a similar abstraction to the ODF NumberSequenceList, or is there a different internal logic? Thank you in advance for your insights!Solved74Views0likes2CommentsData Formatting
Dear Experts, I have a Data like below :- Each row can have 1 or more RNTIs( seperated by ",") and their DCI( UL_01 or UL_00), I want to put them in a format like in Col - I~P gave examples for the 1st two entries. Attached worksheet. Thanks & Regards Anupam ShrivastavaSolved178Views0likes5CommentsCorrelation Study with Filters
Dear Experts , I have a data like below( Attached worksheet) And want study the correlation between SNR[0~3], there will be 6 combinations as below:- I want make like this but with Filters/Slices for the "File.Name" & "SSB or TRS" & "Carrier Index", different colors for different Carrier Index(0 &1) Thanks & Regards Anupam ShrivastavaSolved121Views0likes2CommentsWhy is my create file from OneDrive for Business node isn't working?
I have a power automate cloud flow that, in some point, gets a word .docx from my sharepoint site, then it creates the same document in onedrive so that I can convert it to PDF then returns it to sharepoint. This idea came from the necessity of converting a .docx to .pdf without the need of premium conectors. I have 2 scenarios: 1° Scenario: Flow: I get the data from the word that I need > I create the same file on OneDrive > I convert the file to .pdf > then I create the file on Sharepoint. Problem: When I run my flow, it gets a 404 error: "message": "File Not Found\r\nclientRequestId: y-f695-48b1-9556-xc\r\nserviceRequestId: x-e051-b000-efc3-y" Error image: 2° Scenario: Flow: The same as the above, the only thing I did after research, is that the node that I get content from file from my sharepoint site also returns the "$content-type", so I specified that for the create file from OneDrive I'll only want the "$content" attribute. In resume, it creates the file in onedrive but I can't open it, it appears to be corrupted, at first I thought my sharepoint file was also broken, but then I could open it with no errors as on OneDrive. Problem: When I run my flow, it gets the error that it can't convert that kind of file (as I wrote above, the file creates corrupted), the main problem is understanding why it gets corrupted, it even returs the content-type that I'm not passing anymore. Error image: Message: "message": "Error from microservice: {\"status\":406,\"message\":\"Não há suporte para a conversão desse arquivo para PDF. (cannotOpenFile / Error from Office Service. Url=https://wordcs.officeapps.live.com/document/export/pdf HttpCode=BadRequest)\",\"source\":\"api.connectorp.svc.ms\"}\r\nclientRequestId: y-13f3-4e1a-a77a-x\r\nserviceRequestId: y-a09f-b000-f272-x" NB: This flow actually worked for more than 1 year with no problems like that, the last time it ran without errors was last week (6-7 days from today).Solved69Views0likes2Commentsline spacing
I'm creating a word doc (w/the help of ChatGPT). I copied and pasted from GPT into a Word doc, but I can't duplicate the spacing from one line to another. When I put the cursor behind a line and hit enter, the next line doesn't match up. Industries We Serve ✔ Medical & Clinical Laboratories ✔ Pharmaceutical & Biotech Facilities ✔ Research Laboratories ✔ Dialysis Centers ✔ Electronics Manufacturing ✔ Industrial Processing Facilities This is what happens when I put the cursor behind Laboratories. The spacing is way bigger and has no checkmark. What gives? ✔ Medical & Clinical Laboratories ✔ Pharmaceutical & Biotech Facilities ✔ Research Laboratories ✔ Dialysis Centers ✔ Electronics Manufacturing ✔ Industrial Processing FacilitiesSolved74Views0likes2CommentsLooking for help with a single Dynamic Formula Ranking Points by player and dropping lowest score
Name Finishes Andrew 1,1,2,3,7,8 Randy 2,4,5,5,8,9 Chris 1,1,2,3,7,8 Bill 1,4,6,6,7,9 Jeff 2,3,5,7,8,8 Reed 4,4,6,7,7,9 Doc 3,5,5,6,7,9 Steve 1,3,5,6,8,9 Paul 2,2,3,3,4,9 Points (1st, 2nd, etc) 165 105 75 50 35 25 20 15 10 Expected answer with lowest point dropped Name Points Chris 530 Andrew 510 Paul 410 Steve 315 Bill 285 Jeff 250 Randy 240 Doc 190 Reed 165Solved335Views0likes18CommentsUser input fields in power query
I have a power query table of employees from an employees worksheet in the current workbook. First Name Last Name Address Etc. Which I feed into Power Query. I want to generate other tables in the workbook using the first and last names from the above table as a starting point, but adding user input fields. I was able to do this initially by having power query generate the first two columns, and put another table next to it with the user input fields to "fake it" and combine everything in a subsequent query. I was wondering if there was a more elegant way of creating a new Excel table (and probably a new sheet to put it on) by using the two columns from the sheet I already have, plus any additional columns I need for users to fill in. Either using standard Excel or power query, if I can stop power query from zapping the user input fields on a refresh. Note: I don't know how to have Power Query add a column without assigning it an initial value like null. That is why my user input fields are getting zapped building the entire thing in Power Query at the start.Solved127Views0likes3CommentsMS Word is throwing up 'Error 4608' I haven't a clue what to do.
Hello, I wonder if anyone can help me here, because I am at a TOTAL los... I have a Word document that I have been updating for a few years, which is a sort of log. It has worked well up until today. Now, whenever I try to save the updated document, a very old fashioned (looks like Windows 3.1!), error message window appears which is headed 'Visual Basic for Applications' and in the window it says: Run-time error: '4608': Undefined dialogue record field There are then four buttons at the bottom labelled Help, Continue (which is greyed out), End and Debug. I have no idea what this error message means. Clicking on End gets rid of the error message, but prevents me from saving my updated document, and the next time I try to save it the error message just reappears. Clicking on Help takes me to a website with the title 'No F1 help match was found', followed by a load of technical computer-geek stuff I don't understand. Clicking on Debug seems to open a new window, but I do not know what it is... Here is a screen-shot of it: The highlighted text seems to refer to Bookmarks, which is throws me because I only associate Bookmarks with my web browser, not MS Word. I'm sure I haven't added any bookmarks to my document in any case. Can anyone enlighten me as to what is going on here please? ThanksSolved121Views0likes6Commentsequation or function?
+0.3°c -0.1°c +0.4°c Looking for either an equation or function for this, in order to simply enter column A & B and have answer autofill. The number in column A is the constant number that I want column B to be ie: what must happen to column B to equal column A, as you can see in column C you add 0.4 so that column B equals +0.3. As seen below there is variation from positive and negative numbers in both columns therefore at any given time it will be adding or subtracting?? +0.2°c -0.2°c +0.4°c +0.3°c -0.3°c +0.6°c 0.0°c -0.1°c +0.1°c -0.1°c +0.3°c -0.4°c -0.2°c 0.0°c -0.2°c -0.1°c +0.2°c -0.3°c anyone help me out, could save some considerable productivity time?Solved116Views0likes4CommentsFilter Function or TAKE-DROP Function
Dear Experts, I have a Data like this:- Column A -> Has the File Names, and Column B,C,D have their corresponding data, In Column F I have the unique File Names and from G/H/I -> I need the start of the hfn/sfn/slot and in J/K/L the end of the hfn/sfn/slot for that File Name as populated , How to achieve this? Thanks & Regards Anupam ShrivastavaSolved298Views0likes8CommentsNeed help autofilling.
Good morning all, Thought I posted this but I am not seeing it anywhere so I apologize if this is a repeat. I was tasked with filling in a spreadsheet with data including; Our part number, our description, supplier name, supplier number assigned by us, and supplier part number. I noticed that a lot of the part numbers repeat so I am trying to find a way so that when the column with our part number repeats it will auto fill the columns with the supplier name, supplier number and supplier part number automatically when I enter a repeating part number if possible. I am very much not excel savvy but I am pretty computer literate. I have attached the document I am working on, there is no customer data what so ever and all part numbers are internal so are not proprietary. https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQCj4grl62sHQYohshZJ9Mb2AX7_MknXYW1QiMk8wv2sdfQ?e=duyOxLSolved124Views0likes2CommentsHow do I get repeating part numbers (data) to auto fill data.
Sorry I am not very Excel savy but I was tasked with filling a spreadsheet with data of our part numbers, their description, the supplier we get them from, our assigned supplier numbers, and our suppliers part number for kits we make in our company, there are over 9000 but I have noticed that there are a lot of repeating part numbers so I was hoping there was a way so that I could have that data auto fill. I can post a link to the document it does not have any proprietary data that I can see. https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQAYSdPfHYQvRp6TRW4hg_xjAYh_4Jjl2Z_aCXX_64zMf50?e=MKDtrRSolved179Views0likes4CommentsConditional Formatting or a Specific Filter Rule
Dear Experts , I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissions and their corresponding Retransmissions ( either by coloring them all using a conditional formatting) or using a specific filter Rule. How to identify the Transmission and it's corresponding Retransmission for a Specific HarqId( say for dlHarqProcessIndex ==7, the blue color Row-37 is my 1st transmission(txNumber ==1) for the dlHarqProcessIndex==7 with a tbSize of 852696, and adaptRetxStatus == NOTACTIVATE, and it's corresponding 2nd transmission( Retransmission , txNumber==2) Row-45, tbSize remains same(as it's corresponding 1st transmission) in all retransmissions and adaptRetxStatus changes to "APPLY" for all retrans txNumber==2,3) and similarly for other pairs like for dlHarqProcessIndex==13. Attached is the Worksheet.Solved192Views0likes5CommentsXLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and have the last three fields populate. Now, I can get this to work for one, but not the other and for some reason when I switch from bottom search to the top search the old data doesn't clear and the search doesn't work. This is the formula I have so far //=XLOOKUP(H8,A2:A10606,B2:B10606) Anything I have done after has been a disasterSolved193Views0likes8CommentsEXCEL 360 COMPATABLE WITH 2010 XLSM FILES? THE MACROS IN VBA?
EXCEL 360 COMPATABLE WITH 2010 XLSM FILES? THE MACROS IN VBA? I developed a complete workbook the excel 2010 for my business and was wondering if I can use the new version of excel? Hoping that all the macros will work... Thanks for any help !! DaveSolved105Views0likes2Comments
Events
in 16 hours
Learn more about the capabilities of Agent 365 in this live 'Ask Microsoft Anything' with product and engineering team experts! Get your questions answered about capabilities for agent observability,...
Wednesday, Mar 18, 2026, 09:00 AM PDTOnline
4likes
373Attendees
1Comment
Recent Blogs
- The matchups are finally set, and the annual question is back: how do you pick a bracket that’s fun and gives you a real shot at predicting the winner—whether you’re following the men’s tournament, t...Mar 17, 2026211Views1like0Comments
- Technology is evolving at a startling rate, and it’s no longer enough for an organization to maintain their security measures, they must evolve along with it. Don’t let your data, employees, or clien...Mar 12, 2026247Views0likes0Comments