| Thread | Last Post | Replies |
|
| formula to find all possible combinations | 12 Jul 2007 22:22 GMT | 2 |
Is there something in Excel 2003 to find all possible combinations of a set. For example if I have: Employee Spouse
|
| Inserting Buttons as Hyperlinks | 12 Jul 2007 22:19 GMT | 3 |
I need to create buttons on a spreadsheet that will be hyperlinks to email. But I need the spreadsheet to be sent as an attachment to the person from a list. So in short I need a button that will look at the name of the person and put in their email address and then email them ...
|
| find and replace units of a formula | 12 Jul 2007 21:02 GMT | 3 |
hopefully this is simple. I often want to preform a find and replace sections of a formula, say I want to change the reference column form A to D or something.. currently I have hundreds of formulas that are sum(G11:AD11) and I'm trying
|
| Making two lines into one | 12 Jul 2007 20:22 GMT | 3 |
Is there a way to combine row A and B into one row? For example, I have data in both rows. Both rows are for the same borrower. I am trying to combine row A and B into one row that has all the data both A and B had. I know I can cut and paste each line, but the spreadsheet is ...
|
| RANDBETWEEN in a conditional format gives error | 12 Jul 2007 20:02 GMT | 5 |
When I try to use the RANDBETWEEN function in a condional format (e.g., cell value = RANDBETWEEN(1,100)), I get the error message "You may not use references to other worksheets or workbooks for Conditional Formatting criteria." Why is it telling me this, and how do I get it to ...
|
| Macro that Finds the First Value in a range using a Combobox (drop down menu) | 12 Jul 2007 19:50 GMT | 2 |
I have a long list of countires and some info attached to them in a spread sheet. I want to add a drop-down menu at the top of the spread sheet that will go to the first cell in the column that contains that text. E.G. If I choose Peru from the menu I want it to go to that
|
| How do i display a negative time as a res of distracting 2 times? | 12 Jul 2007 19:37 GMT | 2 |
In a sheet about working time i want to extract two times. 1 is the normal working hours for the day 2 is the actual worked hours on a day If 2 < 1, the result is negative - I worked not enough hours on that day.
|
| If - then help. | 12 Jul 2007 19:32 GMT | 6 |
this one is too complicated for my brain, so I need help... I'll do my best to explain: I have 4 cells (A1, A2, A3, A4) A1 is a total dollar amount of a small section of a group of amounts
|
| Turn around Time | 12 Jul 2007 19:16 GMT | 2 |
Good morning, I have a workbook and my goal is to see when a number is no longer on the sheet. My workbook looks like this
|
| Using a single cell refernce to change multiple formulas | 12 Jul 2007 18:29 GMT | 5 |
I have created a table of suvey results listing multiple businesses each on a separate line with data from each business in columns to the right of each business name. For example:
|
| Dragging formulas | 12 Jul 2007 18:04 GMT | 7 |
Hope someone can help out here, please... Excel 2003: I have a list of columns (i.e. B8, C8, D8, E8 etc) that I want to copy down a row on another sheet.
|
| Conditional Format Formula Issue | 12 Jul 2007 18:01 GMT | 7 |
I am trying to use CF on a non-contiguous range of cells. I'm basically trying to tell it to place a top border on the cell if it is NOT the same as the cell above it. I have also tried only contiguous cells, with no luck either(and would certainly have no problems applying it ...
|
| How i display True/Fale in one or two colum | 12 Jul 2007 17:42 GMT | 2 |
How I can display True/Fale in a one or two colum, if colum A1 to A500 and C1 to C5000 have same amount. With a formula or Micro
|
| Converting embedded objects in excel versus word | 12 Jul 2007 17:34 GMT | 2 |
In Office 2000 SP3 there appears to be the functionality of being able to right-click on an embedded object in a word document and having a Convert option appear that will let you convert the file type, however this function does not appear to be available in Excel, is this the ...
|
| Nested IF Functions with OFFSET | 12 Jul 2007 16:18 GMT | 3 |
I am trying to use the following formula as an array (entering using CTRL+SHIFT+ENTER): =(SUM(IF('working sheet'!$B$4:$B$59998=$C14,IF(working sheet'!$J$4:$J $59998="D",OFFSET(working sheet'!B4,0,VLOOKUP(Summary!F12,working
|