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

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 …

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 …

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 …

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 …

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

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? Here’s an example on what I’m trying to do… In one worksheet, I have lists of data …

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 …

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 …

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 …

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 …

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 …

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 …

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

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 …

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

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

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 …

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 …