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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Counting number of cells that contain certain text but not cell tw11 Sep 2006 21:50 GMT1
How can I count cells that contain certain words without counting same cell
twice.
e.g.
          Column A
How do i increase the height of the worksheet tab in Excel?11 Sep 2006 21:46 GMT6
I really would like to increase the height of the worksheet tab at the bottom
of the screen.  I have so many tabs and hate scrolling.  Would rather have
the width of that bar be 2 or 3 rows in height.  Is there a way to do this.  
I thought for sure i had seen this done before, ...
can excel calculate time increments in a formula?11 Sep 2006 21:39 GMT2
I want to have a formula in my time sheets that calculate the incriments of
time. For instance:
If the time on a project site is:
Start Time    End Time     Project Hours
how to automatically number rows in an excel worksheet11 Sep 2006 21:32 GMT5
I am trying to automatically number rows in a worksheet.  I have used the
=ROW(A1) function and that works alright, BUT it doesn't re-adjust
automatically after a row has been deleted or inserted.  I also tried
selecting the range and creating it as a LIST, which works when we ...
IF statement11 Sep 2006 21:24 GMT3
Can anyone help me, please?  Need an IF statement that would go like this:
If L8-M8=0,"",if E8 has TBG or PL in it, then calculate the difference
between L8 and M8 only when it exceeds 7 days
Thanks a bunch
how to get the column number from the corresponding column name denoting initial..???11 Sep 2006 21:17 GMT5
   i want to recieve the column number ( ranging from 1 to 256 ) while
the input will be the column name (ranging from A to IV ).  please
provide me a macro solution to reach the above mentioned requirement.
Thanks and Regards
Concatenate Doesn't Work for this11 Sep 2006 20:23 GMT3
On a labor time spreadsheet, The date is in one cell and the time is
shown in successive cells for each record.
I need to be able to merge the date (5/11/2006) and the time (11:00 am)
in order to get (5/11/2006 11:00 am).
Adding/Analyzing Data From One Worksheet to Another11 Sep 2006 20:22 GMT1
I am making a report to track the sales steps and processes for a car lot.  
The log has been set up with all of the different columns that I need.  I
would like for the second page of the workbook to analyze/add the data and
statistics that will be entered into the log.  My ...
disk storage number format in excel?11 Sep 2006 20:21 GMT1
I am creating a sheet in excel to track disk usage, does anyone know of a way
to format the numbers in the cell to appear as common disk space nomenclature?
I would like to see something like 54GB, 54k, 125mb..
Fill in if..11 Sep 2006 20:12 GMT3
I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO
HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES.
How do I assign a numerical value to a textual entry to calculate percent completion?11 Sep 2006 19:58 GMT2
Hi guys, I have a spreadsheet that looks as follows
Packslip | Text | Photo | SEO | % Complete
440158   |    1  |     0    |    1    |  66%
440159   |    0  |     1    |    0    |  33%
Networkdays plus Sundays11 Sep 2006 19:53 GMT4
 I need to calculate the number of work days between two dates that
includes Sundays as a workday.  So only Saturday would be excluded.  Is there
a way to count the number of Sundays between two dates?  I could then just
add that to the result of the NetWorkDays function.
Why would a pivot table lose its character?11 Sep 2006 19:19 GMT1
I have been using a Pivot table to accumulate data.  I opened the file and
input my data.  I went to my Pivot summary and it wouldn't allow me to
"refresh my data". In other words, the PT command to refresh my data was
"greyed out".
Troubleshoot horizontal scrollbar11 Sep 2006 18:27 GMT1
Why do my arrows disappear on my horizontal scrollbar when I'm working in a
worksheet?  And, how do I get them back w/o closing the document and
reopening it?
Thx! Diane
tricky search and replace11 Sep 2006 16:41 GMT6
I need to search for a particular string in a very large spreadsheet, and
when I find it I need to replace it with the contents of, or a reference to,
the cell 3 to the right and 2 above it.
For example... Let's say the string is 'XXXX'.  Lets say the 1st instance of
 
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.