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 / August 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Selection.Value = ARRAY Limit?22 Aug 2006 00:13 GMT1
I'm at a loss and I'm hoping someone could help.
Dim IA_Array(659, 229) As Variant
'In the code - I load this array with values
ActiveSheet.Range("E11:IQ660").Select
Sort Data Base By Column21 Aug 2006 23:22 GMT4
I'd like to sort a data base by column C and have all the associate
date in the rest of the columns sort as well. How is that done?
Thanks for any help
Travelerswa
separating data into multiple columns21 Aug 2006 23:07 GMT1
I have a spreadsheet that lists people in the format LastName
FirstName.  I want to create a formula that will put the last name i
one column and the first in a different column.  Can someone pleas
point me in the right direction?  Any help would be greatl
WHAT ARE PARENTHESIS IN FORMULAS?21 Aug 2006 22:43 GMT2
I have a formula:  =(h24*j24)+(h25*j25)/sum(h24:25)
But I have no idea how many parentheses I am suppose to place around the
formula or what additional ones I need other than the one that surround the
indivudual formula.
Home Key - Excel 200321 Aug 2006 22:28 GMT2
In Excel 2003 is it possible to go to the beginning of a spreadsheet b
pressing just the Home key instead of Ctrl + Home. I'm sure that I use
to be able to do this in an earlier version.
Thank
Sequential Numbering21 Aug 2006 22:20 GMT4
I would like to know the formula for making a cell be able to do sequential
numbering such as for purchase orders.
How to convert Excel file to CSV Question21 Aug 2006 21:02 GMT1
I need to create a csv file from an Excel file.
I attempted to create one by using teh "save as" command. But when I do
the resulting document looks the same. I expected it to look like a
text file with commas separating the cells.
Validation Default Value21 Aug 2006 20:26 GMT2
I'm using a validation list to populate cell B7 on my worksheet.  The
choices on this list are dynamic and change based on the value in cell
H6.  Cell B6 then shows a VLOOKUP value based on the contents of cell
B7.
Convert to time21 Aug 2006 20:00 GMT12
How would I go about converting 8.00 to 8:00:00 AM in excel.
Can this be done?
Excel General21 Aug 2006 19:20 GMT1
If I have two columns of numbers in an excel spreadsheet is it possible
to put in some formulae or some other function thatlist out the common
numbers in both the columns. Basically I need to eliminate the #'s in
column A that figure in Column B too.
Random 8 digit number?21 Aug 2006 18:29 GMT6
I need to know the formula to create a column of random 8 character ID
numbers, preferably with a set prefix of 3 numbers.  I'd be REALLY happy if
I could create it with random text and numerals, but it doesn't have to be.
(where 123 is the constant)
convert number to text21 Aug 2006 18:28 GMT1
how to :-
100 convert to One Hundred only
and
100.30 convert to One Hundred and 30 Cent onl
custom number format21 Aug 2006 18:23 GMT1
is there a way to format a number so that:
if there are decimal places, you see: 1234.56  (which includes the "."
character),
but,
Help! Error Message = No program is registered to open this File21 Aug 2006 18:20 GMT4
Fellow forum members:
I'm totally confused why all my Excel hyperlinks don't work and displa
the messages below everytime I select one:
"Some files can contain viruses and otherwise be harmful to you
Summing up data from various worksheets21 Aug 2006 18:17 GMT12
I have daily data all on different worksheets (31 in total) and I would
like to add up all of the data in these worksheets in a monthly
compilation
I have so far been using the =sum('jan. 1'!B6, 'jan. 2'!B6 ... etc.)
 
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.