I have a spreadsheet with three columns of data.  The first column is
labeled "Male", the second is labeled "Female" and the third is "Age".
Each row in the sheet corresponds to a caller.  So if the caller was a
female, we marked a '1' under female and then under 'Age' put the

Would be handy to have a formula or wizard for an amortization schedule.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

I did get a great reply to my problem the other day - but unfortunatel
I made a mistake in my explanation :/ - this is the prob:
if anything is in cell A1 AND in cell B1 then show "ok" in cell C1
if anything is in cell A1 and NOT in cell B1 then show "add order" i

sir i forget my Microsoft Excel files password tell me the solution plz this
is my very important file give me the solution

I need to capture rows of information from a worksheet, where the only
specific
identification in the row would be (say) a word "Hot".
I expect to have a quantity of rows of data (say) 20 rows, in one column

sir i forget my Microsoft Excel files password tell me the solution plz this
is my very important file give me the solution

Can anyone tell me how to sum a range of numbers in column D, provided that
adjacent cells in row A contain "Apples" and row C contain "Oranges".
Thanks
Alec

I am a teacher and trying to finally get rid off the dreaded
mark/attendance book by moving my recording proceedure to Excel.
I really really want to be able to set-up some form of validation that
allows me to select from several symbols to put against the pupils ie.

I need to copy data from a table into a template where both column and row
headers are the same only mixed up. If I do a vlookup, it will match one
column of data but I will have to apply the formula separately to each row
and vice versa. Here's an example of how it looks:

if anything is in cell A1 AND in cell B1 then show "ab" in cell C1
if anything is in cell A1 and NOT in cell B1 then show "a" in cell C1
if nothing is in cell A1 and IS in cell B1 then show "b" in cell C1
if nothing is in either cell A1 or B1 then show "ab" in cell C1

I have 60 000 datapoints in a colum. And I would like to reduce that number
to 3000 by averaging every 20 points. I tried using the average formula but
no success.
Any suggestions?

This ones more formatting related than formula but I didn't know where else
to put it.
Say I enter the value     c7454951000000cgvxx     I want to pre-format it
with predefined '-' after a certain number of characters.....

Dear everyone,
I have found today a very annoying bug today while working on Exce
2003, below is the thing, please advise your opinion as how should
troubleshoot the issue:

suppose cells A1toE5=grades A,B,C,D,E or U in any  combination and U=fail how
do I print "pass" or "fail" thanks in anticipation

I wonder if anyone has tried this before i have a large spreadsheet of
numbers which i need to find the most common numbers that appear in the
tabel so i am looking for a formula that will calculate one column at a
time.