Ok.... I have a table of data. Some are duplicated, and I'd like to find out
which one's, and how many.
I've got six columns of 5 digit#'s, spread out with match(), and countif()
in each subsequent column, and I want to do a "bulk" countif, just counting

Hi, Is there any way to not only count duplicates, i.e.
=COUNTIF(range,C2), but to assign each occurance an ordinal value?  So
for example, if Model1234 appears twice within "range", not only would
"2" result, but that the first occurance of Model1234 would display

i have multiple worksheets from the 'old' XL that max at 65k rows.  i want to
combine all of the data into one worksheet using the new XL that allows 1mil
rows of data.  from there I will manipulate, make changes, then create pivots
and charts.

I am trying to copy the results of 51 queries to one workbook worksheet via
the Transfer Spreadsheet macro command.  What I want to do, though, that
isn't working for me at present, is to just copy a single value to a
specified cell on the worksheet, then repeat the proces for ...

The following array formula is working for me:
=(SUMPRODUCT(--(D9:D55>DATEVALUE("12/31/2006")),(--(D9:D55<=K1)),E9:E55))/(COUNTIF(D9:D55,">12/31/2006")-COUNTIF(D9:D55,">5/31/2007")).
However I would like for 5/31/2007 to be a cell reference of K1. I want to
be able to change just ...

Does anyone have any suggestions on how to do the coding on Macro?
[Loop for Until]
[Perform following code]
Workbooks.Open Filename:="C:\1.xls", UpdateLinks:=3

I have a spreadsheet where cell C6 requires the user to enter a date, I
currently have a custom validation in the cell of the following:-
=WEEKDAY(C6,2)<=5
This displays an error message if a non-working day (i.e. a Saturday or

Dear experts,
I got an external table showing the flows of parcels. For example, column A
is for source locations and colum B is for destination locations.
Parcel 123 (for example)

Ok, I guess this got sticky because of how detail I'm trying to get it
to be with the multiple criterias. The purpose of this sheet is to
track business expenses amongst about 8 employees.
Assume columns: (with up to a thousand rows of data)

I have a pivot table on a template file that reads from a section of data
imported from a separate file upon each opening.  This table is grouped by
Date, Transaction, and Fund.  I only want 1 particular fund number to show in
this table, is there a way to save the table so it ...

I recently exported two reports from Quickbooks Pro in CSV format. Text
strings in one report had surplus characters which I "removed" using text
functions. The resultant text using LEFT(no of characters) then matched text
strings in second report. The number of rows in the first ...

x     10
x     11      21
y     12
y     10      22

I have a column of contract expiry dates, but not all cell values are dates:
Some are empty, some contain "month to month", others "6 months", and so
forth.
I need a formula that will-

As I saw in here already, there are people who said there is no way to change
the size of the text in the data validation text box.  My Question is:
Does any third party make an add in or anything that would help in
formatting this text to a larger font size?

Here is my problem, I have a list of dates of when a product was shipped in
column C and the date when it was received in column D. I would like the date
in D to be highlighted red when it is more than 3 working days from the date
in C and green when it's less than or equal to 3 ...