Have a column of data containing from the left any number of dots followed by a number. The columns can contain anywhere from none, to up to 25 dots,...

Ok filtering didn't work. I have multiple spreadsheets and multiple columns (see column labels below) I am trying to pull data based on Grade Level for child...

Hi all I have a list of customers with random text length names, and then 4 spaces after them, and then some more text.They also all start with 4...

I have a column in which I have given for sub total the sum formula that =sum(F6..F8), like this there are several of them in that column. However at the...

I am trying to find the lowest, duplicated value (min of 3 times) in a range of numerical data. Is there a formula or combination of formulas that will do...

Hello Atlantic City, New Jersey will once again host the Microsoft Excel / Access User Conference (Trump Taj Mahal) - On September 24-26, 2008. This year...

hi Im working on a workbook for invoicing A10= PROJECT NAME B10= TOTAL AMOUNT C10=INVOICE # FOR MONTH 01/01/2008 D10= AMOUNT FOR MONTH 01/01/2008 E10=INVOICE...

sorry my CHOOSE will work the other way round ;-(

Help for LINEST states that The array known_x's can include one or more sets of variables. If only one variable is used, known_y's and known_x's can be...

oooops sorry this case is different

How I can calculate the alternate cell in a diff column such as Pakg qty Pakg qty Pakg qty total Pakg Total qty 1 200 1 200 1 200 ? ?

how i do apply a formula at alternate cell , while i have 30 number of column such as Pakg. qty. pakg. qty total Pack. total. qty 2 200 ...

(Using Excel2003/WinXP) I am trying to count the number of times 2 values are in a cell. The string may contain the values ",abcd, abcf," or ",abcf, abcd,"...

Hi, When I plot a calibration graph (concentration vs response) and add a trend line, Excel will show the gradient and intercept of the line. I normally...

I'm not sure if this is possible, but do you have any thoughts on how to produce a number pattern in Excel? I have numbers in a table like this: 1 2 ...

I have the data as under A B S 2 S 3 F 4 F 0 M 5 M 6 I want to count...

hi I use following mocro: Sheets("Sheet1").Select Selection.AutoFilter Field:=6, _ Criteria1:="=" & Range("Sheet2!A1").Value I need to...

I need to count the number of unique entries (names) in a column of data, one count for each different name. List changes throghout the day and so I can't...

I have a cell that is counting text fields. Each month I want to capture the count for that month and display it on a seperate worksheet. Thanks for your help

Does anyone know how to make an IF function take no action if the logic test is false?. I want to change the value in a cell if the logic test is true, but...