## How to get rid of #DIV/0! in an array

Hi! I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any …

Microsoft Excel Formulas in Excel

Hi! I hope someone can help me with this question. I am trying to calculate the standard deviation of a row of cells, however i would like to not include any …

I need a formulae to work whereby if a time is over 8 hours then the result of cells E10 minus E8 needs to be applied. Tried various way of acheiving this but …

I want to rearrange the column in excel with numbers in terminal dogit order. for an example i want it in 00001 00011 00011 00111 01111 00021 now its in …

Hello, I’m trying to figure out a way to make my forecasting easier. I get a pdf that I convert into an excel file. The dates available for what …

Good day. I have attempted many formulas to rid the cells of the ‘false’ statement that appears. Please share what can I insert into this formula …

Hi, I’m running into the following problem, I’d like to split my text from one singel cell (split by comma’s) into multiple columns. I want …

I have a skills matrix for employees that I wish to add a formula to in order to warn us when certain certificates for skills expire. I currently have the …

Hello, I hoped you could help me with an issue I still haven’t gotten my head around. I am working with a table that shows the uptime in …

I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …

Hello. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with …

I am trying to figure out projected days left minus tasks per day Days – tasks (1 day equals 10 tasks) = days left Help please By:

Hi, I am bit stuck on a time funciton. I have two times a1= start time and b1 = finish time. C1 tells me the differnece in time as I have …

Hi All, I need to be able to search data were we have 1 client with multiple expiry dates of policies. We need to pull the data of the oldest …

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ …

I have a lot of formulas, which means I want to know what they said and for what it is done. like :- =LOOKUP(Answerkey[[#This …

QNTY PIECE MARK SIZE DESCRIPTION LENGTH LENGTH TOTAL LENGTH (FT) FT IN FT 1 1C1 W8X21 COLUMN 4 4.375 4.36 4.36 1 1C2 W8X21 COLUMN 4 4.375 4.36 4.36 5 …

Hi, I want to make the information in some columns (but not all) displaying in rows, please see below an example. This is what I have: …

Hello, Well I’m stuck. I’m trying to write a formula using the IF and AND functions that ought to be simple, but just can’t make it work. …

Hi, As written in the title, I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …

I need to find out what formula to use , In cell F14, enter a formula that will calculate the total number of employees scheduled to work Sunday …

Good day I am looking for a formula (I suspect that it would be a logic formula if, then) to help with the following. I have three columns Column A with …

Question regarding find the last friday of every month What I did: Downloaded an excel file that showed the daily closing numbers of the S&P 500 from 1997 …

I need automated formula to create a chain of local brands X,Y,Z for the same global brand A Global brand Local brand Global Brand …

I’m using excel 2013 on my pc. I am creating a survey. The answer options are A, B, C, D, E. I would like to have the answers on one sheet. Those answers …

hi please i need a help, i’m trying to create my worksheet in excel, but i had a small problem which can help more if i know how to solve it. in …

I want to do a couple of things in Excel. First, I want to count the number of times we saw upgrades for customers. So I want to count the number …

I need help writing a formula for this scenario: If H90=Yes AND D8 =<500 return 8 If H90=Yes AND D8 =>501 and D8 =<1000 return 12 If H90=Yes AND D8 …

My question is regarding supplier scorecards in Excel. Example) There are three vendors, three factors (ie. Quality, Performance, Cost) and their respective …

I’m making a list of tasks for setting up an event as a reference for myself and staff. There are three columns, 1 name of person doing the task, 2 the …

Hello I have a worksheet and when I imput a formula like =(a3-b3). This obviously works, the problem comes when I try to update the information weekly so …

when I use the subtotal function in excel and then collapse the subtotals to only show the subtotals and copy the subtotal into a cell my formula does not …

I am trying to search for a sku number of a specific brand and then color of product. I have 4 brands and up to 12 colors in each brand and set up in a table …

Hi, I want to place amount mentioned in particular column into next respective columns based on months provided. Eg given below Amount End Date …

In cells A1:C1 I have the numbers 8, 3, and 5. In cell D1 I would like to automatically sum the number of combinations like so: …

Hello, I am looking for a way to extract a number from a string or text, symbols and numbers. For example I have the following in A1 …

So say I have a data of numbers, in A1 I have the value 6, in B1 3, in C1 10, in D1 12, and in E1 9. What I want is to highlight the cells that have increased …

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

Hi, Sorry if my terminology is a bit off but I’m self taught on Excel. My problem is that I need to be able to refer to a range/array in a …

Hi I am creating a spreadsheet to collect data. I have figured out most problems. But the one I am stuck on is this. I am using a formula …

Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …

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.