| Thread | Last Post | Replies |
|
| 'Calculation' showing on my excel spreadsheet (VLookups don;t work | 28 May 2008 10:56 GMT | 2 |
I've created a excel based tool with various charts feeding from tables with V-lookups which point towards a tab with base data in it. Basically i've created one more table with similar Vlookup's to some existing tables and now i've got the 'calculation shopwing on the grey bar ...
|
| Listing values that meet a criteria. | 28 May 2008 10:56 GMT | 3 |
I'm trying to create a list from a worksheet i've made but am unsure how to go about it. The worksheet has a table that gives a rating for different safety issues from a drop down menu (n/a, 1,2,3,4, & 5). I need to be able to list all the ratings that are a certain value Ie. ...
|
| Where is the link? (non-rectangular reference) | 28 May 2008 10:41 GMT | 4 |
Working on excel2002 SP3 I got a workbook with a couple of links to another one - occasionally I want them updated. So, when I open it I choose "Update links" but then get a message "This
|
| If a number is between 1 & 4 then do X else do XY | 28 May 2008 09:41 GMT | 2 |
I want to find out how to do an If formula which gives a result if the condition is between two numbers?
|
| Listing Multiple Finds | 28 May 2008 08:06 GMT | 2 |
I have a table of data (12 columns wide) that consists of lists of employees who have been inducted. I need a way to find all the (say) "Smiths", and list them (and the data in the other 11 columns). The formula below seems to be a good start, if I copy it down in the range
|
| mr t.valko ..help | 28 May 2008 06:46 GMT | 8 |
i have the following data : A 1 axe red 2 axe blue
|
| How to return multiple results in a cell | 28 May 2008 06:34 GMT | 5 |
I have an issue with my designing template, please help me out. I'm having a workbook which contains data in sheet1 as Countries and sales man names. US Smith
|
| REFERING TO CELL IN DIFFERENT SHEET | 28 May 2008 04:32 GMT | 2 |
HOW DO YOU REFER TO A CELL IN A DIFFERENT SHEET? I WOULD LIKE SOMETHING LIKE =LABOR!A1 BUT IT DOESNT WORK
|
| can you make a drop down list in a drop down list? | 28 May 2008 03:22 GMT | 10 |
I have a problem, i created a drop down list of jobs that could have been preformed i need to create another list for each of those jobs to be more specific with what exactly was preformed i had this great idea that maybe if i picked for example warranty work that another list ...
|
| Adding numbers | 28 May 2008 03:05 GMT | 1 |
Sorry the the subject was incorrect, but this is difficult for me to descripe. I have checkmark in an column and I would like to add the associated values in the third column. How would I do this? Example checkmark vetbill $250
|
| How do I make a template in excel? | 28 May 2008 02:34 GMT | 1 |
How do I make a template in excel? Instead of copy last months numbers I would like to have a template that I can put in nexts month tab. Thank you.
|
| how to figure | 28 May 2008 02:04 GMT | 2 |
how do you find the smallest and largest number in a row of cells( part#s)
|
| Delete Unnecessary Rows | 28 May 2008 01:23 GMT | 1 |
I am trying to "clean up" a data sheet so that I can run a drag down command. The data looks like this: Name Type Score John AM 4
|
| I require some assistance please | 28 May 2008 01:18 GMT | 6 |
Good Afternoon, I am in the process of constructing a workbook for multiple employees. I have completed everything I can at this point and have run into a problem. I need to have the information that the employees will input under their tab automatically transfer over to a ...
|
| linking different worksheets in a workbook for a formula | 28 May 2008 01:03 GMT | 1 |
two excel worksheets. Worksheet 1 includes all of the employees along with their hourly rate. These employees can also be filtered according to their job position. In worksheet 2 the company is broken down into different job positions and the quantity of people in each job ...
|