Conditional format cells only that contain a sequence of blanks
Hi all, I need some help trying to nut out a conditional formating formula. I need to only highlight cells that contain 3 or more blanks in sequence in a row …
Formula changing when sorted
Hi all, I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …
If a name exists in a list and has a specific value next to it
Hi all, I need help with a formula. I am trying to write a formula which looks for whether a name (C1) exists in a list of names (A:A) AND has a …
Conditional Formatting Throughout
In conditional formatting, I have =$A$5=”x” (Formats the target cells to Fill Green) Applies to =$B$5:$T$5 This causes cells B5 through T5 to …
Complex Formula
I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …
Sum If Array Formula Question
I’m trying to use an array formula with sumif and know the correct format is along the lines of …
Variable Calculations.
Hi, I’m working on a hydraulic analysis calculation sheet and I’ve hit a wall. I’ve calculated the average and critial velocity but theres a …
lookup formula help
I have one employees exel spreadsheet with location data. I have a second empployee excel spreasheet that lists if they are management level or …
Address Function
Hi, I have a column of over 200 rows. I would like to identify all the cell locations within that column that have the value of “0”. I know the …
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 …
VBA superscripts
Hello, I have a large table where my numbers are in the scientific notation x10^ format (I used a formula to convert the Excel E scientific notation …
Countif formula across multiple sheets
I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …
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 …
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 Required
Current formula i am using: …
Vlookup between multiple criteria and then yes or no match
I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …
How does Increase decimal and Decrease decimal work in Excel
How the increase decimal operation is performed in Excel and how they done it? Case 1 : I enter a number in a cell whose number of digit is less …
Excel Formula Syntax
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 …
Wildcard in formula producing ‘False’
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 …
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 …
Automatically Updated Excel Formula based on last cell updated
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 …
Create formula between cells
I have a list of postcodes in one column and would like to create a formula which will identify the town that the postcode belongs to. Is this possible? …
Sir please Solve this assignment if you can an tell me which formula shall i use to get lifeline used colom value
KAUN BANEGA LAKHPATI NAME LIFE LINES USED ANSWER AWARD 50/50 TELEPHONE AUDIENCE RAMESH T F T DINESH F F F UMESH …
Formula help
I am looking for how I would find the difference between two sets of numbers with one common factor. Any help is greatly appreciated!! By: LaTrisha
excel formula
if cell A1 contain some name cell B1 contain values of formula and if b1 becames 0 than it should automatically became red till this i have use command …
T.A
Hey guys! I would like to know how could I assign values to text, or better said, for my “products”. I’m fashioning a drink calculator …
Excel VBA add formulas to cell
Hi, I’m looking for a solution to a problem. I have an excel sheet that upon using a macro it adds a whole new row with a ” # ” in a …
How to sum cells while ignoring ones with text in the same sum?
Hi there! Currently working on something that adds hours up over 4 weeks to sum the total hours worked in a month. However, I cannot allow the spreadsheet to …
How to devide the value, based on drop down choices
Hello, I am looking to find a way to divide certain value based on the drop down choices in excel. What I am trying to do is to make a way to …
Division Consultant
In our computer system, we have different codes for everyday tasks. Problem is the codes are different for each division we have. For Example: …
Enter a letter code in one cell and represented number in another cell
I will do my best to explain what I’m looking for – I hope it makes sense! I have included a bit of my worksheet so you can hopefully understand …
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 …
Formula Substitute Help
Hi All Im wondering if somebody can help I am using the below formula to calculate hours it all works apart from if a cell is empty for …
Calculating no. of calls per person per month
Hi All, I’d appreciate your help on the below: Outline: – 3 people (Amy, Harry, Sophie) …
DATE
How do I extract the date if the given data are: 1) Week ending date 2) Days of the week (for which the exact date falls into) See example below: …
Auto-change text to different text
So we are exporting data from FileMaker Pro. We have a column labeled as location and it will say something along the lines of: Tank II Rack 3 Slot 23. (There …
formula help
Please enter the excel formula if you need the cell to show “0” if 3 plus 4 equals and “1” 3 plus 4 is either greater than or less than …
Sum of n until m
Hello I want to formulate this [(n=0)∑(n=Ϻ-1) 1/n! (λ/μ)^n ] I’ve been browsing the net for half day and can’t find it. It …
HOW TO GET DESIRED OUTCOME USING EXCEL?
Hello, Don’t really know how to name this problem properly. Just made it more in a general sense rather than a specific one. Here’s the problem, …
Journal Entry Automation
I am wanting to create an automated General Ledger and Journal Entries. The way I am wanting to set this is up is having a list set up that a user can choose …