**[Solved] Add 2 additional criteria (customer name&location)** *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...

**[Solved] Formula in excel Header** *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....