## 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 …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.