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 / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Help Excel Formatting07 Jun 2007 20:03 GMT1
I have a word document that I want to convert to an excel file, that
looks like this:
Product:    Apple
Price:       $1.00
formulas appear in cell as entered..07 Jun 2007 18:52 GMT3
whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula
just appeared as normal text, displaying exactly what I typed in.
how can I get it to work?
I do not think this is due to the manual calculation update option, as it
Finding missing values in a column07 Jun 2007 18:45 GMT1
I'm looking for a way to automaticaly find missing values in a column of
numbers. Here's an example (all values are in the same column):
50
51
Need Help Creating a Macro Multiple Workbooks to One07 Jun 2007 18:20 GMT1
HI I need Help Creating a Macro for my job!
We currently have two workbooks, one has multiple worksheets containing
invoice information. The other has one worksheet containing all of the
information of the other workbook.
Formatting Cells?07 Jun 2007 18:19 GMT2
I need to know how to put an * before and after each value I have in a
column.  For example, if Column A is 1 to 5, I will paste them in B, and then
change them to barcode font.  My scanner only reads barcodes that start and
end in an * .   It is easy to do it for a few by hand, ...
Dispay two values in one cell with the / border separating them.07 Jun 2007 18:12 GMT2
Is there a way to display two values in one cell with the / border separating
them?
how can i make a list of numbers automatically07 Jun 2007 18:09 GMT1
i'm trying to make a calendar for a project and would like the 'fill handle'
button to automatically correlate the numbers. anyone could let me know how
to do that? sometimes it happens automatically but other times it doesn't
seem to work
Help with Hlookup/Vlookup and Lookup. From multipul sheets07 Jun 2007 17:53 GMT1
there are a total of 2 sheets that I am working with. I would like to lookup
a value on sheet 1 and corespond with anothee value on sheet 2 and then take
the value parallel to that in sheet 2 and input that value in sheet 1.
then I would like to frag down the function so I do not ...
unable to see postings after 6/5/0707 Jun 2007 17:24 GMT1
I am unable to see postings after 6/5/07 on discussion lists and have been
notified of replies. But since I can't see anything after 6/5, I can't see
them. Please respond to this email so that I can fix this? No one from our
organization can see after 6/5 either, so I don't know ...
Sum of Column with next column containing specific word07 Jun 2007 17:12 GMT2
Here is the situation:
I have a spreadsheet I am using for a timecard, in column Q, rows 18-31, I
have a spot for employees to type in their "other" hours. In Column R in the
same rows I have a spot for them to choose from a drop down what type of
SUMIF Conditions07 Jun 2007 16:34 GMT3
=SUMIF($F$6:$F$2000,$O8,$G$6:$G$2000)*AND($M$6:$M$2000<=60)
this function ignores the AND statement.....Please Help
Thanks,
Adam
HOW CAN I MAKE AND OR ADD NEW SYMBOLS TO THE LIST?07 Jun 2007 16:28 GMT1
I WANT TO ADD BIM PICTURES OR DRAW HEM MYSELF.
IF..THEN..ELSE07 Jun 2007 16:11 GMT9
=IF(ISBLANK(I2),X2,I2)
If both I2 and X2 are blank I get 0 (zero)
What I need is a blank cell
How do I modify the formula to get the desired results.
Conditional Average07 Jun 2007 16:03 GMT1
I have many columns of information.  And I want to average the information in
one of the columns based on a certain value appearing in another column.  I
am using Excel 2002.  In example below I would like to average the numbers in
column 3 if its associated number in column 1 is ...
Filtering diverse values07 Jun 2007 15:56 GMT1
I'm trying to filter out diverse values in a column
Assume:
A1:A5 = Name1
A6:A10 = Name2
 
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.