error

Hello, In column A, I have: =SORT(UNIQUE(FILTER('Headcount Report'!A3:A909, 'Headcount Report'!A3:A909<>""))) which pulls a list of unique values. In this list are locations by type, i.e St Albans - Yard, Colchester - Transport. The three types are "Office", "Yard" and "Transport" all appended...

I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer. Using this video - I have this code: TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate...

Hi Everyone, I'm trying to add an additional condition that doesn't seem to work and I can't figure out why. The new condition is looking at another column for the word "yes". My current formula is following: =IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open...

Hello, I wrote a vba code where if certain cells changes in value that excel will then run an existing macro. However, I keep getting an "Code execution has been interrupted" error almost 80% of the time that it runs. When I hit debug and press continue, everything works normally so I know...

How would I create a macro that removes all the rows where there is a #NAME? error in Column E?

XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors XERROR.TYPE takes three parameters, one requires, and two optional, as follows: A) The first parameter, required, specifies the input and can be a single cell, range, or array. B) The second parameter, optional...

I ran into this problem before, and don't remember how it was resolved! I'm getting this error: And no, it is not because the name starts with an underscore or because the parameter is bracketed because it's optional I have no doubt it's something dumb. Could be me!

Hello, a few of my collegues use a macro that is in their Personal workbook and connected to a custom button in their quick access ribbon. Suddenly they are getting an error pop up that it couldn't find their Personal workbook (asking "is it possible it was moved, renamed or deleted") - but it...

Hi All, I have a excel where I have made some Macros, Power query and formulas. not sure what is causing this error but I'm unable to save it, it used to work well before :( any suggestions please? Thanks

MATCHES is a powerful enhancement to the Excel's built-in MATCH function and returns the relative positions of all items in a one-dimensional array that match a specified value Excel's built-in MATCH function returns the relative position of the first matching item in a one-dimensional array...

ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well ISXTYPE was designed to provide conditional output after assessing the precise and high-resolution data type of...

XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",) XTYPE was designed to provide detailed and high-resolution information about the data type that a cell or cells of a range/array contain. Thus, it is...

XERROR allows for conveniently generating most of the Excel errors as output to functions With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...

Working on Excel VBA app. And I am getting an error I can not figure out. The app is displaying a range from a spreadsheet in a list box on a user form, The first time it does this, things work fine. The user form has some text input boxes that allows the user to input a new row of data unto...

Version: Excel Online I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way. Example "TABLE_1" EE Name...

I'm using the below code to bring up the file dialog box so the user can select a file path to save a file. What I want to do is stop an error from occuring when the user clicks the 'Cancel' button in the dialog box. Currently when you click 'Cancel', it comes up with 'Run-time error '5'...

Hello All, I tried to do a loop that would write an entry to an error log sheet in the event a folder couldn't be created or already existed, but I haven't done it well, and continue to endlessly generate errors. If someone has any insight into where I went wrong, or suggestions on a more...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...