| Thread | Last Post | Replies |
|
| Conditional formatting of entire workbook | 20 May 2008 03:00 GMT | 3 |
I have a workbook that has separate sheets for each day of the school year and wanted to see if I can conditionally format the whole workbook at once instead of having to do one page then copy. Right now I have one that is live data and I am creating another version for next ...
|
| pivot tables - add columns | 20 May 2008 02:17 GMT | 1 |
I would like to add columns to see the info by different ways without changing the field configuration. Is it possible.
|
| Can Excel warn me if a cell already contains entered information? | 20 May 2008 01:21 GMT | 2 |
I'm using Excel to keep track of orders - each with a separate number. These numbers are all in the same column. Can Excel warn me if another cell in the same column already contains the information I'm trying to put in? Order numbers consist of only four numbers, if it matters.
|
| Search for duplicates across three worksheets | 20 May 2008 00:29 GMT | 1 |
I need help with this one. I have one excel file with three worksheets. I want to compare the data in column A in each worksheet and if a value exists in more than one sheet I'd like to highlight the cell in each sheet it exists. Or I guess another way to put it is I want to ...
|
| Concatenation | 19 May 2008 23:27 GMT | 2 |
How do I use the concatenate function to merge data from separate cells? appreciate it very much if somebody could explain with a simple example.
|
| Is it possible to dedupe two excel lists? | 19 May 2008 22:21 GMT | 1 |
I have two excel spreadsheets with overlapping data and would like to dedupe them, seperating the unique from the duplicate data. Does anyone know how I could accomplish this? TIA,
|
| HELP | 19 May 2008 22:17 GMT | 3 |
I have a date that I would like to add 28 working days to. I don't want to include the weekend days in the calculations. So May 19, 2008 plus 28 working days would be ???? I need a formula for my worksheet. Can you help.
|
| How do I enter the formula to show the current day of the week ? | 19 May 2008 22:17 GMT | 4 |
I want to show the current date ..ie =(today) but in a column next to it I want to show the day of the week. What is the formula ?
|
| Formulas and counting | 19 May 2008 21:27 GMT | 9 |
II need to have a formula that will search through one column in a specific range (check Sheet1!C:C for a date range) if it is within that range then check Sheet1!E:E for a specific value if it is that value increment this cell by one. Is that possible in excel? I tried and if ...
|
| Can I create a button for a formula? | 19 May 2008 21:12 GMT | 1 |
I have a formula that I use several times a day in various workbooks. The formula is always =(I2&" "&J2) written in Cell K2. I created a macro, but it keeps tying to the workbook. I want to create a button that will automaticly type this formula no matter the workbook I'm in. ...
|
| Match 3 columns to one cell | 19 May 2008 20:57 GMT | 5 |
I have 9-digit account number in the first 3 columns (from A4:C65002) that I am trying to verify if the number that I have in range D4:d54. I am trying to use the match function to perform this, but apparently the match function will NOT match between 3 columns only one column.
|
| Indentify Shift number in 24 hour period | 19 May 2008 20:46 GMT | 5 |
Hi all, I am trying to find a way to identify the shift of a particular time without the date. For example the shifts start at these times: 1 22:30 2 06:00
|
| Excel - Formula/Programming | 19 May 2008 20:08 GMT | 1 |
I have a list that is sorted by a date and a true/false cell. I would like to have these columns moved to a new sheet (which would be labeled "old") based on the date and the value of the true/false cell being "true". For example, if a column's row cell date is 1/8/05 and another ...
|
| Condtional formatting on 2 separate dates | 19 May 2008 20:03 GMT | 2 |
I have a spread sheet that conatins hire dates in one column (A) and termination dates in a separate column (AU). I want it to highilght the date in column A if there is a termination date in column AU. Or even highlight the name of the employee in column F if there is a ...
|
| creating a combo box that shows multiple entries. | 19 May 2008 19:27 GMT | 1 |
I have an address list in one worksheet. I have a form in another worksheet where I want to place a combo box that will allow me to select the person's name and then fill in all the other columns with their address, phone number, city, state, etc, on the form. Another vaariation ...
|