exception

Hello! Tried finding a response in these threads but no such luck. I don't know if this is possible but basically, I currently have this data validation set: =COUNTIF($E$1:$E$10001,E1)=1 So that no repeating data can be put into a single column. However, I need to make an exception for "n/a" to...

I've basically got a column of names. I want to highlight duplicates. Conditional formatting works well, but but many cells in the column = "?" as a place holder. Obviously this will get flagged as a duplicate as well, but I want to take any cells that = "?" out of the running. So, basically...

Hello! I am trying to do an INDEX formula to find specific dates. Everything was working fine until I realized that I have 2 categories that have the similar name. The 2 categories are "End User" and "End User Exception". I just want to find the "End User" and not have the "End User...

Hi all. Appreciate some help in writing a loop macro to do a task. I am trying to find every position number that doesn't have the correct mapping Manager position number to copy the row from raw data into exception sheet for review. I have three sheets. 1-Raw 2-Map 3- Exception for cell...

I have a measure that I *think* is returning what I want it to, but it's cumbersome and I'm wondering if there's a cleaner way to do this. First, here's the measure: Count of UoM Errors:= SUMX ( SUMMARIZE ( 'Match Exception', 'Match Exception'[ME_Key] ), CALCULATE ( MAXX (...

Hello, I have an Excel spreadsheet that contains the following columns: AGENCY FORM_NUMBER TYPE_DESCRIPTION DEFAULT_SIDE FORM_CREATE_DATE COUNT(*) AGENCY 1 1...

Hi, I use a Try-Catch block to catch errors in my code. This is not strictly VBA code, but VB.NET code which is very similar. I am not sure this is the appropriate forum. I use a general exception to trap my error: Try Catch ex As Exception End Try When the error I have in mind happens, I...

I have a worksheet (schedule.csv) that I wish to remove all rows of data with the exception of those in which the value in column M = variable value usr_date. The worksheet alias is ws_schedule I wish to delete all the rows with the exception of those in which the value in column n = usr_date...

Hi all I need a macro which will copy a folder from one location to another. I have added "Microsoft Scripting Runtime" to my reference library, and have the following code: FileSystemObject.CopyFolder "C:\Users\accsercw\Desktop\210 - Exception Reporting\Final Reports\2235"...

Hello I am new to power query I have a dataset of about about 500 rows of fedex tracking data. Sometimes the query works fine. sometimes I have the error below. To be clear I am using power query in excel not power BI. When it does error it loads around 400 records and then throws this...

Hey, guys, I'm really going crazy with this as I have not been able to figure it out for a couple of days. Let's take the following picture as an example: I'm basically looking for a formula on input on column D which does the exact same thing but with one exception. Let's say we on row 21 we...

Hello everyone I have a userform with several commdandbuttons and I use the code below to close all, when I give instrution for that. But I need just one that must be open and not closed How can i do for that exception. Thank you Sub resertFormClose() Dim ctl For Each ctl In...

Hi, Everytime I try to upload a table into PowerPivot, I keep on getting the same error: Exception from HRESULT : 0 x 800A03EC. I changed around the privacy settings but to not avail. Does anyone have a solution for this?

I have a COUNTA formula running and returning results correctly. I want to amend the formula so that an exclusion is not counted. In this case, i am counting all cells with values in a large range, but i want to exclude a particular value. COUNTIF with exception would not work for this case...

Task I have a commission report for my team - I've managed to get the formule correct to total each person by booking agent BUT, I need to have a check/balance......IF THE RANGE DOES NOT INCLUDE THEIR BKAGENT INFO - SUM IT So, for each employee, its BZ70XX - where XX is their individual...

I have two fields: one called Amount, and the other called Description. The description criteria has something like: Not Like "*TEXT2EXCLUDE*". However, there is an exception to the criteria above, which is do not exclude if >30000000. What's the approach to this in Access?

I'm working on a .NET program to interface with Excel. The code looks like this: private static void ConvertToXls(string xlsxFn, string xlsFn) { var Excel = new Microsoft.Office.Interop.Excel.Application(); var wkb = Excel.Workbooks.Open(xlsxFn, false, true)...

I keep getting this exception when I run a particular macro. The macro errors out and displays the message, "Conversion from string "Request #" to type 'Double' is not valid". However, no where in this module is there, "Request #". I'm stumped as to why we are getting this exception and error...

Hi forum, Encouraged by a solution provided here a couple of days ago I now present a new challenge in the same giant workbook of mine: The controlSource property of any of my textboxes and combo boxes in a user form produces and "Excepion occurred", preventing the user from giving and storing...

Hallo there, I would appreciate help on two questions : 1) what could be the reason for this line to throw an exception : range = worksheet.get_Range("A3", "B4"); myChart.SetSourceData(range.ToString(), PowerPoint.XlRowCol.xlColumns); I also tried If I do it this way...