Get instant live Excel expert help to learn how to find range in Excel

I'm trying to figure out a formula that lets me find the 3rd character of a number within a certain date range and then take the total count and divide it by the total piece count to give me a % which reflects onto another sheet in that workbook. The formula I am using to find the 3rd character is =SUMPRODUCT(--(MID(I18:I500,3,1)="9")) and =SUMPRODUCT(--(MID(I18:I499,3,1)="8")). Here are some pictures that might help. I need the 3rd character in column "I" to be totaled and then divided by the total piece count "B4" to get a percentage that is reflected on Sheet "PDC Dashboard" in B57, C57, etc based on the date range those pieces are in.

I am trying to look up a value which falls in range of numbers that also have a name assigned to them (for example between 200 to 400 .... meaning two columns is named W5). Can I show screenshot to make things more clear?

I am trying to look up a value based on a range of values and the name assigned to them.

I am trying to get a value based on a range and the name of that range. So basically using two criterias to bring up a value

I am trying to "In Cell E6 enter a formula to calculate the price of the menu item by looking up the price of the menu item from within the Price range."

I'm trying to sum cells associated with a range of dates

I have created a long range plan for training and would like to create an additional sheet that can insert the quarters that are listed automatically.

When i run the macro i get Run-time error '1004': The specified file wasn't found. this is the macro Sub PicturePopulator() Dim B As Range, r As Range, a As Range, _ t As Long, l As Long, w As Long, h As Long Set B = Range("B1:B1700") For Each r In B If r.Value <> "" Then MyFileAndPath = r.Value Set a = r.Offset(0, -1) t = a.Top l = a.Left h = a.Height w = a.Width ActiveSheet.Shapes.AddPicture MyFileAndPath, msoFalse, msoTrue, l, t, w, h End If Next r End Sub

I have data set with 40k entries. The columns include Account ID, Associates, Dates, time, Order Description. I have a list of 100 account IDs. How do I filter out these account IDs using Advanced Filter Criteria Range. I know how to use the Criteria Range to filter the data set to include all the entries with the given Account IDs list. However, I am looking for a way to filter out a data set with a given Accounr IDs. As in, all entries but the ones with Account IDs (7812, 2756, 7297, list has several hundred. Because the given account IDs list I wanted filtered out is very long I can't simply uncheck them. What formula do I use? What would you recommend?

I need a formula that will check the position (B1) and if this position is found on the range (C17:C36), it types the players name on "B2", "B3", etc., ordering by pick. For example Column D (TE) must show Engram (D2), Njoku (D3) Legget (D4). Is that possible ?