Forum Widgets
Latest Discussions
Degenerate MAP blows up Excel
Does this formula work for you? =MAP(0,1,LAMBDA(x,y,x+y)) Which Build are you on? I am stuck on 2406 because all Builds since blow up when running my spreadsheets - which, as I type this, JUST MIGHT be down to this nonsense. Not only does this innocent instruction return #VALUE!, it also appears to corrupt Excel beyond recovery. Which is a problem because the MAP(LAMBDA( phrase is a wrap one needs to deploy when a Lambda(a,b... might have to handle vectors for a and b to return a vector of results for a computation that will not support such vector inputs natively. The cure for this nonsense on my Build appears to be =MAP(HSTACK(0),HSTACK(1),LAMBDA(x,y,x+y)) Unfortunately, it is hard to remember this. I might have to scour my Lambdas. The problem only appears to concern MAPs with multiple vectors. =MAP(1,LAMBDA(x,x)) is just fine.ecovonreinFeb 08, 2025Iron Contributor3Views0likes0Commentshow to add a confidential watermark in excel when printing
how to add a confidential watermark in excel when printingcommunityyaky19Feb 08, 2025Copper Contributor5Views0likes1CommentCan you search for multiple things at the same time
Each day I receive a list of about 50 unique 6 digit numbers on a spreadsheet. I then have to check each of these numbers individually on a second separate spreadsheet to avoid duplication of work. To do this I copy one unique ID from the 1st spreadsheet and use the 'Find' function on the second spreadsheet. Doing this 50 times is quite time consuming so I was wondering if there was a way of searching all 50 at the same time. I am in no way tech/excel savvy so please any replies can they be in 'idiots guide'. Thanks everyone!SAndrewFeb 08, 2025Occasional Reader7Views0likes1CommentCalculate which parts make up the total sum
I Have a problem with receiving only a total sum and then I need to figure out what partial sums in a long list that makes up that total. Is this somtehing that is possible for Excel to calculate, or in some other application. Doing it manually takes a long time and is sometimes impossible.MachinehandlerFeb 08, 2025Occasional Reader14Views0likes1CommentFormula Error making my head explode!
I have a pretty intricate spreadsheet tracking staffing and OT usage and ONE line has an error code that is throwing off the whole thing! I am banging my head against the desk because I CANNOT find the error. The actual formula is correct and pulling the right answer, but still giving me the error notification in the top of the cell. This is causing the next step in the spreadsheet to also show an error. Anyone that can help a girl out?!?!?kaylatimmsFeb 08, 2025Occasional Reader11Views0likes1CommentYear View for Dynamic Calendar
Anyone able to assist with a yearly view for a dynamic calendar? I have a month view which pulls dates associated with a deployment from a table (I got this template from someone in the excel community). I figured I could just copy the month calendar 12 times and just change the months in the drop down but it isnt updating the dates and therefore, not pulling the deployment details. Attached is the file. The first table in the year view sheet is working as that was the same table I copied from the month view sheet. All other table do not work.barbdd12Feb 08, 2025Copper Contributor27Views0likes4CommentsAdding existing VBA/Macro in Private Function to new Workbook
Hello again! I have inherited a workbook with a Macro that stores qualitative notes in a separate worksheet and compiles the notes over time. I want to take that Macro and apply it to a new workbook and use the functionality for the same purpose. When I move the Macro into my new workbook, it doesn't come up as an executable process - that is, it doesn't show up in my list of Macros to run. (See below image) I am new to Macros and still learning, but is there some way to get this Macro to run in my new workbook? This is the first part of the Macro which checks the setup of the in use workbook and makes adjustments accordingly. Anytime I've created my own Macro, it starts with the 'Sub' header. I have other Macros in this VBA that begin with 'Sub' and they show up in the list of Macros to run. In this Macro, however, it starts with 'Option Explicit' and then 'Public Function'. There are also parts of the full Macro that begin with 'Private Function'. My thought was to make these available to any workbook that I create, but since they aren't showing up on my Macro list, I can't make the adjustment to have them exist in any workbook. VBA: Option Explicit Public Const sRngName = "PT_Notes" Public Function Check_Setup(ws As Worksheet) As Boolean Dim rNotes As Range, i As Long Dim PT As PivotTable, ptField As PivotField Dim tblNotes As ListObject Dim wsSave As Worksheet '---Check if not exactly one PT on Worksheet- exit If ws.PivotTables.Count <> 1 Then GoTo StopNotes Set PT = ws.PivotTables(1) '---Check if not Compact Report layout- exit For Each ptField In PT.RowFields If Not ptField.LayoutCompactRow Then GoTo StopNotes Next ptField '---Check if Named Range "PT_Notes" doesn't exist- define it If Not NameExists(sRngName, ws.Name) Then With PT.TableRange1 Set rNotes = Intersect(PT.DataBodyRange.EntireRow, _ .Resize(, 1).Offset(0, .Columns.Count)) End With Set rNotes = rNotes.Resize(rNotes.Rows.Count _ + PT.ColumnGrand) ws.Names.Add Name:=sRngName, RefersTo:=rNotes Call Format_NoteRange(rNotes) End If '---Check if "|Notes" Worksheet doesn't exist- add it If Not SheetExists(ws.Name & "|Notes") Then Set wsSave = ActiveSheet Sheets.Add ActiveSheet.Name = ws.Name & "|Notes" wsSave.Activate End If '---Check if Notes DataTable doesn't exist- add it With Sheets(ws.Name & "|Notes") On Error Resume Next Set tblNotes = .ListObjects(1) If tblNotes Is Nothing Then .Cells(1) = "KeyPhrase" .Cells(1, 2) = "Note" Set tblNotes = .ListObjects.Add(xlSrcRange, _ .Range("A1:B2"), , xlYes) End If End With '---Check if any PT fields are not Table Headers - add With tblNotes For Each ptField In PT.RowFields If IsError(Application.Match(ptField.Name, .HeaderRowRange, 0)) Then .ListColumns.Add Position:=2 .HeaderRowRange(1, 2) = ptField.Name End If Next ptField End With Check_Setup = True Exit Function StopNotes: If NameExists(sRngName, ws.Name) Then Application.EnableEvents = False Call Clear_Notes_Range(ws) ws.Names(sRngName).Delete Application.EnableEvents = True Check_Setup = False Exit Function End If End Function Thanks!!burnskrlFeb 08, 2025Copper Contributor52Views0likes5CommentsAutomatic Rolling 12 Month List
Hi all I've looked first but nothing seems to give me what I am looking for. Hope you can help! I'm simply looking for a rolling 12 months list that automatically updates based on the current date. The financial year starts in March. An example below based on today's date being in February 2025: Column A January 26 February 25 March 25 April 25 May 25 June 25 July 25 August 25 September 25 October 25 November 25 December 25 The idea being that once the month has passed, February 25 would become February 26 in the list and so on. Can this be done with formula based on the today() date? Thank you for any helpSolvedmatt0020190Feb 08, 2025Brass Contributor49Views0likes4CommentsHelp creating a matrix table
Good day wonderful people, I am trying to create a matrix table that shows correlations between types of issues people may be worrying about. The end result is to enable me to bring it into Power BI and utilize the chord visualization diagram to show where certain issues are connected and the strength of those connections. I have an excel sheet with a range (se below). The first column is a unique client ID. As the data may be collected over a period of time, the same client IDs may appear more than once (if they come back to the service provider). The data may include up to a maximum four issues that they are worrying about, and these are in adjacent columns to the client ID. As an example, in the below table, homelessness has low level interconnectivity with 'Priority Debt'; 'Disabled' & 'Mental Health' as they appear as issues alongside with that string; "Mental health" has a strong connection to "Non-Priority Debt" (and of course vice versa) with it occurring each time the other is mentioned. This is what I am aiming to show. Due to the way in which this data is laid out (from a database export), I am struggling to bring it into a matrix table (if that is the best method) and then on into Power BI. I've spent quite a bit of time in the forums, but can't find a way to apply the learning in them to the table output, or the right way to transform the data (via power query or otherwise) to help identify the interconnectivity. If anyone can point me in the right direction to solve this, I would be most grateful! Thank you in advance :-)17Views0likes1CommentMake Excel Chart from multiple sheets
I hope once again for help with excel, since this community was super helpful before. I have multiple sheets in a excel sheet and I would like to create a chart that pulls data from multiple of those sheets. I have Team 1 & Team 2 (on separate sheets within one file) and data on how many people of each team are at any location at any given day of the week. I would like to create a chart that shows the location on the x axis. I would like to show how many people (regardless of team) are at any location each day. If possible it also shows how many people of each team are at Location 1 on Mon, and so on. I am happy to change the data collection sheets as well if that helps.YvonneD2170Feb 08, 2025Copper Contributor15Views0likes1Comment
Resources
Tags
- excel42,162 Topics
- Formulas and Functions24,441 Topics
- Macros and VBA6,347 Topics
- office 3655,930 Topics
- Excel on Mac2,615 Topics
- BI & Data Analysis2,327 Topics
- Excel for web1,876 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,606 Topics