| Thread | Last Post | Replies |
|
| Unlocking excel features | 31 Jul 2006 18:47 GMT | 1 |
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 time | 31 Jul 2006 17:29 GMT | 3 |
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 WARNING | 31 Jul 2006 17:28 GMT | 2 |
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 Formula | 31 Jul 2006 17:11 GMT | 15 |
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 search | 31 Jul 2006 17:08 GMT | 3 |
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 Lists | 31 Jul 2006 17:06 GMT | 3 |
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 Excel | 31 Jul 2006 17:05 GMT | 1 |
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 shown | 31 Jul 2006 16:41 GMT | 7 |
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 worksheet | 31 Jul 2006 16:07 GMT | 7 |
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 GMT | 16 |
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 GMT | 4 |
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 answer | 31 Jul 2006 14:53 GMT | 2 |
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 GMT | 5 |
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 question | 31 Jul 2006 14:31 GMT | 2 |
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's | 31 Jul 2006 14:26 GMT | 4 |
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
|