## Excel formula Related Problems & Solutions

107 tags
Refine Tags

Results 1 - 30 of 107
Summary: The below formula allows me to pull in data based on a specific item number and column name. I need to add 2 more variable criteria that is located i...

[Solved] VBA to Insert LastRow into a Formula to count Unique Values
Summary: I am using VBA to insert a formula which will count the unique values in a previously selected column. The formula is inserted in a cell of my choosin...

Need Way To Pull Data From Different Column Based On Input
Summary: How do I...I need help in the formula. Really appreciate your help. I've attached an example (below) for what I'm looking for. I have unique IDs for...

[Solved] Excel formula to return number of days in a month?
Summary: I'd like to return the number of days in a month in column B, based on the date in column A. The problem is, column A does not have a specific date (0...

if two different cell colour same then condition should true
Summary: MY DOUBT PLS SOLVE if two different cell colour same then it condition should be true MY DOUBT PLS SOLVE if two different cell colour same then it con...

[Solved] How to put a comma between values from multi-formula string?
Summary: Hi, I'm using the following formula string: =IF(Recs!B2=TRUE, "Gas", "")&IF(Recs!C2=TRUE, "Electricity", "")&IF(Recs!D2=TRUE, "Water", "")&IF(Recs!E2...

[Solved] How to copy cell value from one workbook to another
Summary: Hello All! I'd really appreciate some help for a fellow Excel newbie! (pleeeeeease) I have Workbook1 with file names "SenFile" and durations "Slength"...

[Solved] Only count cells if the date is March?
Summary: I have a worksheet where I need a tally of who is doing what during a certain month. In this case, A is the date, B is the person, C-D-E are the types...

How to extract 1 date from a cell with multiple dates?
Summary: I have one cell with a date range and need to have each date be extracted to a different cell. message edited by sarahh770...

[Solved] If the date is 002/01/17, how can I make February show up?
Summary: the second part of this is if it's not February, I want it to say "Other". This is failing right now but it seems it should work.... =IF((TEXT(a2, "m...

[Solved] How can i edit characters within a string of characters?
Summary: I have two excel spreadsheet that I need to compare using vlookup, using case number to do so. The two sheets have case number stored differently, for...

[Solved] [EXCEL]Calculate account balance with intervals and interest
Summary: I'm trying to calculate an account balance after, say 10 years. I want the sheet to display balances with a given intervals, say an interval of two wh...

[Solved] Is there a way to simplify this excel formula?
Summary: I'm trying to process a couple of values in Excel, and came up with this formula, which works: =\$A3*B3+\$A4*B4+\$A5*B5+\$A6*B6+\$A7*B7+\$A8*B8+\$A9*B9+\$A10*...

Excel Formula to return cell value with matching text string
Summary: I am working on an excel formula that will return the value of the cell if the text string matches. the problem I am having is the blank cells where ...

[Solved] How to add \$ sign automatically in the formula in MS Excel
Summary: Hi, I have an excel worksheet containing column A to M with data from row 2 onwards. E.g. For row 2, value in M2=K2+L2 and row3, value in M3=\$M\$2 For...

[Solved] Change number in a formula buy referencing a different cell
Summary: Basically I have this formula: =(MIKE!\$B8) and I have a bunch of cells withs Numbers like so: Cell | Cell Number Change C1 | 10 C2 | ...

[Solved] how to progressively calculate averages down an excel sheet
Summary: Excel formula to calculate a progressive average down a sheet a 5+5=10 b 7+7=14 average = 24/2 = 12 c 8+8=16 average = 40/3 =13.33333 d 9+9=18 averag...

Yes or No Decision Column
Summary: I need an excel formula to perform the following: I have 4 columns of activity. If there are any balances at all, I need the cell in a separate colum...

[Solved] How to access the responses
Summary: i am almost completely P.C. numpty. I have asked a question related to Excel formula and I am informed i have solutions but HOW do I view/access the ...

[Solved] Calculate Thanksgiving Day for the next 15 years using excel
Summary: Use Excel formula to calculate Thanksgiving Day 15 years in the future using the formulas Date & Time function. Or a better solution within excel ...

[Solved] I want to find the formula for salary tax calculation.
Summary: The salary has the following schedule If salary is up to 5000 its exempted from tax. If salary is up to 12500, so 12500-5000=7500. now 7500 is taxable...

[Solved] Excel formula visa pasport validity
Summary: Hi there, Is any one can help me find the formula the scenario is this, i had all the list of the employee 1 column is the name of the person, 2 col...

Summary: I want to add excel formula and picture link in excel header. I have person information in my first excel shhet of workbook like name, Bar code image,...

[Solved] Using a table to return lane rate
Summary: I have a table where going from one point to another will be charged a rate based on the beginning and destination points. YUM MOR 1.45 YUM SW 1.38 YU...

[Solved] Concatanate results into a single cell
Summary: I hope I used the right terminology for this, I don't think I've ever done anything like this before! I have a workbook that gives keeps track of all ...

[Solved] Excel Formula: Help with IF using current date
Summary: I am using a spreadsheet to track tasks and would like to automatically change the status of the task to "Due" when current date is 15 days from the t...

[Solved] Keep a running total of a growing spreadsheet
Summary: So....a friend has a spreadsheet that will be growing daily with new data and on one row, he'll have the totals of all calls that he wants to sum auto...

[Solved] Excel Formula Help: IF Statement With Percentages
Summary: IF \$500*3% IS GREATER THAN \$20, \$20, IF \$500*3% IS LESS THAN \$20, 3% HOW DO I DO THE FORMULA TO ENTER THIS IN MY SPREADSHEET? A4 \$500 B4 ...

[Solved] Excel Formula for identifyng when a , condition is match
Summary: Hi..!! I have a large table with specific number for each entry, as follow: Name Min Max TypeA TypeB TypeC TypeD TypeE Joe 124 ...

[Solved] changing an excel file from 00:00:00 to 0.0 but keeping the
Summary: changing an excel file from 00:00:00 to 0.0 but keeping the same values what excel formula do i use to change 00:00:00 into identical 0.0 format e.g....

1234