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 / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel23 May 2008 14:06 GMT4
I have excel 2002 on my computer,  I have excel 2003 at work.
Are these two software compatible.  I want to know if I have a worksheet in
excel2003 I can open it in excel 2002? If not is there a cheap upgrade?
Returning Multiple Matches23 May 2008 13:53 GMT2
I have an worksheet that has data that is sorted like the following
Bar NumberProperty    Node     Orientation    OD    ID    Wall
1    1622    3    5    16    13.25    1.375
2    1622    4    5    16    13.25    1.375
Hyperlink destinations have changed23 May 2008 12:28 GMT1
I have a spreadsheet with several hundred hyperlinks to various documents
(all within one pathway.  
It has all worked fine for months, but today when I opened it the hyperlinks
have all changed their destination path.
Use SUMPRODUCT for a matrix23 May 2008 10:26 GMT3
The case is I want to key in two criteria and the function give me back the
total. For example, I want Sun in the rows and Two in the column, then will
give me the total of  2 + 8 = 10. The Sun and the Two is input some where and
will be change from time to time.
Order form - how to automatically round what a person inputs to a23 May 2008 10:06 GMT3
Hi all, I'm trying to make a product order form and I want to set it up so
that the "Qty" field automatically changes whatever a person enters into a
multiple of 6 units (all the products come in packs of 6 so customers have to
order 6 or 12 or 18 or 24 units - you'd be amazed ...
please help in excel functions.23 May 2008 08:02 GMT2
Suppose, i have 3 incentive slabs
No.of sale            incentive slab
1-10                     no.of sale*8
11-20                   no.of sale*10
Summarize in Vlookup23 May 2008 01:21 GMT3
qucik question.
i have a data table and using vlookup. however getting stuck when i need to
summarize all values that matches my vlookup ref. Any help, suggestion would
be great.
Can a sort be set up to run within another sort?23 May 2008 01:18 GMT1
I am trying to set up about 4 sort levels, i.e.
first sort: no to yes
2nd sort: alpha name
3rd sort: alpha broker
Look-up (match) and merge data22 May 2008 23:56 GMT1
I need to match a column on two sheets.  Then use that match to pull over
multiple other cells related to that matched cell.  For example:  Each Sheet
contains employee IDs, but sheet 2 also contains there First & Last name,
Date of Employment, etc.  Each Data point on the same ...
Multiple Criteria for SUMIF22 May 2008 23:41 GMT5
I'm having issues trying to sum data using more than a single criteria.
My layout is as such;
Col.A = Date
Col.B = Type
Grading Multiple Choice Exam22 May 2008 23:31 GMT2
I am setting up a spreadsheet for my students' answers to a multiple choice
test. One of the things I want to do is see how many students got each
question correct, and that is easy enough to do using COUNTIF. However, I am
having a hard time creating a function that will tell me ...
Using font elements as condition criteria22 May 2008 23:28 GMT2
Does anyone know how to use font elements like bold, italic, underline, etc.
as  criteria for a formula to return the value from a cell? I am trying to
use bold $ values as the criterion for pulling the $ value into another cell.
I can do the entire column but all I want are the ...
if(and(isblank( formula help22 May 2008 23:25 GMT2
I have columns data
ie:
ad     ae       ag          ah
12     23         34.00    0  
convert22 May 2008 23:16 GMT2
howcan i make that when i enter a number in colum A, ut should convert to
text in colum B?
Signature

mf

functions22 May 2008 23:15 GMT1
when i enter a number in a cell i want it should convert in the next cell to
words
Signature

mf

 
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.