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

## Sorting of table using formulae

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 …

## Multiple tables – Sorting

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 …

## Display most recent input

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 …

## HOW TO GET DESIRED OUTCOME USING EXCEL?

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

## Creating an excel formulae with multiple options

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 to extract value from Pivot Table

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 to extract value from Pivot Table

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 …

## Points Table

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 …

## Help with pulling information from a table

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?

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 …

## Entire tables inside a filter, possible?

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 …

## Pivot Table query

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 …

## Deleting excess rows in a table when copying over information

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 …

## Table Slicer sorting help! Excel 2016

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 …

## COUNTIF Forumla?

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 …