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...

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, 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 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...

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...

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 ...

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=""),"...

Can I hide A B C D column names and 1 2 3 4 rows so I can only see my workspace

When using the AUTO filter, is there a forumular to SUM the filtered list ( i.e Displayed items) I have used the SUM fuction, this will add up the current...

"ibo" wrote in message ... Hi there I have a cell with letters and numbers. Like...

Can Excel calculate the root of a number and if so, how please? For example, what is the 11th root of 500? Thanks Murray

Once upon a time, I would get a little box when recording macros and I could click on it to tell it "absolute" or "relative" but now it doesn't show up and I...

Just some thoughts on your 2nd Q ... In Sheet2: Try Tool Options View tab Uncheck 'Zero values' OK -- hth Max -----------------------------------------

I know I can use "Advanced Filter" to copy Unique Records to another location of spread sheet. Question is ... can this be achieved with a formula? Something...

Anyone know of a function example on a worksheet that will return the quarter (1-4) and the month in the quarter (1-3)?

how can i have excel sort a work sheet based on a selection from a drop down list The selections in the list would be the same as the headers on the sheet

I am trying to build a template and one of the formulas that I have to use is HLookup. Is there a way to write this formula if I don't know what the last row...

Just started playing with ActiveX Command Buttons, with a view to adding macro code to them to do simple functions within Excel (Versions 2000 & XP). According...

Anyone know of a way to use a background color in a function such as an IF statement? I have a spreadsheet keeping track of items where I use yellow and...

Greetings, I hope my first posting has found the correct group to ask my question. I made the mistake of referencing the main worksheet to many other...