| Thread | Last Post | Replies |
|
| formula bar | 18 Aug 2006 20:39 GMT | 2 |
My formula bar on Excel has disappeared from my spreadsheets. How can I get it back? thanks for your help
|
| Conditional Formatting | 18 Aug 2006 20:37 GMT | 2 |
Looking for a solution to a conditional format problem. I need t change the color of a cell based on the input, with 8 different option matching 8 different colors. Conditional format only has thre parameters, so I can't use this option. Thought about using a neste
|
| Vlookup Help | 18 Aug 2006 20:25 GMT | 2 |
I have a calendar that uses Vlookup functions to look up a persons DOB or other date from a list and displays the persons name if their DOB or other date coincides with the calendar date. I can't figure out how to display more than one person in the same cell (merged cells) if they
|
| connecting multiple cells to new sheet (VLOOKUP?IF?) | 18 Aug 2006 20:03 GMT | 1 |
I am trying to find a way to pull certain data off an existin worksheet and onto a new sheet. I don't think I need a macro and can d it through VLOOKUP or an IF function. Would be good if someone coul give me some help on this.
|
| Analyze Data | 18 Aug 2006 20:01 GMT | 3 |
I am trying to anayze the data from a survey that was handed out to 20 people and was ranked 1 - 5. Number 1 as being the least need for improvement and 5 being the most need for improvement. How do I come up with a chart that will analyze this data?
|
| returning value if month is January | 18 Aug 2006 19:47 GMT | 6 |
I have a list of data (1000 rows). Each row has several columns containing information on a give transaction. column F contains the date of the transaction (mm/dd/yyyy format.)
|
| PIVOT TABLES | 18 Aug 2006 19:17 GMT | 2 |
Can anyone help me with highlighting the subtotals on a pivot table. I know I am able to click sometimes and all subtotals are selected but I am not sure what or how I do it. help. Louise
|
| budgeting for your home | 18 Aug 2006 18:47 GMT | 1 |
I am trying to download a home budgeting sheet for every day expences so as i can see where my money is going so far the onlys i have found are american,these sheets are very good but i need one that will work in sterling can anyone help
|
| How do you use more than 7 arguments in a logical IF? | 18 Aug 2006 18:46 GMT | 7 |
I am able to utilize a logical IF to automatically select the data I want to show in a cell based on the result of the logical IF statement. My problem is that I want to exceed the apparent limit of 7 nested IF's. The result must show up in a speciofic cell.
|
| How can I combine cells with first/last names into email addy? | 18 Aug 2006 18:41 GMT | 9 |
I need to combine a first name with last name, combine them with a domain to create a useable email address.
|
| My IF in Excel formula is not returning the correct value. | 18 Aug 2006 18:29 GMT | 10 |
I am doing a reference of 1, 2, or 3 returning specific text based on the number. Here is my formula. =IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY MEETS",IF(G29=3,"EXCEEDS"))) if the ratings are all 3's the correct text value will appear. If you vary
|
| Summary Sheet | 18 Aug 2006 18:28 GMT | 3 |
I have about 10 workbooks all setup the same with the same formating, formulas, etc. but all with different data. Lets say they are called "workbook1.xls to workbook10.xls". All data is located on "sheet 1". There is one column (lets say "D") that has a calculated date in it. I ...
|
| Tab Through worksheet | 18 Aug 2006 17:46 GMT | 1 |
Is there a way, such as in Word, when the sheet opens the curser immediately goes only to the unlocked cells that need to be filled and you tab to the next? Thanks!
|
| Inserting a cell changes my formula values | 18 Aug 2006 17:42 GMT | 2 |
I have a formula thus: =IF(A4=B4,"SAME","DIFFERENT"). However, when I insert a cell above B4, the formula automatically changes, thus: =IF(A4=B5,"SAME","DIFFERENT") How do I prevent this from happening?
|
| Calculate Based on Drop Down Item Selected | 18 Aug 2006 17:42 GMT | 1 |
I have a cost estimation worksheet that includes a drop down list. Whe the user selects from the list, I want to apply a factor based on thei selection and multiply it by a total (on a different worksheet). Fo example, if they select "Low" from the list, I want to multiply 10% b
|