## Calculating weighted average in a data table that also ignores any blanks in a given column

Hi – thank you for any thoughts on this – grateful for your time. Here’s a formula that calcs a weighted average within a data table. …

Hi – thank you for any thoughts on this – grateful for your time. Here’s a formula that calcs a weighted average within a data table. …

I have a table. In the 1st column there are voltage levels i.e. 400,300,200,100 V etc. In the 2nd column, the short description of items related to voltages in …

Hi, My problem is that I have two tables and one table that is combining (adding up) the two tables together and I want to be able to sort all 3 tables …

Let’s say I had a range of numerical data in column B of a table. In column B’s total row id like to have displayed only the most recent entry. How …

Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

How do I extract value from Pivot Table to a Table in another sheet from the same workbook. For this instance extracting the Avg Price in the Pivor to Product …

How do I extract value from Pivot Table to a Table in another sheet from the same workbook. For this instance extracting the Avg Price in the Pivor to Product …

Hi, I am trying to make a points table where the cells will automaticaly work out who is at the top of the table with the most wins. I need to figure out how …

Hello, so I am trying to create a volunteer hour tracker for my organization where people will go in add their name and other information about their …

I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, …

How to use worksheet data shown in other worksheet table? Here’s an example on what I’m trying to do… In one worksheet, I have lists of data …

Hi all, I’ve recently been tasked with a bit of a difficult situation at work. We have a pricing tool that is essentially a bunch of excel pages …

Hi, I have two columns in excel. Column 1 = Month-Year, Column 2 = Total sales of the Month. I want to creat a pivot chart which shows yearly sales. For …

At my job I work with large amounts of data. I have an Excel spreadsheets with tables that contain all of my necessary formulas and fuctions, but I frequently …

Excel 2016 – windows 10 I have a large table with hundreds of rows… I want to be able to filter my “description” column with a slicer …

I am trying to create a table to track how many times a referee has refereed a certain player. In my table i have as follows: Basically i want to count the …