## Formula for If cell A2 is “text”, B2 = copy paste formula of B1

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 …

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 …

Hi everyone, I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …

Hello, I am working in a retail store and need to audit my inventory. I need to scan barcode tag which in return gives item code size and color of …

Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …

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

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …

Hi everyone, I’m trying to create a formula for my overtime, as I get a different pay rate at different days and times. Mon – Fri: 17:00 – …

Dear all Kindly solve one issue. My requirement is that when user enter some value in a10 cell, & z10 = a10, now if user assigns some value in a10 …

Hey guys, I hope someone can help me with this. I’m trying to create a timetable to monitor my hours and what shift brackets they fall into but …

Latency: 0 1 0 1 1 0 0 277 290 267 212 214 0 290 …

I’m trying to create a formula for time but having no success. I’m trying to create a sheet where meal breaks are automaticvally deducted …

I am currently having to track the time all my support members are spending on the phone. We are having them submit a form which then in return is …

I have a file of 1000+ jpgs and a list in excel of 300 file names – how do i search and find the 300 images in the bigger file? do i do this via dir …

I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …

Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

Is there a simpler way to achieve =((Attendance!$C$3*Attendance!C5))+ …

Comparing 2 collumns from 2 different groups having a empty collumn between the groups , each group containing 4 collumns, inserting the cell in every collumn …

Hi. I want to see the results in a pop up when click on a cell. For a example when clicking on a product to calculate the discounts of a certain customer and …

Hey, I am trying to make columns that have one unique option. First check this image: https://i.imgur.com/uxwX57G.png Like you can see there …

I’m trying to create a burndown and burnup chart for my team. However, I’m a bit confused as to what formulas I should be using with the data I …

Hello, I am using Excel 2007 and having difficulty creating a graph that calculates the value “y” for several “x” values. Here is the …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

Hello, I have a table of values with 7 columns and 3116 row. The table is full of numbers and I would like to find out what are the 10 most recurring numbers …

I have a list of products in my excel sheet1 (A:A contains the product code, B:B contains the color of item) On sheet2, I would like to have a summary table …

Hi, I have used an excel template for my pipeline which has alternate 2x colours rows and that makes it easier to read between rows. I have added filters to …

I am using Excel 2016 on Windows. I wish to extend the following formula indefinitely down through the rows of a column: =SUM(G7*G8 + H7*H8 + …

I have a data form with a submit button that submits data into log in excel. If a certain number of tasks haven’t been completed and the time (now) …

Hi guys. So I’m going to try to explain this as well as I can, but might fail. I have three columns, let’s day A, B, and C. So I tried to kind of …

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 …

I’m having the hardest time getting excel 2013 to get all the things I need rolled into one. I need to enter times in military time and know the …

Hello, I am a beginner in excel. I need some help on data validation formula. Due to character limitation, I am not able to add two more IF clause …

Hi all, I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

Hello! I have in COL 1 many rows containing simple expressions (addition, substraction, multiplication and division with brackets) and I need to show the …

Making a usage spreadsheet for Housekeeping. Multiple units with different bedding and towel totals. I have each column separated by what the unit has …

Hello, I need help with a formula. There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …

Hello, I am looking to set up a spreadsheet that will allow me to calculate the number of parts to be order for various models of motorcycles. Some of the …

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.