## Formula Question

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named …

Microsoft Excel Formulas in Excel

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named …

I wrote the following formula and it works for 11 of the 12 months. I cannot get it to work for January. It is written the same way except for the last …

I have a set of rows with a start time and end time each. Each row represents the duration for usage of a resource. What I need to understand is …

I am using Excel 2013 I want a formula to tell put in F2 “A”, “B”, “C”, “D” based on a number in B2; the …

I utilized the ROUND function for a total in cell D30. I have another cell referencing D30 in a formula and want it to reference the rounded number in D30 …

I have a summary sheet where I’m trying to create a list of all of the people that meet a criteria. That formula is working, but it is giving me …

Hi there, I have a roster where i want to implement conditional formatting. If you see my roster below, you will see the green and red …

Is there a formula in Excel that lets me assign a number value to a text word? I’m making a weekly travel log for my mileage and want to assign the …

can anyone help me to resolve my query. I want to sum some numeric values by using excel formulae having some special charecters. for example …

can anyone help me to resolve my query. I want to sum some numeric values by using excel formulae having some special charecters. for example …

Hello , I made a raw or column and put some number on it for example ( 1,1.2,1.7,2,3,4,5,6). And then I put in another cell a number for example (1.3). I want …

Hello, I have a problem with condition formula , I inserted two numbers and a 10X10 table one of the two numbers is in a column and the other is in a raw . …

Hi I’m tearing my hair out with this one – can you help? I have two seperate workbooks – 1 contains a Match ID & a match Outcome …

I need to fill in blank cells with valued cells based on matching cells in two different worksheets. BESTRFS Table (Link) MASTERCap Table …

Hello, I need some assistance with a formula in calculating the best performer of a certain category. I work in real estate sales, and essentially I want to be …

Is there a way to match an already made formula to a cell matching a text in a defferent cell? By:

Hello, There is data from several separate data sets that I am combining in Access and then exporting into Excel. Each individual set of data was a …

Good day Excel experts, I was wondering if someone could help me to figure out the solution to my concern. I’m currently working on a Risk Register …

Pls advice how to create formula for below… Actual Values Required results by formula for (the text after the specified symbol …

I have a formula below which works as i want it to. When I drag the formula down i want the row to stay the same and the column to change, but the reverse …

Let’s say I have two columns in a table, one in which i ender the date, and the other returning the week number using the …

I have an Excel file with 3 sheets. One sheet contains all relative information, it is updated and copied over to the other sheets. The last …

I’m trying to auto fill out cells with values E6-E14 based on cell F1 which is a drop down list with 2 options Days or Afternoons. I …

Hi, I need your support to calculate the avg sales for specific product in specific day of week for passed 90 days I have table of sales for 457 days …

Hi, I need your support to calculate the avg sales for specific product in specific day of week for passed 90 days I have table of sales for 457 days …

On the right side I have a list of products and revenue and on the left there is the total is there a way that the left side is populated with a …

How can I change for this information: Column A Column B1 company1 Item12 company1 Item23 company1 Item34 …

Hello, Having a little trouble with a few different formulas. I have multiple sheets with the same data and data range. Column 1 = a skill name (with multiple …

Hello, I have a table containing temperature data (in Degrees Celcius). Data is organized as follows: A) Date and Time (mm/dd/yyyy hh:mm:ss) …

A1 = “Hello World!” in bold. In cell A2, there is a formaula =A1. I want A2 to match the formatting of A1 but don’t know how to …

Hi Yesterday I am using the excel. My boss gives me a challenging job about excel. I have a List i.e. Sr. No Code No. …

I keep getting this eror messsage, please help me. By:

Hi, I am trying to use a wildcard in a formula but it is producing a result of ‘false’ instead of the answer. If i remove the wildcard the formula …

Hello, I’m helping my dad manage his finances, and I’m trying to use Excel to help him do that. Here’s what I need: The image below shows a …

Is there a formula that I could use to look for matches (text) within one cell and place an option of values in one other cell? I am trying to attempt to match …

I need the formula in Col E to look at Columns A-D for any number/amount, and if there is, then copy what’s in the header of that particular column. …

I have a spreadsheet I use for testing appliances. Each row is for a different appliance. When I Pass an appliance, I would like the date a year from now to be …

Sno, inv no, paymentl mode, amount 1, 200, cc, 50.00 2, 201, cash, 120.00 3. 202, cash, 24.00 4. 203, cc, 1588.00 I want formula for to separate the …

Sno, inv no, paymentl mode, amount 1, 200, cc, 50.00 2, 201, cash, 120.00 3. 202, cash, 24.00 4. 203, cc, 1588.00 I want formula for to separate the …

hello there, I have several names in a culomb (sorry for bad english), and pics in the culombs next to it. for ex. in A:2 I have X and in B:2 X’s …

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.