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 / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to format a cell to make it blank if it's content is "N/A"08 Mar 2007 14:19 GMT7
How to format a cell to make it blank if it's content is "N/A"
Thanks
Turk
How do I put combo box values into cells (without using @CHOOSE)08 Mar 2007 13:44 GMT4
I am using a combo box to select from a very long list. In order to save
repeating the process of selecting from the combo box on each sheet in the
workbook I would like to transfer the value displaid in the first combo into
a cell on each of the other sheets. The list is too ...
If sate ment using edate08 Mar 2007 13:04 GMT4
to keep my cell clear until someone enters data in another cell
I would like to do the following formula
=IF($G15="", "",edate($G15.1))
This is not working
Worksheet Security/Cell Protection08 Mar 2007 10:47 GMT2
Is there a way to have 2 sets of cell protection passwords - one that
protects specific cells for one group of users and a different password that
protects a different set of cells for another group of users - in the same
worksheet?
Format Cells to calculate hours and minutes taken to complete task08 Mar 2007 10:45 GMT5
I have the following calculation in my column E:
=((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24
Column D is Date/Time order completed in format: dd/mm/yyyy hh:mm:ss
Column C is Date/Time order received in format: dd/mm/yyyy hh:mm:ss
HyperLink08 Mar 2007 10:26 GMT1
Good Day My name is LLoyd
I have a list in one sheet, on the other I have Validation in a cell which
comes from a list, then below that =VLOOKUP($C$2,Database,5,0) in cells, but
my last Vlookup pick up a hyperlink, but it see it as text not a hyperlink.
SQL syntax08 Mar 2007 08:27 GMT2
I will be very grateful for the SQL syntax to use for an ADO query on a large
csv to pull in all the rows of data for one specific fund to an Excel
spreadsheet.  There are about 35 funds listed in the first column headed
"Funds".
Split up summary sheet08 Mar 2007 07:08 GMT2
I have created a monthly time sheet for my employees to fill out. Since they
can work on different projects during the days of the month, the spreadsheet
looks like this:
                            M          A           R             C          
one variable data table08 Mar 2007 06:57 GMT2
heres a question from my text book that i dont understand what to do
example:
the the range D4:G15, create a one-variable data table that calculates the
Revenue, Expenses, and Net Income bases on the Customers( per day) value....
Countif?08 Mar 2007 04:59 GMT4
(please forgive me if this is a duplicate posting...)
I'm trying to do the following:
Count how many cells (rows) in column A that has the value 1 in Column C AND
value 1 in Column D?
copy equations between spreadsheets08 Mar 2007 04:57 GMT2
This should be simple...
I have equations in one spreadsheet that reference cells in other worksheets
within that spreadsheet.  I'm looking to copy these equations to another
spreadsheet and retain the relative reference to the named worksheet (i.e.
How to use the CountSum funtion of worksheet in Macros08 Mar 2007 03:59 GMT1
I need to count the sumn of values present in a column or row using Excel
macros.
Solver for excel08 Mar 2007 03:48 GMT1
how do i add the Solver for excel without the disc?
attach files08 Mar 2007 03:42 GMT1
I would like to set up a spread sheet where I can track income and expenses
and at the same time attach a pdf file of the corresponding invoice.  Is this
possible in excel?
wnat to extract first & last names in sep cols from name list in 108 Mar 2007 03:27 GMT4
I have a list of names that shows first and last names in one column (entry
="John Doe") I want to separate these into two columns so that I have one
column with entry="John" and next column has entry="Doe". I can do this the
loooong way bt copying the first column over twice, ...
 
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.