| Thread | Last Post | Replies |
|
| Using v-lookup with multiple identifiers | 01 Jul 2008 00:34 GMT | 2 |
I am trying to get results from a vlookup table but I have multiple identifiers with the different results. E.g. EMPX Amount
|
| Complex IF formula | 01 Jul 2008 00:18 GMT | 4 |
I have a tiered fee schedule and I'm trying to calculate an IF formula to capture the different levels. Here are my conditions for an account balance example: My Account balance is $1000 (C1)
|
| Page Breaks in 2007 | 30 Jun 2008 23:17 GMT | 2 |
Is there anyone you can hide the page breaks when youre working on a file?
|
| Use a cell to name a file to be opened. | 30 Jun 2008 22:36 GMT | 3 |
I want to use the contents of a cell as part of an INDEX lookup. The contents of the cell would indicate the name of the file I want to open. Any ideas?
|
| VLOOKUP Macro? | 30 Jun 2008 21:54 GMT | 3 |
I'm not sure what to use to get this result but here's what I'm trying to do: My column L is a Total column that contains this formula (starting in L6): =IF(C6="Mileage", 'Mileage Personal Auto'!$G$56,IF(C6="Bus. Meals & Ent.", 'Business Meals & Entertainment'!$G$56, ""))
|
| FIND and dates | 30 Jun 2008 21:44 GMT | 1 |
I have several large spreadsheets in 2007, each containing many columns of numbers, dates, and text. When I hit CTRL F and type either a number or text in the box, it's found immediately. When I try dates, "...cannot find the data..." pops up.
|
| Excel 2003 Graphs | 30 Jun 2008 21:05 GMT | 1 |
How can I add percentage to my Pivot Table graph of data? Is it possible to add additional data from another column to my graph? I will provide a screenshot in a word.doc to whomever responds so you can have a visual of what I'm talking about. I know that it is hard
|
| Macro to Print | 30 Jun 2008 20:08 GMT | 1 |
I have 50 excel files with multiple sheets. I would like to print only the tab that says cover letter, which is not at the beginning of the workbook. . Is there a macro that could do this. Any help will be appreciated.
|
| Time Formula | 30 Jun 2008 20:06 GMT | 3 |
Is there a formula that displays the current time? Now displays the date and time.
|
| Sorting | 30 Jun 2008 19:40 GMT | 4 |
I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie).
|
| Filter and Delete | 30 Jun 2008 18:57 GMT | 6 |
Is there a way to delete filtered rows without deleting the unfiltered rows.
|
| Filtering based on wild card values | 30 Jun 2008 18:46 GMT | 3 |
I have a list of IP addresses, over 30K records. I need to filter out those records which meet specific IP range i.e. within: 3.xxx.xxx.7 3.xxx.xxx.71
|
| EXCEL 2003 Export Issue | 30 Jun 2008 18:26 GMT | 1 |
Hey guys: I am suffering this annoying error while trying to export Infoworks Reports to Excel. Basically while I click the Button'Export to Excel' Nothing happened, and if I select the 'Export to Excel'function from the dropdown
|
| Calculating Max & Min in a negative numbes | 30 Jun 2008 18:09 GMT | 6 |
i Have a worksheet with these number, when i select maximum from this list below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94
|
| Using dialog box | 30 Jun 2008 18:01 GMT | 2 |
I have 37 major categories that have 2 to 10 sub-categories for each major. I am trying to create a dialog box that will use a “Combo Box” to list the major categories (was successful), and then use the data from the major to output the Sub-categories in “List box”.
|