Hi, Sorry I have already asked this question but the answers were given in VBA, which I would rather avoid using if possible. Is there any way of sorting a...

I have a worksheet that contains the actual and projected hours for workers and I'm trying to figure out the function that would search through the entire row...

this is slowly driving me mad... I'm looking to find the total number of sessions occuring in the age group 0-5 years. I tried to set age as a criteria and...

I am trying to write a single "IF" statement that uses the following two...

My apologies in advance if too much information, just wanting to get anything possible needed out there to save back and forth for the experts! :) The...

Hi, I want to use the indirect() function. A1 of the current sheet says sheet 2 So I do the =INDIRECT("'" & $A$1 & "'! & B2") Which returns the contents of...

HI - Need help in plotting both % and absolute value in pie chart. I need this to be automated - does somebody have a solution?

Hi, I am looking for a formula/function/UDF that would split VasantRamPatil into Vasant Ram Patil ( ie split the string into three words using the capital...

Hello, I am currently using the syntax below to achieve a result of "TRUE" or FALSE on the designation spreadsheet. ActiveCell.Formula =...

I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL. While I can work around the OR, AND, and NOT, I need XOR.

I see my error $27 should have read $2, so I must rows 2:26

Dear Members, I was working in Excel in a file and light gone, when I started the same file next day this msg appear "this file is not in a...

Hi, I have the following function : =TODAY()-1 The problem is that if we're monday it gives me sunday's date whereas I only want weekdays so in this case...

I need to create a count if cola and colb meet a certain criteria. Example: A B 6-Jul dog 13-Jul dog 6-Jul ...

Hi , Could anyone help me. I had a excel file consist of sheet 1 and sheet 2. Sheet 1 consist of a table of different country freight cost. Sheet 2 is a...

Can someone please help me out. I would like to use a Name to contain 12 values, either 0s or 1s. If I want to compute YTD June 2009, this name will...

I have created a grading system using the LOOKUP...

I know no function can change font color. If I conditional form. can I select a col and say col A is an emp. name and then there are sales figures in b c d...

I would like to choose lets say 50 rows of data and have every 50 rows go on each tab? Is that possible? I have already entered the data into the rows and...

Does anyone know if it is possible to have say two fields where you can enter search criteria to gain the results in a separate list? Eg. Animal Colour ...