# Archive by category Excel Formulas

Microsoft Excel Formulas in Excel

## Calculate age formula to only show when data is added

Using google docs excel.   Hi, I was wondering if I can create a certain formula that only calculates age if the date of birth is inserted in nearby cell. …

## Counting Cells based on two sets of specific criteria

Hello,   I’m about to manage 3 different budgets in my place of work with no other method of tracking spend other than a spreadsheet. I would like …

## formula

Hi   I have a drop down menu in d5 on sheet 1, this menu has the years in 2014,2015 etc, in d15 i want to know which item ive sold the most, and i want it …

## duplication

T1 geo 1     T2 geo 1     T3 geo 1     T1 sam 2     T1 Nat 3     T2 Nat 3       …

## Require help with an excel formula

UE Release Date Observation Month UE Rate Observations Days Daily UE data S&P 500 Date S&P 500 Close 5/6/55 4/1/55 4.7 5/6/55   5/6/55 37.889999 …

## IFS and COUNTIFS

I am looking to know how many of these ID have used 1 or more benefits. The column C should say the total benefits used i.e. between 1-5, NOT the total count …

## change embedded date automatically

is there a way to automatically increment the date by 1 for each successive row with this as the original formula:   =SUM(‘M:FY 2018 DepositsDeposit …

## IF THEN SUBTRACT FORMULA

Hi I just have a question for the IF then Subtract command if possible. I have attached an example..    By:

## Communication between two independent spread sheets.

I have list1 in excel file list1.xlsx. the first two cells are used in many other excel spreadsheets (different .xlsx files). I wasn to alter the first two …

## Cell not returning result with if then

Hello, I have a cell on one worksheet that calculates an average and displays the result as a percentage. I have that cell linked to another worksheet with a …

## Student

My problem is very small and basic but don’t know how to solve it. I have 2 cells A1 = value of Kg, B1 = Value of Manns (Kg/40). I want both the cells to …

## Random Categorisation

I have 28 students in a list (numerical) who needs to sit for an examination in pairs.  There are 4 different examiners. At any one time, there will be 4 …

## totals for different ‘data validation’

Hi. Thanks for your help. I have a Project list. One column is the total of the project and the next is a drop down menu (the list is Designed, Tender, Quote, …

## IFS not working

IFS function is not working in most of my client office.I have made a planning sheet using that with hardwork in my laptop(xl 2016) but in others pc it is not …

## Creating a Line Queue

We have a pretty simple thing we are trying to do, which is to make a repair queue line. Column A = Name Column B = Estimate Time of Repair Column C = Status …

## how- Excel match record from different position of row

A B C D E F 1 Date Batch 1 1st Time batch 2 2nd Time Hour 2 28/1/19 AA103   BB100 6:09am 0.75hrs 3 28/1/19 AA104   BB101 6:15am 1.23hrs 4 …

## Extract Specific Text

Key Word   Store Name   Key Word Result Pharmacy   all in all grocery     Grocery   health pharmacy 2365     …

## How do I get a result to display “0” for no credit given?

Hello…My name is Robert, and I am an intermediate school math teacher. The following formula works for me, but I also need to a assign a value of zero …

## Average a column of numbers

How do I set up a column to average a row of numbers? Example: Number Average 120 120 125 123 200 148   I want to make the cells in the …

## Calculating Rental Period

Hi all,    I need to calculate the rental period for a widget between a start date and an end date. This rental period has to be broken down as …

## How to identify similar (not duplicate) text within same column

I have a column that has address line data in and I want to see how many unique addresses I have, the issue is the fields have been manually typed in so using …

## Mapping Excel data

Hi, I’d like to create a mapping sheet to generate a report based on internal data and the data from the client. The problem is, the products don’t …

## excel formula

what is the formula for a 10% discount up to \$4000, with a maximum discount of \$400.  Thanks. By:

## Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

## Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

## Dumping Formulas

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them.  Rather than transcribe each cell’s formula, is there a way …

## Engineer

Hi, I am looking for some support regarding the below issue.    A B C D Lead Time Example Wk 36 2019 Wk 50  2020 19 If (CD + Lead Time is less …

## Solution for following problem:

Suggest a formula for the below problem:   Consider Sheet 2 of the attached file: As you can see two cells i.e. H17 & I17 are highlighted. When two …

## Data Formula

Hi there, I am using excel and need some assistance. I have 2 columns of data. The first column is a list of countries and the second column is a list of …

## Formula for tiered billing

Hey there!  I’m new here and having trouble setting up a formula that will return a value based on a tiered billing.    Example: A1 …

## Need help with index/match (possibly) related formula

Hi ,   Thanks in advance for your time.   I am trying to figure out a formula to help me return data fields that match information in columns. …

## Is it possible to enter a number in one cell and have a different cell populate with a set value corresponding with the number?

How can I make it so that when I input a number into Worksheet 1, cell B1(#household members), B2 updates with the corresponding number …

## Formula question

I wanted to create a formula that can detect if the value’s decimal in the cell is over .60 and if true then to subtract 0.4.   So I have 38922.64 …

## 3 matching cells

Can anybody suggest a way to check whether any three consecutive cells in a column are equal? Anywhere in the column, but there must be three identical values …

## if formula

Hi hope you can help Is there a formula where I can get  column D to equal column C, if column A is equal or < 0.01 or > 0.01       A …

## Project Number Generator

Dear Spreadsheet warriors i’m trying to create a project number generator using excel by choosing from a selection as per the spreadsheet provided …

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

## Formul Question

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 …

## Number of overlapping times

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 …