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 / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Find duplicates in data with multiple criteria14 Dec 2007 15:56 GMT1
Hello - We are trying to create a list for holiday cards this season.  
However, when we imported everyone's information into an excel spreadsheet,
we received duplicates which were to be expected.  I did a subproduct on two
of the fields, Last name and Company and managed to find ...
Delete row if all cells are blank, Excel 2000 & 200314 Dec 2007 15:55 GMT1
I have a worksheet with 1061 rows and 7 columns of data.
Example:
column A    B    C    D   E
          aa          bb       cc
OLE control for workbook hidden field14 Dec 2007 15:38 GMT1
In Excel under the  Window menu there are hide and unhide menu options to
hide and unhide workbooks.  However, the workbook object does not have a
visible or hide property.  How, using OLE, can I view and change the hidden
status for workbooks?
IF AND FORMULA14 Dec 2007 15:37 GMT1
I need a formula for the following:
If tab 'The Worker Be! cell B8 = SuperModule AND tab 'Stibo Calculations'
cell S8 is not = to C. than add 85 + ('The Worker Be!' cell F8 * 225) * 'The
Worker Be!' H8 * 'The Worker Be! X8
Filter nonblank AND unique14 Dec 2007 15:34 GMT1
Is there anyway to filter using multiple criteria: nonblank AND unique?
one or more invalid names were detected in this work sheet14 Dec 2007 15:34 GMT2
Every time I start up excel, it appears a warning "one or more invalid names
were detected in the work sheet. those invalid names have been changed to
#REF!".
What is problem? How to fix it up? Please help me.
Dates change when copied to new workbook or worksheet14 Dec 2007 15:29 GMT2
I'm sure this is just something I don't know about....but when I copy a
spreadsheet with dates (all in the past week - 2007), to a new workbook, the
dates all change to 2003.  Any idea why this is happening?  Is there a
formatting option I need to have selected before I copy?
Excel Macros from 2003 to 200714 Dec 2007 15:29 GMT1
Will my macros from the previous version of excel transfer to Office 2007
seemlessly?
It's not a date or time.14 Dec 2007 15:29 GMT2
Hi, I'm exporting data to Excel from another software program.  When the data
is in excel, there is one column that contains numbers and colons (e.g.
10:10:80).  Unfortunately for me, Excel sees this as an improper date/time
entry and gives me a decimal number instead.  Is there ...
Fitting text into a cell problem.  Please help!14 Dec 2007 15:27 GMT3
Hi a colleague of mine is trying to fit a lot of text into a cell however
once he reaches acertain point the text dissapears from the cell and is
replaced with ####.  The text is still visable within the formula bar.  I
have tried increasing the size of the column and row and ...
Help with return values on IF/THEN14 Dec 2007 15:27 GMT2
I am trying to write an if then statement, where if the amount in a cell is
greater than zero it will return the value in another cell.
IF (a3>0, then "A5")  can't link to the A5 cell and A5 is returned.
If (a3>0, then C3=A5) won't work....getting an error.
opening a file with wildcard14 Dec 2007 15:08 GMT1
The following script enables me to open a file and bring specific data into
a different workbork.
Problem : Once the data is in, I ask to go back to the initial file
"abc_SCCS_1*.csv" in order to close it but I get a Run-Error 9 : Script out
When i put A in Cell A1 i need excellent to come up in B114 Dec 2007 15:01 GMT2
When i put A in Cell A1 i need excellent to come up in B1
Tell me which "season" (Month/Day through Month/Day) a date     (Month/Day/Year) falls in (any year)???14 Dec 2007 14:59 GMT1
I have a list of dates, and I need to find out which season each one
falls in.  From all of the date researching that I have done, I cannot
seem to get my answer.
Here is the issue.  I have a list of dates:
Excel 2007 - Calculation Problems14 Dec 2007 14:41 GMT12
I am using Excel 2007, and have a large file (11MB) that is giving me
problems. The file is used to forecast revenue opportunities for a 4 year
period, and then calculate the recognized revenue based on the timing of
deals, revenue type etc. and is approxiamately 735 rows by 1700 ...
 
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.