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

## Calculation of combinations

Hi,   I have an issue. Lets say I have 4 numbers (10, 50, 100, 250) and I want excel to give me the best combination of those numbers that will get me as …

## Some assistance needed

Aoa, i am Uzma Razzaq from Islamabad Pakistan. i need a formula for excel sheet. As i have record of fee of school students. Condition: If more than one child …

## Excel VBA master sheet copy-paste error 1004

Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. …

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

## Looking up text in string

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 …

## Vacation Tracker earned days off based on years employed

I am needing help with the following I have spreadsheet that states employees hire date and formula to calculate that date to current date which auto generates …

## Manipulate data in excel to order results per a certain column

Hi,   I want to make the information in some columns (but not all) displaying in rows, please see below an example.   This is what I have:   …

## Formula for If cell A2 is “text”, B2 = copy paste formula of B1

Hi, As written in the title,  I want to copy past (similar to dragging down the formula) from a cell above if another specific cell contains a specific …

## Work days with every working day displayed in a row

Hi everyone,  I was wondering if someone could push me in the right direction regarding how to build a formula. I am looking for something to display …

## How to keep same column but different row in formula when pasting in multiple cells?

I want to compare row and column values. My formula is =IF(A2=B1,1,0) . Next below cell formula would be =IF(A3=B1,1,0) and so on. Meaning compare the value of …

## Scanning sheet in excel

Hello,    I am working in a retail store and need to audit my inventory. I need to scan barcode tag which in return gives item code size and color of …

## Top 10 sales by customer

Good afternoon. I have a complex formula that I need to build and don’t know where to start with it. i have built an automated front sheet that looks …

## Using the text of a cell range (array?) in VLOOKUP or MATCH formula

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

## Checkbox Question!

Hi guys, there’s one thing that I wanted to do but couldn’t find any similar case after hours of googling. Here’s the case I have a list of …

## Auto Populate Some Info

Hi, I’m trying to find out if I can input a file name such as “file name_123456_2018_NI” into one cell and have just what is before the first …