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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro Question25 Aug 2006 19:40 GMT1
I am using this:
Sub Macro8()
   Range("G6").Select
   Selection.Copy
wrapping text and vlookup25 Aug 2006 19:24 GMT4
Bit of a strange one this, I have a vlookup formula that returns long text
strings. I'd like to have the cells wrap the text when necessary, however
excel won't apparently allow this to happen - with the wrap text box checked
the text doesn't wrap. Does anyone know if this is a ...
How do you suppress duplicate lines?25 Aug 2006 19:13 GMT4
I am combining mailing lists from different sources and I need to delete any
duplicate entries, is there an easy way to do this in excel?
Aladin...HELP!!!  Running Averages of last 10 data entries, excluding blank cells25 Aug 2006 18:55 GMT2
I have a worksheet that I am trying to calculate the a rolling average
of the last 10 days of activity for manhours/tons of steel.
Each worksheet is 1 month of data
Row 1:  I have days of the week
how to merge many cells to one cell with keeping all data25 Aug 2006 18:51 GMT4
I meet a question about following.
in A column, there are many data(some data are same), and in B column,
there are many relevant data, but they are different, how to merge all
the revelant data to one cell in B column with the same in A column,
Annualized rolling (moving) average25 Aug 2006 18:45 GMT2
I am using the following formula to calculate an average of data for a
rolling 365 day period.  Column A is the date, column B  is Data
=((SUMPRODUCT(--($A$1:$A3<$A3),--($A$1:$A3>=$A3-365),($B$1:$B3))))/(SUMPRODUCT(--($A$1:$A3<$A3)*--($A$1:$A3>=$A3-365)))
Is there a simpler way to ...
DMAX wrong calculation25 Aug 2006 18:43 GMT3
I am using Excel 9.0.7616 SP-3.
The calculation is very simple =DMAX(H3:H18,1,H3:H18), even though all cells
in that small database have numbers the result says "0". All those cells have
different formulas to calculate values from another cells. If I remove all
Configured cell that looks like a combo box.25 Aug 2006 18:35 GMT3
I have a sheet that I am trying to edit that was created by a person that is
no longer with my company. The cell looks like a regular cell until you click
on it and it opens up a list with a scroll button. I have tried to edit the
cell so that I can place more items into the the ...
Insert spaces in String of Numbers25 Aug 2006 18:32 GMT1
Hello, I have a series of 16 numbers and would like to insert spaces or
dashes.  Is there a formula that can be used to accomplish this task.  My
number appears from the report as: pp234567890123.  I would like
pp2-345-678901-23. Thanks for your time.
month formula25 Aug 2006 17:54 GMT3
A question - if I type in the date 14/12/2004 and in the column next to it
use the month formula with the cell format set to general it correctly
returns 12. However if I want it to show say Dec I went to custom typed in
mmm and it always returns Jan.
12ths denominators for fractions in Excel (for pension calcs)25 Aug 2006 17:13 GMT1
As a pensions administrator, I use Excel to display pensionable service in
years and complete months.  The ability to express service in terms of years
and twelfths of a year would be useful.  This is not one of the options for
fraction formatting.
Searching for a value in an Array25 Aug 2006 16:53 GMT16
I have a master price list were I have in column A the country name, and in
column B the machine model number and in column C the price.
Obviously you can find the same machine for many countries with different
prices, I need a formula were I can extract for a certain country the ...
How do I apply conditional formulas across multiple columns?25 Aug 2006 16:49 GMT2
Say my data set looks like this:
A         B          C  
Molly   April      Candy
Sally   April      Candy
Rows to repeat at top... ON SCREEN25 Aug 2006 15:21 GMT3
I have a spreadsheet formulated to print the repeat rows at the top.
I want them to show on my screen so that I know which column that I am
typing in.
Is this possible?
HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?25 Aug 2006 15:17 GMT1
I have a spreadsheet with calculations that may result in a zero balance.  
How do I automatically delete all rows with a zero balance?
 
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.