Hi all, I'm hoping someone can help me. I have written the following formula and it works exactly how I want it to. =IF(OR(N7=""),"...

A B C Jan-01 340 1 Jan-15 210 1 May-04 130 5 May-25 222 5 Aug-17 434 8 Aug-19 110 ...

I'm using Excel 2000. Scenario: If I put in cell A1 56.7 seconds (represented by 00:56.7), and for the cells in the same Column A (starting from A2), I want...

I posted an issue last week and got a great result. I need to take this a step further, though. I'm copying the string of Text outlining my issue and the...

Hi, How can I conditionally color cell's in excel based on whether they contain a formula or not. When searching for the answer, i haven't even been able to...

I'm trying to set up a formula that will subtract one date and time from another, but must be less than another column to provide true or false. **I only want...

Hi there I want to use countif to count the numbers in a row that are 'greater than' but 'less than' something like =COUNTIF(P3:U3,"5", "25") but can't get...

Hi there, About a year ago I found in the Internet a tutorial on how to create a formula that would detect some of cell formats. It used some long and complex...

I am working w/ the code below to take selected worksheets and save them as individual workbooks. I now would like to modify the code to always select...

The LEN function counts characters, however, I am not aware of a function to count words. Looks like you get to VB. -Jesse "Jon Capuchino"...

I am trying to find a the smallest number that is greater than 0. I used the following: =MIN(IF(B5:W50, B5:W5)) But I am getting an error #VALUE! What am...

Hi I have been here before and the help was great. OK What I need to do is have a formula which transfers scores. I have a main league with 42 people on it...

For some reason, my arrow keys are now scrolling the entire sheet instead of moving from cell to cell. How do I reset them so they move cell to...

I am trying to import a text file in which the first column is a 10-digit number. This number has a leading zero. When it is imported into Excel the leading...

Has anyone written a formula to calculate the check digit for a 13 character EAN code from the leading 12 characters? (The 13th is the chaeck digit.)

I posted this question earlier but I did a poor job of explaining my situation. Thank you Aladin for your answer but I did not really understand it. Please...

Hello, first let me insert the basic framework of my excel sheet: A: B: C: D: E: F: G: H: I: J: 1: 101 105 ...

I have to come up with a count of numbers which fall into certain ranges: 0 - 1.0, 1.1-4.0, 4.0. Short of sorting by that field and manually counting, how...

Help!!! in the past, Excel has always automatically updated formulas when the values in their cell references changed. as i am working on excel tonight, i...

Dear experts, I want to create a form template with a form number. This number should be unique and never reuse again. For example, the starting number is...