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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Use of offset and match functions with changing arrays, I think???15 Mar 2006 18:17 GMT2
I would like excell to look for at the text value in column A and if that
value exists else wear in the spread sheet in column A, I would like it to
return the value that is in the same row in column B, exculding the value
being test for, in column C. If the value occurs twice I ...
How to calculate an age?15 Mar 2006 17:46 GMT4
I need to calculate ages as of 8/1/06. How can I do this if I enter the
Birthdates for each participant?
other workbook does not appear in the drop down box when I attemp.15 Mar 2006 17:42 GMT3
I attempted to move a worksheet from one workbook to another, but when I
attempted to select the "To Book:" in the drop down box, the only workbooks I
had to choose from were the current workbook and a new workbook.  The
workbook I desired to send the worksheet into was open.  ...
Sumif Cells Are Not Blank15 Mar 2006 17:40 GMT12
I'm looking to total a range of cells ONLY if they have a value of 0 or more
entered in them.  In plain english:
Sumif A1 is >=0
Sumif A2 is >=0
Count text cells based on two criteria15 Mar 2006 17:36 GMT2
I have a spreadsheet with many columns.  I would like to count how many
occurances there are of two criteria matching.  Example, If column A contains
names of girls (amy, betty, susie, karen, betty) and column B contains names
of boys (michael, robert, andrew, james, joseph).  ...
How can I label a worksheet based on a cell in Excel?15 Mar 2006 17:31 GMT4
I have a workbook with multiple worksheets and would like to know if there is
a way to label each worksheet based on info in cells on the first worksheet
of the workbook.
Don't know if this is even possible.  The labels for the worksheets would be
msgbox / inputbox etc15 Mar 2006 17:28 GMT2
I'm using a vlookup formule to translate names into codes in a really big
excel sheet.
The problem is that if there are two time the same name, the system will
take the first code to translate the name without warning me. It can happens
Conditional Format15 Mar 2006 17:24 GMT5
Can this be done with a conditional format?
Data in columns A thru C.  I would like the highlight the cells in column C
where the same data exists in either columns A or B.
For example, Cell C5 has the number 75.  If any cell within columns A or B
how to count unique values in excel based on multiple criteria15 Mar 2006 17:00 GMT3
I need to count and sum a worksheet of over 10,000 rows based on
multiple criteria.  1st is by the employee name, second date range,
they other is product type, but for this example i doubt three is much
different than two criteria's.
create macro - if cell is 0 delete row15 Mar 2006 16:55 GMT1
Is there a way to create a macro that will search a section of a worksheet
and delete rows that have a zero in the leading cell?
Thanks in advance!
Need help with writing a formula15 Mar 2006 16:51 GMT1
Hi, I'd like some help in writing a formula in column C.  The objective is
to lookup or to match the city on column D and E, if it matches, enter the
rate.
Thank you for your help
How do I repeatedly find text in an Excel sheet?15 Mar 2006 15:40 GMT1
Need to find text in an excel sheet. CTRL+F will only work once.  When I try
again for text that is cleary there it doesn't respond.
Adding data from another sheet15 Mar 2006 15:31 GMT2
I have two sheets:
- sheet 1 contains: name; first name; number;....
- sheet 2 contains: name; first name; number; birth date....
All persons that are in sheet 1 are also in sheet 2 (but not vice versa).
Highest & lowest place value / decimal places of cell value15 Mar 2006 15:27 GMT2
Hi! Does anybody know of a function/series of functions that could determine
the upper & lower place value of a cell value?
E.g. the highest place value used in 123.4 is the hundreds column, and the
lowest is the tenths column. Whereas the highest in 12.34 is the tens column
Count function15 Mar 2006 15:21 GMT2
I currently have an array function to sum revenues from a list of customers.  
Is it possible to count the number of customer associated with these revenues?
The formula I am using is:
{=SUM(XXX!$BX$5:$CC$13390*(XXX!$CC$5:$CC$13390=0)*(XXX!$CB$5:$CB$13390=0)*(XXX!$CA$5 ...
 
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.