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
Unlocking excel features31 Jul 2006 18:47 GMT1
Hi there - My boss sent me an email with an excel attachment. It's a huge
list of contacts. I need to expand the columns and make notes. Everything
seems to be locked. All of my choices are grey in color and will not let me
select them.
Adding time31 Jul 2006 17:29 GMT3
I have a spreadsheet that adds time, orning session, afternoon session.  I
then sum the time for the day.  All of that works great, but when I try to
add the week together, from the sums, the calculation is incorrect, it gives
me a number like 17.234455..
REMOVE SORT WARNING31 Jul 2006 17:28 GMT2
I do a lot of sorting using the ascending and decending automatic sort keys
in Excel.  I do NOT need the warning and am tired of having to answer the
idiot question many times a day.  Can anyone tell me how to disable this
warning question?
Excel Formula31 Jul 2006 17:11 GMT15
Hello Programmers!
I have a formula that checks to see if a certain value is in between
two numbers:
=IF(W44>35,IF(W44<37.5,\"EMPTY\"))
advanced search31 Jul 2006 17:08 GMT3
i am trying to make a search on excel that will show a certain amount of
cells with a minimum value. instead of going row by row and select the cells
that have at least the amount i am looking for, can i use a function that
will help me do it faster and more efficiently?
Please Help Combine to Two Lists31 Jul 2006 17:06 GMT3
If Anyone could help it would be GREAT!
I have two lists with 3 columns and approximately 1500 row each
One List is for US and the other is for Canada
Column A = Product
Range of data in Excel31 Jul 2006 17:05 GMT1
I want to count the number of occurances based on multiple queries.
1) Column A contains list of items (Let us say 25 items)
2) Column B contains the grades (1,2,3,4). matching against each of the
listed item. Let us assume that grade1 costs $4, grade2 costs $8, grade3
limiting the viewable space to the data shown31 Jul 2006 16:41 GMT7
I have seen other excel spreadsheets where you could only scroll right or
down so that only the data on the sheet is what you see and you cant go past
that.  I am using excel 2000 and just cant seem to figure out how to do it.
Pull in address from another worksheet31 Jul 2006 16:07 GMT7
I have two worksheets.  The first is a master listing of all stores for a
certain client.  They are all assigned a store number.  The second sheet is a
list of all invoices, I need to be able to type in the store number and it
pull up the street address, city, state and zip, all ...
how to get formula content of a cell?31 Jul 2006 16:02 GMT16
For example
A1: =b2+c2, result is 5
I'd like to get "=b2+c2", not 5, without VBA.
Thank you.
Retrieving Amazon product data to excel, namely books!31 Jul 2006 15:51 GMT4
Is there a way that i can retrive data from amazon.com website into my excel
program?
I am a books seller and have a bunch of books that I want to see if
amazon.com have these book or not and at what price they are selling it for.
Using MATCH function does not return correct answer31 Jul 2006 14:53 GMT2
I have an application with columns of numbers.  
Col A is wave length, B - z are intensities
Row 1 for B - Z contains =MAX(B7:B1201)
Row 2 for B - Z contains =MATCH(B1,B7:B1201,0)
How do I give different $ value to different colums in Excel?31 Jul 2006 14:34 GMT5
I have a spreadsheet that has 51 columns across and 12 rows down.  I am
trying to give each column (down) a different money value, so when I mark
that column (x) with other columns in that same row it can automatically add
up at the end of each column.
#Ref error question31 Jul 2006 14:31 GMT2
I have a problem with a formula.  Here is a very simplified version:
I have a worksheet set up with monthly sales of product A and B.
I use this worksheet to enter in the sales for A and B as well as returns
and a total is calculated.
VLOOKUP's31 Jul 2006 14:26 GMT4
I Have a spread sheet set up whereby i have vlookups and if functions
(tied to hyperlinks).  These all work fine and dany, BUT they have to
be tied to a certain cell (don't they?) i.e. a3, b3, c3 etc.  My
problem is that this spreadsheet could run into the 1,000's is there
 
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.