“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

Hey there. I can't find a easy way to generate a pivot table exactly as i want to see it. I might need some calculated column but i'm never used this feature and i'm not sure.

Solved by M. Y. in 21 mins

Hi,
Is it easy to create charts based off my summary tab? I have a lot of formulas feeding into the summary and I couldn't find an easy way to make simple charts to visualize the data

Solved by G. W. in 14 mins

I'm trying to find the "US WS" Price (United States Wholesale Price) via Vlookup, but it's just not working right. I don't know what the issue is. Please take a look at the vlookup steps and help me identify the error.

Solved by A. Q. in 27 mins

Hi there,
I need to fill out the yellow section of the workbook. I need a formula which can drag the data from another work book onto this spreadsheet and one that I can just use for every week. Ideally I would want the formula to match the cell with the week number. I am needing it to find the week number and transfer the formula for a 1 week forcast in one cell, a 2 week forecast in another cell and finally a 3 week forecast in a third cell.
Hope you can help.
Thanks

Solved by T. J. in 20 mins

I am trying to find the interest rate that has been applied to this loan with a compound interest calculator excel. The loan is on a 365 basis. I keep getting an error using the RATE formula which I suspect I am not using properly -- it does not seem to be the correct formula, perhaps, for compound interest.

Solved by F. F. in 11 mins

FINANCIAL FORMULA FAMILIARITY HELPFUL I am trying to find the interest rate that has been applied to a loan. The loan is on a 365 basis. I keep getting an error using the RATE formula excel which I suspect I am not using properly -- it does not seem to be the correct formula, perhaps, for compound interest.

Solved by V. C. in 30 mins

Just wondering how I insert a pivot table, i know how to do in excel but can't find a similar function using Google Sheets

Solved by D. F. in 16 mins

I need to find the average weekly and per post "organic" reach and engagement. Amount of posts per week vary.

Solved by D. U. in 11 mins

Hi!
I have 2 data sets.
The first data set is the big one w/ thousands of entries and several columns.
The second data set is the smaller one with three columns of info from the big data set. There are a hundred entries.
The small data set has select account IDs that correspond to Associates. Some Associates service multiple account IDs and therefore have multiple account IDs corresponding.
The big data set has thousands of entries. Though each entry has a corresponding account ID, there are several orders, so account IDs may have several entries.
I'm only concerned with the account IDs and Associates of the small data set even though the big data set has all account IDs and Associates orders.
I am looking for a way to filter out or generate all the entries in the big set that fit certain criteria. However, this criteria is linked, so all the entries that have A and B criteria in respective rows.
I narrowed the list of orders from Associates with specific orders and have the Small set showing the account IDs, associate, order, date.
I need to go to the big list of all orders and now find all entries with order equaling - product A and on date - X. So only the entries with both product A and date X. Not either or, both criteria must be present.
To do so, I have used VLOOKUP to get the initial list of what all orders made from the small sets associates and found the orders and corresponding dates I'm concerned with.
Then I Went to the big list and tried to use filters to find entries with product A done on on date X.
What would you suggest?

Solved by V. E. in 20 mins