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 / New Users / July 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel range selection as if dragging, keyboard not responding22 Jul 2007 15:26 GMT1
I open an Excel file - I click on a cell then nothing - it just selects a
range of cells whatever direction I drag the mouse to.  Keyboard does not
respond, can't exit out unless I do CTRL-ALT-DEL.  How do I fix this?  Thanks.
Days, Hours and minutes22 Jul 2007 14:50 GMT3
I currently have a lump of data that is reporting back to me a 10 digit
number.
I have no idea where the number started (When) but I do know that the
increments are in seconds.
Database query and parameters22 Jul 2007 14:20 GMT1
It seems to me that the following things are true:
1. You cannot base and Excel query (using "Microsoft Query" at Data |
Import External Data | New Database Query) off of a Microsoft Access
query, if the Microsoft Access query has parameters.
Sumproduct and dates22 Jul 2007 13:54 GMT5
=SUMPRODUCT(--(SPRING4!N2:N1549<="1/31/07"),(SPRING4!M2:M1549))
Above is my formula that I can't get to work with dates. I want to sum the
M2:M1549 based on the date column of  N. What am I doing that is wrong? The
date column is formated as mm/dd/yy.
How do I make a web query file to download stock data?22 Jul 2007 13:10 GMT1
I just got Excel and would like some help in making a file which would
enable me to download some info from the stock market i.e. option prices. I
would greatly appreciate any help anybody can give me. Thanks.
Search actual Formula for cell ref?22 Jul 2007 11:55 GMT3
Other than using Find from the Edit menu, is there any way of (using
formula) searching another formula for a certain cell reference?
Let's say I have a single column (B) of 100 similar formulas.  I want to
check that none of the formulas contain a reference to column H, so want
Sequential numbers in a formula?22 Jul 2007 11:52 GMT2
I have a few formulas (OFFSET & MATCH) which are the same (with relative
references chanfing accordingly) and occupy cells B2:B500.  In each
formula one of the function arguments refers to a single cell in the
adjacent column i.e A1:A500 which contains the numbers 1 to 500 (and ...
Centre Across Selection oddity22 Jul 2007 11:28 GMT2
Sometimes when I use 'centre across selection' to centre horizontally
across more than one cell, if the cells in question have an outside
border, the right-hand border often disappears when the left-most cell
contents are centred across the selection.
Find/Found22 Jul 2007 06:26 GMT2
Can not get Found to respond. Object: Get PersonName in Sheet2, Go to
Sheet1, Find PersonName. If Found put PersonName & address into Sheet2
Else put PersonName in Sheet3. Sheet2 has no address. Sheet1 has most,
but not all names that are in Sheet2
excel 9522 Jul 2007 02:16 GMT7
Where can I get Excel 95. I need it load my old old SuperCal
spreadsheets. My new ver of Excel can't handle it....
Thanx
Hanz
Compare two file/colunms, hide row not does not equal list.21 Jul 2007 23:54 GMT3
Excel 2000 -have two files. File "A" has 1 through 4155 records (rows with
three columns) in numerical order. File "B", has a list of almost 200
rows/numbers (one column) from file "A". How can I hide the rows in file "A",
not are listed in file "B"?
Merging cells21 Jul 2007 23:11 GMT8
We have many excel spreadsheets that we use to track employees.  My company
just recently transfered the info from Word to Excel.  I am new to the
company and fairly new to Excel.  We have decided to merge the name cells
from two to one (one cell-first name, one cell-last name).  ...
Are there any excel template for creating POIs for Garmin units21 Jul 2007 22:00 GMT1
I'm looking for a template in which I can create points of interest for a
Garmin 340c.
find first empty cell in column and start transpose next row in that cell21 Jul 2007 18:56 GMT3
I have the following code to transpose one row into column without
blanks and zero's.
Dim lastcol As Long
Dim ws As Worksheet
search and return cell count21 Jul 2007 17:51 GMT1
I have a list of dates. (certain dates are excluded).
I need a formula that would perform like a datedif and lookup formula.
Using two cell references, I need to be able to count the number of
cells (dates) between the reference points in a formula. Sort of like
 
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.