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 / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Incrementing a formula by X number21 Sep 2005 16:14 GMT3
I have yet another one which I am sure most of you know the answer to.
To set it up, here it goes.  I have a worksheet named Results and in
this worksheet I have around 25,000 different numbers in the B column.
Out of all those, I want to get every 20th one and put that value into ...
Help21 Sep 2005 16:11 GMT1
I cannot update our price lists by say 10% without having to type each cell,
does anyone know how i can?
Comparing Two Worksheets21 Sep 2005 16:07 GMT5
I've got two worksheets of identical layout each comprising multiple tables
of numerical information.
Is there a way I can automatically highlight cells in one worksheet where
the corresponding value in the other worksheet is different.
In Excel 2003, under the File menu the Permission link is missing21 Sep 2005 15:56 GMT2
Some of our Excel programs on a couple workstations are missing the
Permission option that is found normally in the File Menu.
Conditional Formatting  Cell < Today()21 Sep 2005 15:43 GMT3
I always have issues with conditional formatting when I want to use
formula and pointing at the value of the same cell.
Here is the problem:
Due Date is in A1
repeat function???21 Sep 2005 15:27 GMT3
I know this is probably a stupid question, but a have a column that I want to
read
1
2
Cell phone tariff checker design help21 Sep 2005 14:19 GMT1
Hi Fred,
Thanks for your reply. The formula shown in this page
=IF(U20,0,0,SUM((A5)-(A5/A15)E3)*E5) is different to the one given in
my outlook express message which was:  
How do I insert a picture in an Excel comment block21 Sep 2005 14:15 GMT2
I am working in Excel 2003 and  want to be able to put text in a cell with a
flag/marker in the cell.  When the cell or flag/marker in clicked on a
picture would appear similar to the way insert comment block works. I would
appreciate any help.
Highlighting row from hyperlink?21 Sep 2005 13:57 GMT2
I'm new to conditional formatting in Excel, but I haven't seen this covered
already:  I'm hyperlinking a cell from one section of the workbook to data on
another sheet.  I would like to highlight the row of data that applies to the
hyperlink from the previous worksheet.  Can ...
enter numbers in blank cells21 Sep 2005 13:17 GMT2
I have a formula as follows,  IF(B2="DISTANCE",MAX($A$1:A1)+1,"")
this works great, but I also need to have the blank cells in between the
numbers filled in with numbers   eg:
I have                          need to have:
I want to put page no in a single sheet in excel while printing21 Sep 2005 13:09 GMT1
i want page number to be displayed on each page printed of single sheet like
we use to do it in word
How do you ignore hidden rows in a SUMIF() function?21 Sep 2005 13:06 GMT5
I would like to use the SUMIF function to sum all negative cash flows
(=SUMIF('Worksheet A - Info & Gross IRR'!EH5:EH2001,"<0")) in a given column
of data with hidden values (the data is in rows that have been hidden using
Autofilter and certian criteria).  I would like the SUMIF ...
sumproduct-can fill down change column reference?21 Sep 2005 13:00 GMT6
I have a worksheet that is using the sumproduct function based on
criteria on another sheet.  I need to use the same function in other
cells so I am using the fill handle to bring it down, but I want one of
the criteria references to change by column, not by row.
excel formulas21 Sep 2005 12:43 GMT7
I need to write a formula that if a cell on a worksheet contains a number a
cell on a different worksheet within the workbook returns a different number.
There are 5 different numbers - can someone help please.
Thanks in advance
Help!!!21 Sep 2005 12:27 GMT4
I have the following sample sheet:
W/c 12/9  Total Loads  Total Cases  Failure Loads  Failure Cases
12-Sep
13-Sep
 
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.