How can I paste data in inverse column order.   From col A to col B
Col A     Col B    Paste in B
1              4
2              3

Right now I'm using this formula:
=INDEX(Last_Inspection_Reported,MATCH(1,(Last_Inspection_Bus=$A4)*(Last_Inspection_ID="CV"),0))
This is repeated down a list quite a long ways. I only really need this
calculation every 12th time to avoid duplicate data, but I can handle

Try this out for yourself in a new worksheet:
Here is the required information:
A3: Type some text
A4-A14: 2101

I have time data that captures start and end times.  For these distinct
times, there is an if statement that evaluates whether these times occurred
in a certain time range.  For example, if start time was 8:00 am and end time
10:00 am, the IF statement would evaluate whether ...

I used the "add trendline" in Excel 2000 to do a 3rd order poly curve fit of
some data. Works great and I chose the "display equation" feature so I can
see the resulting polynomial coefficients, BUT, how can I automatically use
these coefficients in further calculations? Are they ...

How do I populate a cell using another worksheet as a reference?
For example, if Sheet1 looks like this:
    A    B    C
1     Part    Color    Price

I been poundering this for a couple weeks so far. I would like to get
this formula to across multiple worksheets.
=INDEX(Sheet2!$A$2:$A$9,SMALL(IF(Sheet2!$B$2:$B$9=C2,ROW(Sheet2!$B$2:$B$9)-ROW(A$2)+1),COUNTIF(C$2:C2,C2)))
So I tried to modify into this:

I've been trying to achieve the above now for a couple of weeks and I've got
nowhere. Please could someone help me?
I have a list of transactions in a worksheet which I need to automatically
count, both by AP and where they were made. I have a start date in cell O4

I have a timecard set up to calculate my par period hours, but can't figure
out how to take the total hours (say 68:00) and multiply it by the rate of
pay (say $20.00 per hour) and come up with the correct total pay ($1,360.00).
Here is how it is set up:

I have a variable in a UDF that is called cash()  ... this variable has 2,3,4
values based on the number of dates input into the function.  How do I get
all of those cash values to be output from my UDF?

I'm working on a checkbook Registry and need to figure out how to convert
text codes into names. Here an example
code      name
WA    =    Washington Mutual

I have a task that I have been doing by hand that is tedious and
inaccurate, and I am hoping a clever reader will be able to help me.  I
have several columns of data in an Excel table that I would like to
quickly analyze and determine were the differences are.  For example, I

I do not want to input duplicate data in any cell of the same column, in an
excel spreadsheet.

In my workbook, my first worksheet contains rows of text.
Each row also has category columns that a user can put an "x" in, to
mark that row as being a member of the particular category.
A contrived example: (I'll use commas here to delimit columns)

given the table below - example -
John    2
Fred    3
Eric    1