Formula to Extract Text from Cell
I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …
Help with formula, please!
Hi! I’m hoping someone can help me with this formula. I am looking for a formula to use that take the words that are in separate cells …
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 …