# Archive by category Formula

## Vlookup

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 …

## Excel Help – Data Format

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 …

## Excel

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 …

## Autofill up lookup value

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 …

## Linking Cells from 2 workbooks

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 …

## Multiple dropdownlist linked to Cell

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 …

## overtime sheet for field workers

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 …

## Wildcard match, lookup with text and numbers

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 lookup_value number not changing

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

## Continuous/endless IF pattern

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 …

## Finding the formula

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

## Subtractic cells only with values

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 …

## Remove days from date and time

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 …

## Nesting Networkdays into IFs – VERY URGENT FOR WORK

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

## Formula Total

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 …

## index and match

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 …

## Excel formula

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 …

## Pull project title if it falls between two dates

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

## Unique values in a range on multiple sheets

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

## Excel Compare and Return Result

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 …

## Excel Inventory management

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

## Excel formula

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

## Creating X number of groups from a list that sum to X number

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 …

## Using a hyperlink as table in vlookup

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 …

## Excel Formula Help

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 …

## Which function should I use

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 …

## Excel Lookup

Im using Excel and need to be able to lookup a column if blank need it to look up a different column and count a pacific word within that row? Any help please …

## Ms excel 2016

If Column “A12” has certain text, then count “B12:B20” By:

## Moving formula changing cell position

Hi, I’m dealing with the following problem. I want, given an array of values to iteratively find the minimum from the position next to the previous …

## Multiple ‘IF’s in one Cell’s Formula

Hello. I am hoping someone can help!   I want to add nuermous versions of this formula to the same cell as a multi function, but can’t seem to find …

## Coping 1st row data to pasting same to 2nd row of the same column rows

Hi,  I do work on campaing, i collect number of emails ids (say around 200) from website and ther will be 2 people in the same company Directors, one …

## HELP!

COLUMN A is a list of names, ROW 1 is a list of dates, intersecting cells have a value such as X: Can I write a formula to search by row 1 for the coordinating …

## Inventory Formula

I run a bar. When I tally my inventory I have 5 columns : Opening Stock, Received Liquor, Sale, Cocktail Concumption, Closing. While received liquor is always …

## Counting number of names in a single cell

I am new to excel formulas, so need help with how to count up the number of names in each cell in my table, if anyone cane help? ie: 7 names in cell 1, 2 names …

## Which is the best function

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index.  For the …

## Formula / Equation help

Hello,   I am trying to replicate the formula below in excel, but can’t quite get it right. The aim is to use the formula to help drive data …