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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Needing Help Very Bad19 Jul 2006 07:23 GMT6
For what I need it would be to hard for me to explain. I have the sheet with
note's in it. Could I maybe E-mail someone to look at
Counting Values19 Jul 2006 07:03 GMT3
I am still having an issue with counting values:
I want to count the number of values in multiple cells that meet a condition.
Two of the conditions are:
Greater than 6 but less than 10
Converting Getpivotdata function in Excel '03 to Excel '00??19 Jul 2006 04:21 GMT4
I have a tough problem I really need solving.
For work I had to do a huge report with a lot of getpivotdata function from
a number of pivot tables. The platform i used was Excel 2003, which I use at
home.
Compare two cells and return certain value in third cell19 Jul 2006 03:44 GMT3
Dear Collagues,
Really needs your helps.
My situation is I have three cell. The first cell is Product and the
second cell is Hardness. My problem is I don't know how to put
Excel performance calculation19 Jul 2006 03:37 GMT4
Could you let me know if there is an Excel function that calculates the
below formula:
List of percentages in column A, with the answer I want at the end of the
column is as follows:
Setup Purchase Order Template to have a automatic number system?19 Jul 2006 03:08 GMT2
How do I setup a Purchase Order Template to have a numbering system?
I would like to setup a purchase order template with a numbering system that
when each time we open new file the Purchase Order will change number.  i.e.,
start at:  W400001, next number W400002 etc.
I have to change a bunch of formula that need to reference a different workbook.19 Jul 2006 02:56 GMT5
The one workbook will have a price list the other will have all the quote
sheets.  At first I had a page with the mark ups and hourly rate in the
first workbook that they were used on another page to mark up the products.
But I realized that this wouldn't work because an changes in ...
Help needed19 Jul 2006 02:36 GMT5
one of my friends asked this question and i did not have an answer so
posting it here.
I want the work book to be shared by mulitiple users. Each user should have
a tab dedicated to them. Apart from the administrator nobody should be able
Complex Date Formula19 Jul 2006 02:14 GMT2
Working on a sheet that I need date calculations formulas.
1.) Need it to calculate the difference between two dates.
(Pretty much have this one nailed)
2.) Once the calculation is made I need for it to give me a value back
How do I calculate times each word occurs in a column of cells?19 Jul 2006 01:30 GMT3
Rather than use a complicated array formula, is there a simpler way to
determine how many times a particular word occurs in a range of cells in a
column? Thank you.
Split a Cell?19 Jul 2006 01:18 GMT6
I have a column "A" with data like the following:
6/12/2006 9:30
I would like to split this into two other columns like:
COLUMN B    |    COLUMN C
highlighting problem in excel19 Jul 2006 00:32 GMT1
I am experiencing problems with highlights in a previously saved excel
spreadsheet.   they have disappeared and now I can't highlight any
cells at my terminal.   if i open my spread sheet on another terminal
the cells show the highlights.   is this an excel problem or a computer
Extract Date from Right Formula18 Jul 2006 23:41 GMT3
I need a formula that will extract the last date from these type of
strings.
07/12/2006 07/12/2006 07/12/2006 07/17/2006 - -
Or
Workday calculation - not working18 Jul 2006 23:31 GMT5
I'm trying to make a time and events schedule to track a project's progress.
basically in A1 will be the start date, B1 will be the end date, and I want
to know the number of workdays, not including weekends it will take to
complete this part of the project in C1. I've entered ...
Data validation18 Jul 2006 23:05 GMT5
In data validation I'm trying to refer to a list in a different sheet but I
didnt work. I have followed the help function in Microsoft but I keep getting
the message that in data validation you cannot refer to a list in a different
workbook.
 
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.