**[Solved] Excel to Access-disappearing numbers saved as text** *Summary*: To clarify, we have account numbers of 15 characters and when they come to us from other reports in Excel, they're sometimes saved as text. When we'v...

**[Solved] Macro to insert a formula in a column** *Summary*: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

**[Solved] How do I: if X2 = A2, then change X2 to red?** *Summary*: How do I make a cell change color if its value equals that of another cell? Reason: If my "results" # matches my "uploaded" number, I want the "result...

**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] Excel formula parse error** *Summary*: Hello, Can someone please tell me why this is giving me a 'formula parse error'? =IF(ISBLANK(I6),ʺblankʺ,((((I6-I5)*2.3))+(((J6-J5)*0.26)))) Thanks....

**Excel Formula needs to add Index to return cell information** *Summary*: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

**Alternative suggestions to this select case code?** *Summary*: Hello all I have a macro that copies all the sheets from two workbooks into a new workbook. That is all good and working. Each sheet contains x-number...

**What formula to use to check current or previous owner?** *Summary*: Hello all I have some data that looks like the following: A B C D E F G
1 ID Name Date bought Date sold Numerator denominator Owner status
2 111 ...

**[Solved] How to add workday when start date is weekend?** *Summary*: When my start date falls on a weekend, how can I make the following Monday my Day 0? Say start date is Feb 7 (Sat), and I need to add three workdays (...

**excel formulas(sum,average etc) not working, always giving 0** *Summary*: if there is a space after your number, it will be considered text and not number and calculations are performed only on numbers, whether that be sum f...

**[Solved] how to type this formula into excell** *Summary*: 38x30=?x17.5%= I don't know how to type this into a cell to get the correct answer. please help. cheers, tina ...

**[Solved] Formula to give different number to different texts?** *Summary*: Hello all If I have a column with texts in them (some of them quite large and beyond 255 charaters) and some of those texts are identical. Is there an...

**[Solved] I need to say if cell A2=yes,Then,cell A3=EDATE(A1,3)** *Summary*: so to be clear, I have a cell that says yes, or is blank. If it says yes, I need to calculate a date 3 months ahead ...

**How to create an if statement for a validation list?** *Summary*: I have a spreadsheet that tracks students. On sheet 1 is the complete of students. On sheet 2 is a report. I need a formula for a dropdown that will l...

**[Solved] why am i getting one answer on a calc and a diff on excel** *Summary*: ok my problem is when I do my equation with my data on a calculator example 1666.67*90%=1500.003 but if i do the formula =IF(AND($B$59<100%...

**[Solved] How to write a formula with IF and vlookup** *Summary*: How to write a formula with IFERROR and vlookup, when the data to be looked up are in a separate sheet within the same file? Thanks for teaching me. ...

**[Solved] IF formula using data from several cells** *Summary*: I cannot figure out the formula for: If cells B2:34 contains a match of data in cell B37, then I need cell K37 to track costs specified in cells J2:J...

**[Solved] help with excel formuals** *Summary*: How get a cell to work out a cell to calculate 2 formula Ie If G3<= 50 and D3<= 10 give an answer of 5 if true and 10 if false Thanks ...

**[Solved] Convert Number Of Month To Name Of Month** *Summary*: hi guys =TEXT(DATE(2000,A1,1),"mmm") that formula is correct but most of the time year is different when we analyses 2 years data, hence we not change...

**[Solved] How to change a lot of cells to absolute (macro fails?)** *Summary*: Hello all Ive been using this macro a lot of times, but I am running into some strange problems with it. Sub Absolute()
Dim Cell As Range
For Each C...

**[Solved] Excel - Need To Calculate Days And Hours Between Two Dates** *Summary*: CORRECTION TO ORIGINAL CLOSED THREAD Excel - Need To Calculate Days And Hours Between Two Dates ORIGINAL THREAD http://www.computing.net/answers/of......

**[Solved] Add Formula after the Last used Cell in a Row** *Summary*: Hi, I am looking to add various formulas in the last column of a row. The code is below what I am Iooking to do is replace column "F" with the last c...

**[Solved] Formula is returning the text format instead of date format** *Summary*: I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected. Here i...

**A Small Glich in the VBA code to Hide the formula cells.** *Summary*: Hi! I have used the VBA code from the site you mentioned http://www.ozgrid.com/VBA/stop-form... It works fine.. But as soon as i select a range of cel...

**help with excle formula** *Summary*: 3 columns column 1 = a £0.00 Column 2 = enter a letter - excel recognises the letter and transfers to column 3 Column 3 = £0.00 if letter in column...

**[Solved] How do i get Max value from the Sum of 2 cells as below** *Summary*: A B 1 2 3 4 5 6 The values above represent 1 & 2 in cells A1:B1, 3 & 4 in cells A2:B2, 5 & 6 in cells A3:B3. I"m looking for the Maximum ...

**Caluculating a value based on a range** *Summary*: How do I enter a formula that provides the following answer; If a cell value is between two amounts I want to show a different answer. EG: totals sale...

**[Solved] Why does the following function return #VALUE!** *Summary*: Cells (A,B),(C,D),(E,F) & (G,H) ARE MERGED TO FORM 4 CELLS. This Function is designed to give me the result of the last cell in the row that contains ...

**[Solved] Using NETWORKDAYS() with MOD() for difference between 2 days** *Summary*: The entries are as follows 13.06.2014 23:59:59 30.04.2014 16:36:29 08.05.2014 15:11:49 12.05.2014 22:30:05 etc., etc., Now after using the formula...

**[Solved] I desire help with a formula** *Summary*: I have resolved how to add Numbers in a given column for 2 or more linked work sheets. EXAMPLE; =SUM(SHEET1!F:F,SHEET2!F:F) I can also add NAMES or...