## Using Defined Names

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’ve got 2 sheets with common column A. If the cells in column A of sheet 2 match that in sheet 1, I want to copy the data from sheet 2 columns B-J …

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days Data structure: Column F – …

Current formula i am using: …

A company works out the monthly pay for sales staff using the equation y = ___x 10 + 600, where y is the monthly wage (£) and x is the …

applied a formula in a cell and the result is 0.2. Used this value in another cell in Index & match formula but the formula is taking 0.2 as …

i have about 1000 emails Ids in word. i have copied from word to Doc. and all emails copied to 1 row example: abc@gmail.com abc@hotmail.com …

I need to know when various symbols can appear in Excel (Conditional Formatting) Formulas, and when a letter character followed by a number character can …

I need a formula to look if a value from a cell exist in a array of data and print “name 1” if it was found, if not search another array, if found …

Hi, Lets say that I can export from a system this set of data: Student Number Student Name Class Fruit Quantity 1234 Tom 2A Orange 0 …

what will be the formula for calculating if an employees work from 09:00 am to 07:00pm per day will be paid rs750/-, and after 07:00pm until 06:00 am will be …

Sheet 1 A B 1 Apple 10 2 Pear 8 3 Orange 3 Sheet 2 A B 1 Apple 7 2 Orange 3 3 Durain 1 Sheet 3 A B 1 Orange 4 2 Pear 6 3 Banana 5 Sheet 4 …

Hello, I’m a learning to trade the stock market. There is a rule called Pattern Day Trading (PDT). This rule says in a rolling 5 day period …

I’m trying to link most of the data from one workbook into another, and the methods I’ve been googling aren’t working. If I try to …

I am trying to see if Excel can do this: I have a budget spreadsheet with items I have budgeted for with 4 columns that represent each week of a month. In …

i would like to create a sheet for calculating overtime workers that work on field. calculating the hours for 2 different dates is fine but separating it …

In Excel I have a list of criteria over 4 columns. In another sheet I wish to lookup that all four aspects match, but where blank I would like to find …

=VLOOKUP(1,’Main Tracker’!A:F,6,FALSE) When I copy this formula down, I want the lookup_value, the “1”, to fill series so when I …

I am having trouble figuring out the IF formula for when a cell number that the user inputs increases by 1000 another cell increases by 1. For example if 8000m …

i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = …

I want to subtract two cells in excel but only if both cells have a value. More exactly in this case C1 is currently =SUM(A1-B1), where A1 is my selling price …

Please help. I’m seeking to VLOOKUP the values, as such. <!–table {mso-displayed-decimal-separator:”.”; …

I have days, date and time in 1 cell, for a month with 1minutes interval. Example: Sun, 1 jan 2018 12:00:00am Sun, 1 jan 2018 12:01:00am And continue …

Hi, Apologies i’m a novice with this. However, i need to add Networkdays into the following IF Formulas …

Hi, I have 3 columns, Amount A, Amount B and Total. A is a formula pulling a dollar amount from another cell B is an amount entered manually Total is the total …

In one excel worksheet called FY18 Report i need to populate the Salary Step based on the total salary. – salary and fringe benefits. In a …

Hi, I have the below formula in an excel file: =-$C$109*SUM(O105)*(O6=$I$5) I don’t understand what the second equal sign is suppose to …

Hi, I got this table right here in Sheet1: A B …

I am using Excel in Office 365 and cannot figure out how to get a total of how many unique numbers are in B20:B200 on four sheets (FY19Q1, FY19Q2, FY19Q3, …

Hi, I have a set of field to compare in 2 different spreadsheet out of which any match will then check and return for a specific value in another …

=IF((U182+V182+W182*0=0),(T182),(U182+V182+W182)) What this formula mean By: Vikramaditya

I need help with some formulas on my excel dashboard but i am stuck how can i show you that data so that you help me. By: Anthony

Hi, I have a list of countries in A1 with their respective points in A2. Note that some of the point values in A2 repeat. Ex: Eastern United …

Hi! I trying to construct a vlookup that gets values from another worksheet in the same workbook. The problem is I will have a different worksheet for every …

Morning, I have multiple sheets (10) with different col data. The data consists of 1. unique page number column 2 to 4 consists of various …

I’m trying to come up with a formula to handle multiple situations. Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5). current formula will …

Hi all! I’ve been grappling with this question for a couple of weeks and am edging closer but I’d love some help. Basically what …

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.