“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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.

Solved by A. A. in 21 mins

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?

Solved by C. C. in 15 mins

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

Solved by F. F. in 14 mins

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

Solved by D. H. in 30 mins

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."

Solved by T. D. in 11 mins

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

Solved by Z. W. in 26 mins

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.

Solved by Z. A. in 26 mins

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

Solved by D. W. in 13 mins

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?

Solved by D. H. in 16 mins

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 ?

Solved by X. Q. in 26 mins