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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
count and return pair numbers28 Jul 2007 16:51 GMT14
What function can I use to return the number of pair or impair numbers in a
row
              A    B   C    D    E     F  
Row  1      2    6   9   11   16   20              Pair number = 4    
Finding the earliest date from a range of cells28 Jul 2007 16:46 GMT2
>From a range of cells in multiple columns with dates I am trying to
get the earliest date listed in my summary row.
I have managed to do this using the MIN function however I am having
two problems with this, if the users have entered text in these
How to auto update a spreadsheet with data from a .xls file?28 Jul 2007 15:24 GMT1
I am saving a banking statement to a file in xls format and want to be able
ot open the spreadsheet and have the data already loaded.  Also, I would like
to keep appending the file that the banking statement is saved to if you have
any ideas on that.
First day of month28 Jul 2007 12:42 GMT7
A cell in an Excel workbook contains a date.  I want to write macro code to
generate, in another cell, the date of the first day of the next month.
I was going to use the Excel EOMONTH function, but Excel 2002, does not seem
to support the function. I can generate the date using ...
insert images in a protected worksheet28 Jul 2007 11:31 GMT10
hello..
please help me..
How do i insert an image in a protected woksheet?
thanks
seperating data from one cell to multiple cells?28 Jul 2007 10:27 GMT5
I have a worksheet open that has 250 rows of data, all the data appears in
one cell and is seperated by commas, can anyone tell me how I can get excel
to seperate the data divided by commas into individual cells, having seperate
columns?
Finding the earliest date from a range of cells28 Jul 2007 06:50 GMT1
>From a range of cells in multiple columns with dates I am trying to
get the earliest date listed in my summary row.
I have managed to do this using the MIN function however I am having
two problems with this, if the users have entered text in these
Function refering sheet index.28 Jul 2007 05:27 GMT4
I have some 100+ sheets in a file.
in the first sheet I want get a consolidated information.  say count
the entries in column-D.
how can I write a funcion indipendant of the sheet name.
Combining worksheets with common column but different number of ro28 Jul 2007 04:38 GMT3
I have two excel spreadsheets, one that is complete with product part
numbers, item descriptions, prices, quantity, photo url's, etc.  I get a
daily update in the form of a spreadhseet with part number and quantity only.
Is there a way that excel can recognize that column A in ...
How do you calculate a negative percentage28 Jul 2007 04:31 GMT2
Sorry if this is a dumb question...
All I am trying to do is calculate the difference between two numbers, as a
percentage.  I tried what the "help" suggests of "=(D4-C4)/ABS(D4)" yet the
percentage is off by a few points (not just rounding errors) each time.  I
Date issue28 Jul 2007 04:22 GMT3
Writing a function in Excel 2003 that starts"=IF(<11/30/2006..."
When run the function returns a false result, however if the date is entered
as "=IF(<39093", the "serial date" that Excel uses it returns a correct
result. Shouldn't the function be using the "human friendly" date ...
negative and positive sums28 Jul 2007 03:12 GMT8
How do I create a formula that subracts A1 from A2 if A2 is a negative
number, but adds A1 and A2 if A2 is a positive number?
Thanks for your help
vba28 Jul 2007 01:40 GMT3
does anyone no how to answer a proposed question like this. I was
looking through some old papers for next years module in this. As im
doing this as a module on my course and I want to get a head start in
understanding how to write this in essay formats.
Grades in Excell 200728 Jul 2007 01:32 GMT1
I have a grade column with daily activities and homework averaged.  I want to
take that average and show it in a letter grade based on accumulated points.  
What should I do?
Formula to determine selling price with cost known @ X margin?28 Jul 2007 01:16 GMT3
I'm trying to create a formula in Excel to project a selling price of a
product using the margin I wish to make as the variable. Any help would be
greatly appreciated.
Thanks.
 
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.