| Thread | Last Post | Replies |
|
| Data Consolidation w/ Multiple List Boxes | 02 Apr 2007 19:44 GMT | 2 |
I am needing help - after days of searching the discussions and trying a few suggestions, I cannot seem to find an answer to my issue. I have timecards of 10 people with a timecard for each month (each on a seperate worksheet). Each timecard starts with 5 columns which include ...
|
| Need help in forcing number that wants to stay in Sci. Notation fo | 02 Apr 2007 19:32 GMT | 6 |
I have received an excel file from a client that is giving me fits. The issue at hand is my inablility to convert a formatted column from number to text, without it reverting back to scientific notation. What is happening is that the column shows a numeric value, such as
|
| tab color change | 02 Apr 2007 19:24 GMT | 4 |
I have a workbook with several sheets inside of it. I would like for the tab color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically ...
|
| Summary sheet with Vlookup | 02 Apr 2007 19:18 GMT | 2 |
I have looked on threads for summary sheet, with or without VBA, however, my sheets in the work book are all the same format, except that the names in column A are not always in the same order. and therefore using the same cell on each sheet is not an option
|
| How do I edit a cell in Excel without clicking on the cell first? | 02 Apr 2007 19:15 GMT | 5 |
I cannot find the shortcut keys
|
| Change Cell Value from another Cell | 02 Apr 2007 19:13 GMT | 1 |
Can we change cell B3's value from a condition in say cell A3. I cannot use = in B3.
 Signature Ponnath
|
| Convert Time to a Text | 02 Apr 2007 18:56 GMT | 3 |
I need help with a formula. I'm trying to convert a time to text as in the example below. Example: A1= 5:16 PM
|
| sum values in cell based on another cell | 02 Apr 2007 16:55 GMT | 2 |
I tried to find a solution by searching posts, but had no luck understanding them. Here is sample table and then my question: A B C D 0 1 1 Tuesday
|
| how do I show 1st, 2nd, and 3rd most repeated non-numeric values? | 02 Apr 2007 16:08 GMT | 2 |
I have several categories that are repeated numerous times. For example, most eaten fruit in the cafeteria... apples, oranges, bananas... I want to put in a formula that will count how many times each fruit is repeated in the data, and if apple is top repeat, show apple in the ...
|
| NUMBERING ROWS | 02 Apr 2007 15:48 GMT | 2 |
hi, i am trying to give the rows a number in a designated column that when 1 is entered and i drag down the rows the numbers following will automatically change in order eg 1.2.3.4.5.6.7.8.9. etc any help willbe brilliant
|
| Rank excluding Errors | 02 Apr 2007 15:46 GMT | 3 |
I've searched for a solution here, but I'm not able to find any. My formulas: =RANK(C12;IF(ISNUMBER(C$7:C$55);C$7:C$55;"");0) or
|
| How can I apply a formula to all cells even those with < signs? | 02 Apr 2007 15:43 GMT | 5 |
I have a huge worksheet (about 741 lines) and almost all figures in the cells need to be changed from parts per billion to parts per million. Is there an easy way to change this? Some cells have < signs in them. I would really appreciate help with the formula and applying to ...
|
| Conditional Formatting based on Text | 02 Apr 2007 15:42 GMT | 2 |
I have two questions: 1) I have two columns one is 'purpose for gift' and one is 'gift amount', I've subtotaled these using excel - and would like to automatically format the gift amount to be bold for each subtotalled line. I thought I could use
|
| Using Data from Drop Down Menus in Sum Formulas | 02 Apr 2007 14:26 GMT | 3 |
Hi there, I'd like to set up a spreadsheet with numerical drop down menus, the selected values of which can then be taken and added together using the sum function. I've tried adding in a drop down using the forms tool bar but sum
|
| Excel spreadsheet formula | 02 Apr 2007 14:03 GMT | 2 |
Is there a formula to add 90 days to a date. (i.e what is 90 days from 01/20/07)
|