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 / New Users / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
alphabetize the names  colum on the excel01 Jun 2007 17:07 GMT1
How do I alphabetize the names on the excel
Conditional Statement in Excel01 Jun 2007 16:11 GMT1
I'm trying to create an if statement that whenever the user selects
"Debit Memo" from the dropdown menu in column A (has other items--
Credit Memo Check, Transfer), the user would be forced to enter the
corresponding value in column F (Debit).  If the user attempts to
Application quits each time I use the spreadsheet in Excel01 Jun 2007 16:09 GMT1
Everytime I try to use my spreadsheet, the application quits.
Sometimes I get it to open for about 30 seconds, othertimes it quits
upon opening. HELP!
SUM values if containing an error01 Jun 2007 16:05 GMT2
I have the following formula and I am not getting any results to show.
=SUM(F7,F16,F25,F34,F43)
Each cell in the formula displays the result of another formula (which
may or may not yield a result - if not the result is an value error).
empty cell in formula01 Jun 2007 15:07 GMT2
I have an Excel book but it's for advanced users and, I guess, this is so
basic that the answer is not there.
I have a really simple spreadsheet I use to replicate my time cards from
work.  for this example I have:
deleting rows with a macro01 Jun 2007 13:43 GMT2
I am using Excel 2000 and would like to create a macro to delete rows that
do not contain specific text in column 1. so, if the cell does not contain
the words 'Centre' or 'Member' I would like to delete the row.  I am a bit of
a beginner to macros and have looked up the ...
grouping the numbers as per indian method01 Jun 2007 13:37 GMT2
sir,
i wnt to group number as follow
for,  1234567891213456.75
as  1,23,45,67,891,2,13,456.75     (i.e. indian method of grouping pg numbers)
Recalc question01 Jun 2007 13:35 GMT2
Is is possible to have an automatic worksheet recalc, say at a timed
interval, or when the worksheet is accessed?
This is required to update the now() function without having to press
F9.
simple subtraction01 Jun 2007 10:10 GMT2
I need help subtracting values in rows from each other.
My data looks like this
Values        Difference
242                
how to flush away undo commands?01 Jun 2007 08:10 GMT1
how can I flush away undo commands?
I use excel 2003 or 2007.
Thanks.
Need help with very complicated loan spreadsheet.01 Jun 2007 02:35 GMT1
Hi everyone, I was wondering if anyone can help me out with this.
I have a loan and wanted to do a spreadsheet to keep an eye on
everything. I've looked everywhere for one that will suit me without any
luck.
Creating a rota01 Jun 2007 01:16 GMT2
I am trying to create a rota for work.
I have used the randbetween function to create a number between 1-6, and
then used the choose function to use th erandom number to pick a name from
the list of staff in the choose function.
 
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.