Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Cutting and Pasting with spaces25 Sep 2007 20:32 GMT1
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 update25 Sep 2007 20:32 GMT2
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 200725 Sep 2007 20:20 GMT3
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 Employees25 Sep 2007 19:54 GMT2
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 GMT7
(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 work25 Sep 2007 19:32 GMT2
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 Loss25 Sep 2007 19:28 GMT2
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 spreadsheet25 Sep 2007 19:25 GMT3
following the help instructions to move a column:
 - right click column to move
 - cut
 - right click column to insert before
Printing with restrictions - VB25 Sep 2007 19:14 GMT9
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 formula25 Sep 2007 19:12 GMT5
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 GMT3
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
Excel25 Sep 2007 18:31 GMT2
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 date25 Sep 2007 18:28 GMT4
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 dates25 Sep 2007 18:14 GMT4
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 column25 Sep 2007 17:38 GMT3
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 ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.