I want to ungroup worksheets once grouped. Please let me know step by step
regards
sreenivasan k.r.

=IF('5-19 Epson Ink'!H5-H106<>0, '5-19 Epson Ink'!A5,"")
i have this formula in a cell on spreadsheet Variances.  instead of having
the "" at the end, can i put somethin that will delete this row in this
spreadsheet (Variances) but not the Epson Ink one?  like the word "skip" or

I have a list of contacts that I would like to display contact info from a
dropdown list
Cell A4 - To:      B4 (Drop down List) = Imnot Kim & the rest of the list
Cell A4 - E-mail: B4 "Populate"

Can I turn the #N/A result from a lookup function to a zero?
Thanks

I am trying to sum a certain number of columns, based on the criteria in a
certain cell.  
If my criteria is an "8", I want to sum the last 8 columns of an array.  If
I change the 8 to a 9, I want the sum to automatically pick up the last 9

I have a list (A) of 150 items (out of about 500 total items that
interchanges every day).
I have another list (B) of all 500 total items and their corresponding
categories (10 total categories).  List B will never change.  I have already

I have an Excel spreadsheet of names, addresses, etc. that I need to use in a
mail merge to create labels.  Several of the columns contain data with
trailing spaces.  I know how to use the TRIM command to remove trailing
spaces one cell at a time, but is there a way to remove ...

I need the counter in the status bar that will show me how many characters
are in each cell.

    A    B       
1    Qty Sold     Rs        
2    Above 20    2,023.00        
3    Above 80    10,080.00        

Sorry please ignore my previous posting.
I hope someone will be able to help me.  I have tried a number of things but
can't get this just right.  I want to be able to make the text in a cell turn
red if todays date is between two dates.  Example:  in Cells A1 through A12

How to add cells within a cell?
Thanks in advance.

I know there is a subtotal function that will only add up visible cells when
using filters, but is there a formula that will average only visible cells
when using filters?

Is there any way (other that cut/paste value & using a macro) to enter
a date into a cell based on the outcome of another cell, and fix the
date so that it does not change during time.
The following formula will enter the date, however if I open the

I have a table of data. In column A, I have the names of tasks and in column
B I have their expected finish dates. I need to find only those tasks that
have the sub-string "Execute Assembly Test" (approx 107 tasks) and then
determine, based on column B (expected finish), the date ...

I'm using a spreadsheet set up by another user and when clicking in cells in
a column, what appear to be comments appear.  What are they, and how do I
remove them?