I need to know how to find out what the last cell entered was?

What would be the formula specifics when I want to use the count or countif
funtion with two criteria.  Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h

Hi,
I'm trying to build a macro that runs automatically creating a pivot table
when I charge external data in a workbook, without opening the workbook. Is
this possible or I have to looking for another solution?

I would like to clear the contents of a cell in an Excel worksheet from
another cell in the same worksheet based on the content of that other cell.
Stating it in words:  if cell A2 equals 1 then set cell A1 equal to "blank".
Is there a simple way to do this? I am using cell A1 ...

=IF(AND(F2>=0,F2<=120000),(F2*'Data
Matrix'!B8%),OR(IF(AND(F2>=120001,F2<=250000),(F2*'Data
Matrix'!B9%),OR(IF(AND(F2>=250001,F2<=500000),(F2*'Data
Matrix'!B10%),OR(IF(AND(F2=500001,F2>500001),(F2*'Data Matrix'!B11%),"InValid

I have 2 columns:
A1
123456 ABCDE
654321 XYZ

Hi, i'm trying to return a value in Q2 as in the equation below but the
cell P2 is formatted as percentage and i want the value in Q2 to show
the sum of E2:O2 minus the percentage in P2. Im sure this one is a no
brainer for you guys......just cant seem to get my head round it, the

Can someone suggest me how to hide a macro code using another macro
code in Excel.
Please do not suggest to hide a macro through VBAprojectproperties
password protect method.

Can someone provide me with a vlookup formula to compare 2 columns ( Col A
versus Col B) & return the matched values in Column C?

I have a list of email address in one worksheet named Email.

How do I enter a formula to only calculate IF there is something in a
determined cell?    Example:  
Invoice Amount = cell E      Date pd = F      Comm amount = G    Total  = H
I only want H to calcualte if there is a date in cell F.  How do I enter it?

I have inherited spreadsheets from users that were fond of naming ranges
using the Insert, Name, Create function, and a lot of formuls incorporate the
names in them.  My problem is that I can't see at a glance of the formula
what the underlying data range is (on vlookup for ...

i know there are a lot of posts and things on feet and inches.  my question
is a little more specific.  i want the format to be (for 11 feet 6 inches) to
look like 11-6.  so far, my formulas look like this:
this formula would convert 11-6 to 11.6 feet

How can I combine two lists from separate worksheets into one list
eliminating duplicates?

I am trying to add up all the totals from seperate supplier vat sheets they
are all of the same layout I tried
=SUM('Sheet1'!F3,'Sheet2'!F3......Etc.)
It keeps saying formula is too big, i want to add up about 60 separate