Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formula help19 May 2007 23:48 GMT5
Excel calculates as:
    cell F13     cell F14                                                
cell F15
R1: 17.54       =(F13*174)*(12) answer: 36617.26
Cannot open Excel file19 May 2007 23:13 GMT3
I worked yesterday on a big Excel file (19 MB). Everything was fine.
This morning, I tried to open it but the file doesn't open.
I see "Opening ...", it seems to work but then the progress control freezes
...
Flitering for unique records in Col B based on filtering in Col A19 May 2007 21:47 GMT1
I have three rows of data in Say Col A, Col B and Col C
Col A has values W,X,Y,Z
Col B has values 1,2,3,4 ... 50.
Col C has names of customers.
Todays date19 May 2007 20:19 GMT3
Column A has dates in it May 17 to August 15 in column J is how many days
until August 15th. In J3 I would like to have the number of days until August
15th from today’s date, tomorrow, tomorrows date and so on. Is there a
formula for Excel to do this automatically?
Fill Colour Prints as Grey19 May 2007 19:37 GMT2
I have a spreadsheet where alternate rows have a fill colour to aid viewing
the correct lines. Although the colour shows fine in the spreadsheet itself
when I Print Preview, or Print the colour is gone and is replaced by a shade
of grey (i.e Light Green is a light grey, Green is ...
Sumproduct19 May 2007 19:36 GMT2
Can I use sumproduct in one spreadsheet, and reference or evaluate cells in
a completely different spreadsheet?
Thanks
help!!!19 May 2007 19:30 GMT1
ok.  i want to take the willstaff test for microsoft excel and windows.  both
versions 2003. i know the basics for both.  there are so many training
sessions on here that i just dont have enough time to do them all.  anybody
know specifically which ones i should do?
Fill series19 May 2007 18:13 GMT2
I need to easily fill about 90 cells in a column with the formula below where
the number following (A increases by 1 in every cell down the column. How can
I do this?
=VLOOKUP(A2,G1:H88,2,FALSE)
Excel 2007 Conditional Format: Marking Absences19 May 2007 18:03 GMT1
I'm trying to keep absentee spreadsheet.  I was hoping to use the green
'check' and red 'x' but I'm unsure how to input the formula so when I mark
the girls Present (P) I get the checkmark or mark Absent (A) I get the x.  
Its for a whole list of names and multiple dates
Hiding number parts by cell formatting19 May 2007 16:50 GMT4
Hello. I have several cells with numbers, whose digits range from 10 to 13.
I want to show only the last 10 digits for every number. Not actually delete
the first few digits, but have them not show, by cell formatting probably. I
have played a bit with custom cell formatting but ...
Tabs at the top19 May 2007 16:12 GMT1
I know we have been assured that one cannot move the tabs to the top,
but I saw a Business Case calculator written in Excel that had the
tabs at the top. So, is there anyone out there wo knows how to do
this?  I realize it is not a standard (supported) feature.
Freezing panes in Excel 2007?19 May 2007 15:21 GMT3
How do you freeze top row and 1st column in excel 2007 at the same time. The
current options seem to be either one or the other.
Thanks!
sales tax total amount from one cell amount to another cell19 May 2007 15:15 GMT1
I WANT TO GET THE FORMULA IF THERE IS ONE ON HOW TO GET THE TOTAL SALES TAX
ON MY HOME MADE INVOICES FROM AN AMOUNT ON ONE OF THE CELLS TO ANOTHER CELL.
Excel19 May 2007 15:12 GMT2
Is it possible to make a Starting  number in an excel workbook in column a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--
Can I have the bottom half Worksheet with less columns than Top19 May 2007 12:57 GMT1
I wish to have the Bottom of the work sheet have less columns than the top,
is there a 'break' or 'section break' that I can use to separate the two
halves of the work sheet with different formating
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.