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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Unable to remove objects pasted into Excel from HTML grid22 Jul 2006 19:59 GMT3
Copied & pasted an html page into Excel. Has little check boxes that will can
be checked, but not removed.  Can't grab them, deleting columns or rows just
moves them over by one.
Any idea how to get rid of them?  Would like to keep the rest of the data.  
How do I re-calculalate the values for all cells in a column22 Jul 2006 19:47 GMT2
I'm a newbie to Excel worksheets however, I'm very familiar with Access.  
However, I need to change data in an Excel worksheet and I'm clueless where
to start.  For Example, I need to change the value of all cells in colum 3,
for all rows with data by -5, what would the formula ...
excel should allow me Indian number grouping ##,##,##,###.##22 Jul 2006 19:46 GMT3
Excel does not have grouping for numbers used in India.
we need the described grouping for everyday use as we dont use millions
grouping
----------------
Conditional Formatting22 Jul 2006 19:42 GMT2
How do I highlight any cell in , say, A1:M1 that is equal to the maximum
value in that range.
Thanks
Bertrand
If and nested Sumif error22 Jul 2006 19:25 GMT4
I am trying to automate my bank reconcilliation programme,
Column F = Receipts
Column G = Payments
Column I = Current Balance (book Balance)
Calculating correct pecentages with negative values22 Jul 2006 19:12 GMT4
I need a formula that will return the correct percentage where there is 4
scenarios of comparing Actuals as a percentage of  Plan. eg
Actual        Plan
110            100
is there a function for this?22 Jul 2006 17:36 GMT1
Can someone help me with the following?
My spreadsheet looks like this
                   term ins      whole ins     variable life      total
points
Syntax to "OR" 3 "ISERROR" conditions22 Jul 2006 16:18 GMT6
Oh Wise Ones,
                     I would like to filter the conditions of 3 columns for
errors and evaluate in a fourth.  I need a null value not just a white font.  
I've played with the OR syntax and nothing works. Any ideas please?
numbers to characters22 Jul 2006 15:37 GMT1
I have a spreadsheet that is externally linked to a query.  In  four
colums are phone number information - area code, number, fax area code
and fax number.  When the data is imported, some of the fields are
zero.  I can format the column that if it's zero to show blank by
Need Help with Formula22 Jul 2006 14:35 GMT2
I'm trying to create a formula that sums a number of cells (in column "L") IF
the corresponding cells in column "A" are the same.  For example:
 Company  Product  Value   TOTAL
1   A Co.       1          100      100
Drop Down selecting worksheet22 Jul 2006 13:25 GMT1
Hi, I'm, trying to create a drop down list that by choosing, say a country,
will tell the workbook to send the data I type later to a specific sheet,
called Denmark etc.
DropDownList must be on the first sheet, called index which only is used to
Updating a Date in a Graph Header Field22 Jul 2006 13:03 GMT1
I would like to have the header on a graph update the date when I
update the spreadsheet. For example, The header reads: "Payments by
Category - August 31, 2006" but the next month when I update the data,
I want it to read: "Payments by Category - September 30, 2006". Can
How to copy data to the next empty cell in a column22 Jul 2006 12:35 GMT2
I need a macro that does the following: copy the data from cell A1 in
worksheet1 to the next empty cell in column A in worksheet2. Can
anybody help me?
Thanks...
Return last cell that contains a particular value22 Jul 2006 11:39 GMT6
The scenario:
I have a spreadsheet to track my stocks.  Each stock has its own worksheet
with the stock symbol as the worksheet name (ie IBM).  I also have a
worksheet that summarizes all the individual sheets.  On the individual stock
common numbers in 2 columns22 Jul 2006 10:11 GMT5
I have two columns of numbers. One is a large list with say 3,000
random
serial numbers. The other is a smaller list of 800 serial numbers. I
want to
 
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.