# avg

1. ### Need help with Find Method

I have four columns with over 400,000 rows of data labelled (Year, Avg, UIC, Group) that look like (2013, 1.563, 0011, 23). I want to distribute them into 322 separate matrices, one for each Group that have columns labelled by the year: 2013 to 2019 and rows labelled by the UIC from 0001 to...
2. ### Too few arguments / formula is missing an open/closing parenthesis

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody> I copied the formula from a similar one in another thread here, but keeping getting either "too few arguments" or "closing parenthesis". Help? IFERROR(IF(I3="AVG",VLOOKUP(A3,'Master Table'!\$A\$3:\$Z\$3537,22,FALSE),IF(I3="P1/CY...
3. ### Criteria-based Calculation of the Average Amount of Working Hours

Hey everyone, I'm struggling with trying to correct a formula which is currently delivering a wrong result or at least not the result I am supposed to achieve. The problem is that the current formula divides by the number of all rows / bookings with the same "contract number" on sheet1...
4. ### working backwards from weighted averages

Hello, I have 3 numbers that were given to me that are \$/SF weighted averages. The developer didn't provide the weight factored into calculating each average. <tbody> Total Project \$/SF Average 1st Product \$/SF W. Avg 2nd Product \$/SF W. Avg 3rd Product \$/SF W. Avg 379 398 339 289 % of...
5. ### creating BINs by altering variables

Seems simple enough but i have been unscuccesful DATA: columns NodeName, Weight A1, 800 A2, 800.1 A3,820.9 A4,815.3 A5,801.6 A6,801.6 A7,815.3 you get the idea. very simple data, except i have thousands. I've tried creating histograms and that works fairly well but you can't really see the...
6. ### Rank using 2 tie breaker columns

Hello, I am needing to rank a table that has columns for Names, Point Totals, Avg Race Position, and Avg Qualify Position. The ranking should be by largest point totals, however if there is a tie, the first tie breaker would be by lowest avg race position, and if still a tie, by lowest qualify...
7. ### Dynamic chart

https://drive.google.com/file/d/1aYHDusIlfizyXRo8-GWl9xhRpZww-ajB/view?usp=sharing I'm trying to create two different types of dynamic charts using the data linked above. I cannot attach files. I'm trying to create the first chart on the tab called "Tenure Band (Hours - Graphs)" using the...
8. ### Efficient way to merge data

I have all of the data from our third-party analytics tool - all in CSV files. The format comes out as this: Excel 2013/2016 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L 1 Media Impact Origin Market Breakdown 2 Advertiser Visit Britain 3 Date Range Jan 1, 2018 -...
9. ### sumif non blank depending on criteria

how can i sum column D of non blank column C depending criteria of column A i have tried sumif but it totaling full column <colgroup><col><col><col><col></colgroup><tbody> COL A COL B COL C COL D AA TTT Q1 46228 AA TTT Q2 76700 AA TTT Q3 67967 AA TTT Q4 67967 AA TTT AC 30443 AA...
10. ### Weighted avg

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
11. ### Is there a formula (ideally) that can take some semi-structured data in one column and split it into multiple columns?

I have a data set with around 10,000 rows in one column that contains approximately 1,500 individual profiles. https://monosnap.com/file/kInwZwsYoJuvhBsY9pQESDxGGZgZ3r I need to transform this data into the following columns Twitter Handle Following Followers Avg. Likes Avg. Retweets...
12. ### Column to Rows Question

Hi Everyone, I am looking to move columns to one row. The one row will contain 20/40,30/50,40/70,100M. Is there a quick way to do this? I have roughly 95 columns and multiple formulas in the table. Listed below is an example of my current table: <colgroup><col><col><col><col...
13. ### Problem with Averages

Hi All, I'm working on this problem about test scores and I'm trying to figure out why I'm getting a different number when I get a mean of pupil grade score percentages versus when I do the other way by getting a mean for each individual test and then averaging that? I have noticed that if the...
14. ### Why 1004 Run Time error at Red Text?

Sub CopyData_Machine_Performance() Application.ScreenUpdating = False Dim lastRow As Long lastRow = Sheets("DATADump").Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Dim ldateto As Long Dim ldatefrom As Long Dim ThisMonth As Long Dim ThisYear...
15. ### Pivot table

Hello, I have an AVG formula outside the pivot table but the data referred in the AVG formula is in the Pivot table. I have a "Grand Total" column in my Pivot table which is the Avg formula reference. As an when I change the pivot criteria "Grand Total " column moves due to the data but the Avg...
16. ### Multiple IF statements

Trying to write an IF statement that will return the following in a new cell. If the "% replenished/visit" is greater than 20% then return "avg. qty Ord/visit" - otherwise return 0. However if "% replenished/vist" is greater than 20% and the "std. Dev." is over 2 then add 10% to "avg. qty...
17. ### Conditonal format pivot table based on comparing two values

hello, working on a pivot table conditional formatting and need help. I want to compare each month AVG CPH to previous month and if greater format green and less format red. for example in February NTX cph was higher than January so that would be green and WTX in February is lower than January...
18. ### Average based on criteria

Hi, I am looking for a way to calculate an average total dependant on the selections made. So in this example the selections are 'Code' = A1 and 'Weeks Avg' = 4 The answer should be 29.66 as I want the formula to average the last 4 weeks figures for anything with code A1. <colgroup><col><col...
19. ### Group items by rating

I have categories in Col A and a corresponding rating in Col B. Col A is dynamic. Col B is fixed to:Avg,good,new, or null. Not all categories will have ratings (null). I am trying to group the categories by ratings - with specific formatting. See below. Desired result is in B10...
20. ### Total in group of 3

Hello Seniors, I need urgent help in following excel sheet. <tbody> Quantity Price 2 34.00 2 34.50 1 22.34 3 34.22 2 43.22 </tbody> I want to get the data in new table as <tbody> 3 "WEIGHTED AVG PRICE OF FIRST 3 QUANTITY: 3 "WEIGHTED AVG PRICE OF NEXT 3 QUANTITY. 3...