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 / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formulas23 Sep 2006 15:27 GMT10
Is there a formula to round numbers to the nearest quarter?
Is there an easy way to swap the contents of two cells in Excel?23 Sep 2006 14:33 GMT7
I think the subject says it all...
The 1st and 2nd rows of my worksheet have disapeared?23 Sep 2006 13:56 GMT9
Row 3 is the first one shown. I tried to unhide them but it didn't work. When
I insert new rows they still start with row 3. Where are the missing 1st and
2nd rows?
Excell should have more data sorting features23 Sep 2006 13:52 GMT1
how do u sort data by multiple rows? for example i have number values of 2
rows and 10 columns.
eg: 25 15 01 69 56 55 23 45 03 14 ...
     58 68 33 45 02 07 78 90 53 44 ...
When excel is opened, Insert, Format, Data options greyed out.23 Sep 2006 13:30 GMT2
When excel is opened, Insert, Format, Data options greyed out. Right click
menu does not work
Protection option also greyed out so not issue of worksheet protection
need advice on permanant solution to use excel effectively.
dynamic transpose23 Sep 2006 12:49 GMT1
Is it possible to do a dynamic reference for a transpose?
I'd like to do the transpose of a 12 cell horizontal reference into
vertical, but I need the tranpose function to lookup the line of the 12 cells
by finding a value in a vertical list.  In other words, the value that drives ...
convert number to its letters ( convert "1" to "One" )23 Sep 2006 11:58 GMT1
I want a function or command that
convert number to its letters it means ( convert "1" to its Letters "One" )
Convert digital #'s to spelled out words23 Sep 2006 10:23 GMT5
Is there a way to turn you numbers into spelled out words?
Example
24 = twenty-four
Drop down box23 Sep 2006 07:00 GMT5
If I choose a word/command/field from the drop down box,
how can I format the next cell over recognize this selection
and display a number?
Basically I created a drop down box, Van, Bus, etc...
Conditional date array formula23 Sep 2006 06:42 GMT1
This is the formula:
=IF(ISERROR(INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:2)))),"
",INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:1))))
Log ...
COUNTIF Formula in Multiple worksheets.23 Sep 2006 03:33 GMT13
I need to use the COUNTIF formula to count items in 52 different worksheets.  
I know that this formula will not work in counting multiple worksheets.  
Anyone know of a quick workaround?
I dont want to get stuck typing 52 different SUM formulas.
I made drawings in excel, I don't see them but they print fine.23 Sep 2006 03:30 GMT1
When I open the spreadsheet the numbers and letter appear but the shapes
around them do not appear. If I click on them I can get them to show up, but
I have to click on each picture. When it prints all the pictures show up
fine. Can you help me?
Automatically Filling In Corresponding Data from Another Worksheet23 Sep 2006 01:52 GMT2
Here's my situation:
I have a list of employees on on one worksheet.  In the cells next to
each employee name are their hourly pay rate, their department, and
their various overtime thresholds (the elapsed hour they go in to
Excel Permissions23 Sep 2006 01:49 GMT1
I want to set permissions for an excel file. According to excel "help", I
just go to "file" and then "permissions"; there is no "permissions" under the
file menu. I have excel 2003 - how can I find permissions?
James A
In Excel, use a different row for headings (not row 1)23 Sep 2006 01:14 GMT1
Hi! I'm trying to do a mail merge from an Excel sheet. Unfortunately, it was
set up with some other information in the first few rows. Can I mark a
different row as the header row for my data? They are in row 5.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.