I've created an in-depth spreadsheet to organize information. I need to then
take a few columns of that information and put it into a more concise, easier
to sift through worksheet.
This list will be updated frequently. Is there any way I can create this

I have forty clients, 10 have blue shirts, 3 have blue shirts, 5 have 7 green
shirts,15 have white shirts, I need to calculate the total percentage at the
end of the month, I need to show the percentage change  every time I input an
additional shirt for any given client

Would someone be willing to review the file and advise.  when in Print
Preview - if I adjust the print scale - then the zoom ( screen view )
adjust and not the printed view.   I have several co-workers which
have had the same issue happen to them.  It has to be a file setting -

I need help anyone, i have this figure 3,005,987.89 to be deducted from
20,000,000.00, i belive i should have 16,994,012.11.
This is my problem - i have this formula !=INT(R2) in cell R15 which is
working perfectly, what i want to also do is have the the decimals subtract

Hi to everyone.
I need help to find a formula in a slightly complicated problem.
I have three successive columns in Excel A, B and C.
In A column I have A1:An = 1,2,3,……n (successive positive integers starting

I have 3 months of phone numbers from phone bills and I  need to know if
there is a way I can make a formula to show me the duplicate numbers from
month to month.  I have input them in 3 columns and not sure what to do from
here. I've been reading on the forum and some of I'm ...

In a golf tournament, we have two groups of winners.  One group is those
players with the lowest gross scores.  The second group is those players
with the lowest net (gross minus handicap) scores.  In the example, 3
players would be rewarded for their highest finish, be it gross ...

Can someone review the following formula and tell me why I am getting the
#Value error?
=IF(Spacg>8,(FULL/VLOOKUP(TYPE,ProductData,6,FALSE)/((Spacg/8)))+(BBGROUT+BEAM*EA*QTY)+(((IF(ISBLANK(LINTEL),HALF*Setup!$C$15,HALF*Setup!$C$17))+(Setup!$C$19*CORNERS/2))/VLOOKUP(TYPE ...

Hi i have about 10 sheets and in each sheet there is lot of info but from Row
17 to 48 there is a table (columns B till M)
row 17 and 18 are headers and 19 to 48 are the values to be filled. in all
sheets its the same case

Hi, is there a keyboard shortcut that can format with a thousands
separator and 0 decimal places (and no $ sign either).
example: from "12345.6789"  to "12,346"

I have found some examples of how to use a combo to set the data
source of an excel chart (see http://peltiertech.com/Excel/Charts/ChartByControl.html),
using a combo to set an offset.
In this case I'd have a combo box of counties which return number

I suspect it may be onecare related..
onecare is changing all my office security settings to high. And I can't stop
it from doing it. So it's probably the source of this problem. And I'd need a
way to make it permanent that onecare's security changing would have no

    3/30/2009    1   2   3   4   5   -  31     row five
service       charge                                             row six
Mowing      $45.00     [ ] [X] [ ]  [ ] [ ] ---[ ]        [$45.00]  row eight
This is basic what I have, I want to be able to select any of the days of

I have data in cells when i highlight those cells it shows count 20 or count
30 but i want it to show the total value of those  cells.
Eg column d1 has 500
d2 1000

Is there a simple macro that will show how many times a worksheet (not
workbook) has been viewed?  Thanks.
Michael