| Thread | Last Post | Replies |
|
| Return a list dependent upon the selection of a preceeding list | 11 Apr 2007 19:48 GMT | 4 |
I am creating a form defined by Category, Item, and sub-item. I would like to be able to select the category from a list. Then dependent upon that answer I would like to be able to select the appropriate item from that specific Category list and so on. How can I do this?
|
| How do I link the header to something in the worksheet? | 11 Apr 2007 19:41 GMT | 1 |
I would like to have the header (in Excel) show the content of cell D1 in sheet1. I would like to know how to do this. Thanks.
|
| end date | 11 Apr 2007 19:39 GMT | 3 |
If I input a start date in a cell, and give the number of days required to complete the task in another cell.......How can I compute the end date omitting the weekends (Saturday and Sunday)? thanks
|
| how to use the ceiling function | 11 Apr 2007 19:34 GMT | 2 |
What I am attempting to do is multiply each cell in D column by 6 and then rounding up the answer to a multiple of either .25, .50, .75, or up to the next whole dollar amount. But I want it to do it on each row. I am using the excel template for inventory.and so far I got the ...
|
| Sorting latitudes and longitudes | 11 Apr 2007 19:18 GMT | 7 |
I have a large dataset (~5000 rows) that is tied to latitdue and longitude (small portion below). For each latitude/longitude reading I have between 8 and 10 columns of other data (not shown). I would like to sort the data into latitude/longitude bins and then analyze it. The bin ...
|
| Excel question | 11 Apr 2007 18:24 GMT | 5 |
Simple help needed, I want to make a cell return a value when another cell has a particular value. for example Part # color 11 red This cell = red, blue, … depending on what Part # is entered.
|
| Adding formulas | 11 Apr 2007 18:10 GMT | 4 |
Hello from Steved I would like to please add the 2 below to a cell, What Do I need to do, They are two Cities that I want to be added together to be put in Cell C5. =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE))
|
| Can an Excel cell value be used in a Custom Footer? | 11 Apr 2007 18:00 GMT | 7 |
Attempting to print some reports from a Pivot Table and should like to use a cell value as a footer. Is it possible to quote a cell value in the Footers?
|
| Excel decimal moving? | 11 Apr 2007 17:55 GMT | 4 |
I am trying to format a cell so that i can input a number and excel will automatically place the decimal point for me. for eg. i want to type 12 i want excel to put 0.0012 etc i want to type 1 i want excel to put 0.0001
|
| multiple variables in sumproduct or if/then formulas | 11 Apr 2007 17:28 GMT | 4 |
Help....I just can't figure out a correct formula. I need a formula that gives me: if a specific date spreadsheet A = a date on spreadsheet B and a specific dept # on spreadsheet A = the department# on spreadsheet B
|
| Sort not working - very large file | 11 Apr 2007 15:58 GMT | 1 |
I am trying to sort a file with many columns, it is a 10 M file. If I break the file in half, I can sort half and then sort the other half, but I cannot sort the entire file. Is there a limit that messes up sorting that I haven't found?
|
| Difference in Weeks between 2 dates | 11 Apr 2007 15:56 GMT | 2 |
I am desperately trying to figure out the difference between 2 dates in weeks. Could somebody help me out? I greatly appreciate your help. Thanks Susanne
|
| Exporting data to Excel | 11 Apr 2007 15:52 GMT | 4 |
How come when I export data to excel and reformat a column to numbers, it doesn't recognise them as numbers and I have to retype the numbers in a separate column to calculate them. HELP PLEASE.
|
| How to forecast non-numerics? | 11 Apr 2007 15:31 GMT | 4 |
Here is a sample of what I'm trying to forecast... Month Visitors to Store Jan 50,000 Feb 60,000
|
| Lists From Different Tabs | 11 Apr 2007 15:30 GMT | 2 |
I'm trying to use Validation on Sheet 1 to create a list. The data for the list is on Sheet 2. I've assigned the name "States" to the column on Sheet 2 that contains the data for the list.
|