| Thread | Last Post | Replies |
|
| Cutting and Pasting with spaces | 25 Sep 2007 20:32 GMT | 1 |
I have a sheet that is roughly 10,000 rows long. In columns A-F I have data. In columns G, H, and I, I have summary counts of that data in 3 categories. The summary data in G, H, and I is separated by about 200-300 rows at a time. Is there any way to cut out those columns, ...
|
| One out of 15 computers/users VERY Slow after SP update | 25 Sep 2007 20:32 GMT | 2 |
In adding a new version of CRM to our users, one computer required a SP update. Ever since I did the service pack update, the one user/computer's ACCESS database (from our server) is VERY slow. Any ideas?
|
| Filtering times in Excel 2007 | 25 Sep 2007 20:20 GMT | 3 |
I have a list of times, automatic data was taken every 15 seconds (I have over 5,000 rows of data). I need to show only times that end in 00, so a whole minute. Column A
|
| How to Test Terminated Employees | 25 Sep 2007 19:54 GMT | 2 |
I have 2 spreatsheets. Sheet #1 has the list of current employes with their names, ids, dept, etc. Sheet #2 has list of terminated employees with their names, id, date of termination, etc. I want to ensure that there is no terminated employee on the current employee list ...
|
| How to count dates with multiple values? | 25 Sep 2007 19:47 GMT | 7 |
(Excel 2003) I have dates in a column. Some days from start to end are missing and some show up multiple times. I just want a count of how may days are in the list without counting the same date more than once or counting dates that are not
|
| VBA sort does not work | 25 Sep 2007 19:32 GMT | 2 |
i have code below to sort a range in my worksheet but it doesn't work however i can sort it by manually Sheets(1).Range("A" & Trim(Str(strt)) & ":Q" & Trim(Str(endd - 1))).Select
|
| Excel Tracking Win Loss | 25 Sep 2007 19:28 GMT | 2 |
Have a table with two columns for: "Points For" and "Points Against". I want to have in a different table on the same worksheet to calculate their record when I enter the points over the eight games. Wondering what formula I need to enter in where "wins" and ""Losses" are to be ...
|
| cannot move a column in my spreadsheet | 25 Sep 2007 19:25 GMT | 3 |
following the help instructions to move a column: - right click column to move - cut - right click column to insert before
|
| Printing with restrictions - VB | 25 Sep 2007 19:14 GMT | 9 |
Hello again, I looking to do the following; if cell A1, B1, and C1 are blank (no data) then do not allow to print sheet. Given an error and indicate what cell(s) or name of cell(s) needs to be filled.
|
| Run Macros from an IF statement within a formula | 25 Sep 2007 19:12 GMT | 5 |
mIS there anyway we can activate a macro from within a formular for exaple if cell A1 ="" then run Macro?
|
| using OFFSET(INDEX(MATCH))) | 25 Sep 2007 18:44 GMT | 3 |
I have the following formula: =OFFSET(INDEX('Capital Summary'!F$25:F$28,MATCH(A4,'Capital Summary'!F $25:F$28,0)),,1) This works fine, however, when I remove the OFFSET(...) part and just
|
| Excel | 25 Sep 2007 18:31 GMT | 2 |
How do I deselect some portion in a range of cells without deselecting the entire range and reselecting the desired cells?
|
| Adding 5 yrs to a date | 25 Sep 2007 18:28 GMT | 4 |
How can I add 5 yrs to an existing date using a formula? Current Date Desired Date 09/25/2007 09/25/2012 Thanks for your time....
|
| anniversary dates | 25 Sep 2007 18:14 GMT | 4 |
How do I get a date in the past (column a) to show as a due date this year in column b? i.e. if they joined the company on 3-dec-98 then I want the next column to automatically say that their appraisal is due on 3-dec-07. THANKS
|
| Lookup a value from one column | 25 Sep 2007 17:38 GMT | 3 |
I have a column A1:A91 that is full of serial numbers in a worksheet called "Canadian Machine Watchlist" that i want to compare to another worksheets serial numbers and return "Failed" or "OK". The second worksheet is called "Replacements" and the range i want to look in is F4 ...
|