I have two sets of data with the same information but not in the same order
and am trying to match the data.  In each data set I have 10 pools containing
100 loans.  Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100.  I need to look up the ...

   Can some one please help me?
Is there a formular that will take the info off cell b6 sheet 1 and put it
into cell e8 sheet 2?

I have created a report using VBA and Excel OLAP cube. Some of the
metrics on the report are currency numbers and are to be reported in
USD so I have formatted them accordingly using format ( e.g. "$
#,##0.00"). Some of the users in Germany who use decimal (.) as

On my computer at work I have the default font set for a True Type font
called Arial Terminal.  It's a fixed width Arial font that I like for
spreadsheets.  I've changed it in Tools > Options > General.  But when I
open Excel, the font is set to regular Arial, the proportional ...

Is there any way to zoom more than just 2 states (in and out) in an Excel
2003 preview? In so many programs there's a % option but not in Excel. Very
sad indeed and very frustrating. I'm wondering if there's some hidden
setting that I don't know about.

I have a cell which ontains an IF function. I want the cell to remain empty
unless the IF returns a certain value. I know how to use IF, but how do I
make a cell 'empty' ?
Thanks

It seems as if my bottom of the cell outline is not repeating on subsequent
pages. I have a few header rows on a sheet. The bottom row has a bottom
line. I'm talking about cell outlines, not underlining of words in the cell.
Anyway, I've told the print option to repeat the first 3 ...

My spreadsheet looks like this:
    Column D
    value1
    value2

Any pointers would be most appreciated.  I'm wanting to create exams online
and have been told Excel will do this.  For instance 20 questions with each
question having to choose the correct answer from a number of possible
answers.  I want whoever to go through trhe 20 questions and ...

I know i can rank a column of numbers from largerst to smallest.
Can I use rank for smallest to largest? Any help appreciated.
Skip

Just got my new Office 2007 Suite of applications.  One reason I wanted the
new Office is that I work with large data files and the capability of 1
million rows and a lot of columns will help me.  Unfortunately, I just tried
to combine 2 large worksheets that totalled more than ...

Anyone know how to convert a PDF file to an Excel 2007 file? Need help.
Thanks

I want to use data validation on a cell where the user MUST enter any
four digits, leading zeros are permitted.
Can someone explain how I do this?

select a cell with a number, then (ctrl) select other cells with numbers...
the sum of the cells should display at the bottom, with each additional cell
that you select... how do i set this up/do this???

I'm stumped.  I know you can't do an HLOOKUP if you're not starting at
the top of the range.  I have a worksheet (called "Data") that
contains 3500 rows of data.  There are multiple "departments" within
this data.  I want to be able to look up a specific "department" and