## Pull project title if it falls between two dates

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

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 …

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

Hello, 2 I have a sheet that contains leaves applied by employees.This sheet has leaves applied for atleast last 4 months. …

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is …

Hi, I would like to compare the ‘lookup value’ against the list of 5 values and find out the ‘first value’ that is equal to or greater …

I have stumbled across a small issue which I can’t seem to overcome. In column A, I have a list of amounts for example Column A 234.34 2286.59 100.00 1286.48 …

Hello, I am attempting to build a formula where column M would fill based on the imput in column L and change based on a value entered in Column K. I …

Hello, I am looking to create a report that pulls data from specific section on another report. The report i want to make will have a new days worth of …

I’m tryint to fiure out a formula for a spreadsheet. I need the formula to add the number purchased in e2 to be multiplied to the $ value in …

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, …

How do I create a formula for the following: IF cell A is >=5,000,000 give me 5,000,000, if no, give me 3% Trying to figure out the lesser of 5,000,000 or …

Good afternoon, I have a question about a project that I am reviewing. I would like to know how to use a simple “3-D” formula for …

Hello, I’m basically wanting to drag data from a worksheet containing thousands of cells worth of data into a template I have created. I …

Not sure what type of formula I need but I will try my best to describe the situation. On a risk matrix there are 6 levels of severity (numbered 1-6) and 6 …

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

In cell G22, type in Rent or Buy. (either word) In cell B10, create a formula that will display the total facility expenses depending on whether the club …

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 …

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 list of work that has a date received column and a two week deadline date column next to each other. I then have a date completed column which …

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.