## Organising data

Hi,  I have been tasked with organising data by my boss. I am not 100% sure on how I will achieve it using excel, if someone can point me to what function …

Hi, I have a column of over 200 rows. I would like to identify all the cell locations within that column that have the value of “0”. I know the …

## How to find percentage based on varies values

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

## how to make money a function of time on excel?

i want to have a number on excel that increases as a function of time (i.e. the number increases as time increase. I’m going to set this number to be …

## Enter a letter code in one cell and represented number in another cell

I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …

## Which is the best function

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index.  For the …

## If/AND with multiple cells

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, …

## SUMIFS function

Hello, I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely …

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

## Conditonal formatting – date in cell + 14 days

I am trying to find a way to highlight a cell once 14 days of the date in a cell has expired. For example:   Date in cell: 01/06/2017 I want this to …

## Multiple Criteria Range with Text Output

I need to find a formula that works as follows: If B2:B6 = Value X and C2:C6 = Value Y, Output is a text value from Range A2:A6. Since I need it to look in a …

## Is it possible to create a range of values evenly distributed in rows of column from single value

Hello,    Is it possible to create a range of values evenly distributed in rows of column from single value? For example: from the value of 35, I …

## Sum Column Until Condition Is Reached

Hello, I have 3 columns: Column A has categories: Column B has Amounts, and I would like Column C to auto sum every time there is a new category in A.  So …

## Excel Formula Assistance

I’m having trouble writing a formula for my excel file. I want the excel to read the Quantity for each model and instead of keeping them separate it …

## Row/Column Comparison Help

Hello all, I am trying to find a function that will tell me if a row in Column A contains ANY of the data in each cell in Column B and have the Yes/No be …

## Complicated nested IF AND OR statement….

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1.   …

## sum of cell criteria displacement

I am very new at excel, might as well start that off. I am taking it upon myself to make a better workplace by making a KPI (Key Performance Indicator). My …

## VLOOKUP & IF OR MATCH/INDEX

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

## Excel If and AND Functions

Hello,   Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

## COUNTIF range from cell value

Hi!   I would need you help in connection with the COUNTIF funcions range. I would like the row numbers to be imported from cells. Like COUNTIF(B(cell …

## Matching a formula value to a value in a table

Hello, Basically what I am trying to do is determine which batch number to use, by generating a value from a forumla, which will have a similar value …