I have an excel sheet contains all the customers in once column "a" and their
monthly sales in column "b,c,d,e,f,g,h,i,j,k,l,m" and average in "n".
I want to filter all the customers whose average is >0 and less than 50
sales and another condition is >50 and less than 100.

I got the following formula from this Newsgroup and re-did to fit, but
its not quite right. I am trying to total the number of employees
clocked in for each hour of the day, from values I have imported from a
Database

Hi there
I need to get the % of totals in the pivot table and don't know the formula
to use when using the Insert calculated field option in the pivot table.
Can someone assist

I made a database for personal information. I gave every person one
sheet with a fixed format. I have about 200 sheets now all named
according to the individual. Now I would like to have one master sheet,
the first sheet, in the excel workbook that list all the names of the

I have spent my weekend on this and still can’t figure it out.
I have a workbook with two worksheets, one is Data and one is Report
One the Data worksheet I have about 20 columns from a data dump.  Here are
the columns I want to report on:

I use a pivot table for inventory transactions, and I'll have a column next
to the pivot that I use for analysis. However, when I add a new part to the
database and refresh the pivot table, it naturally adds the new part and
shifts the cells downward. But the column that I use ...

I would like to know how can I see a Sage tool bar on my excel spreadsheet,
so that I can easily update my reports?

The arguments for a HYPERLINK() worksheet function seem to be limited to 256
characters.  Is there a workaround for this?
I need to embed functions like this
 =HYPERLINK("mailto:address@domain.com?subject=My Subject&body="&A1)

My question is : How do I UNconcatenate the data below into its original form
of cell A1 & B1
-Data Form-
Concatenate result: XZU422R-HKMRS3-2312

I am trying to have Excel automatically put in numbers for me relating to
grades.  Our grading system follows:
Grade    Min %    Points
A+    100    12

I have a timesheet recording activity against client for a day. (E.g. ColA:
Client code, B: hours)
The client code may have several entries in the day and may vary from
day-to-day.

I have the following formula and am trying to incorporate the trim function
into it; i.e., I want to match the trimmed E2 to the trimmed V:V.  Is there a
way to modify the formula to do this; haven't been successful yet in figuring
this out.  Just adding trim in (or clean) ...

Last week, Mr. Don Guillett provided me with this formula to cut a Named
Range and paste the Named Range one cell/row below.
It works perfectly when I run the macro (in another sheet or workbook).
However, when I include the two macro commands with other commands, IT DOES

### appears when putting a number into a field. How do I get rid of this
format?

I have spent my weekend on this and still can’t figure it out.
I have a workbook with two worksheets, one is Data and one is Report
One the Data worksheet I have about 20 columns from a data dump.  Here are
the columns I want to report on: