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

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.