Print Excel records to Word?

I have a database in excel.
It has 40000 records.
But to make my question simple I use a smaller example to describe my problem.
In Database.xlsx I have two columns.
Some of the records have equal value in column A.
Values in column B are unique.
I need a way to search and fine records which have same value in column A and then print those records to a word file.

Here is what I want :

Database.xlsx :
A B
22 1
22 2
22 3
36 4
36 5
36 6
51 7
51 8
51 9
51 10
///////////////////////////
Word01.docx
Column A : 22
Column B is from 1 to 3
Total Numbers of records : 3
///////////////////////////
Word02.docx
Column A : 36
Column B is from 4 to 6
Total Numbers of records : 3
///////////////////////////
Word03.docx
Column A : 51
Column B is from 7 to 10
Total Numbers of records : 4

Thanks in advance

Have you considered using the mail merge functionality in Word?

OK I found out how to add C column :
=COUNTIF(A:A;A1)
Then I can apply it to the whole column with this method :

Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.

So now how to make B column which seems more challenging?

Edit :

This seems better :
A-----B---C----D
22----1---3----3
36----4---6----3
51----7---10---4

Column B is the value of first match
Column C is the value of last match
How can I find the first and the last match when I count?

Does the attached help

You just need to copy F4:H4 down as far as necessary until you run out unique values in column F

Since column H tells you how many numbers for each column F value it follows that the sum of all the numbers before will give you the secon bit of the column G value, i.e. the "to..." bit.

..and how many unique records are there in the 4000? It hardly takes much longer to copy down say 1000 rows as to copy to 100 rows.

Why do you say the SUM doesn't make sense. The second number in the "B" column is by definition the sum of all the count of all the prior numbers.
If you are saying it's wrong then please expalun what you expect to see.

Otherwise you'll need a macro to completley automate it.

With an ordinary Word mailmerge, you can have Word sort the records so that like records appear together. Once the document is connected to the data source, see Mailings|Edit Recipient List>Sort.

This is getting confusing

Your OP mentioned wanting a table of the unique values from column A which is what my offering gave you.
You now seem to want to generate the same From/To values for each number in the list.But to what end if at the end youre going to get rid of the duplicates anyway.

If all you want to do is identify duplicates, there are quite simple ways within Excel itself, including when the test requires comparing multiple columns.

Which table of original data are you referring to. The Result table you showed in post#1 or the Original Data Table in post #10?

The goal post seems to be moving a bit and I'm no longer sure whether you're looking for a unique set of the basic numbers and the associated From/To numbers.

So what constitutes an 'unnecessary record'?

I have to merge a group of records into one record and then delete the extra ones which will be unnecessary record.
I hope this makes sense :
I need to turn table 1 into table 2
And then turn table 2 into table 3
Then I can use mail merge functionality in Word with table 3

Originally Posted by macropod

So what constitutes an 'unnecessary record'?

A good question.
So far I'm assuming an unnecessary record is any record which has a value in the column labeled A in post#10 that is the same as an earlier record.

Thanks to all my problem is solved.
The solution was tooooo easy!
Starting from post 4 I went into the wrong direction.
No need to use complicated macros or even no need for COUNTIF!
It can be done by using - and +
Here is a quick note on how to do it :
Delete duplicate records on Column A --> Data > Data Tools > Remove Duplicates
Column From ---> Column B
Column To ---> =B3-1 (Next From - 1)
Column Total --> =C2-B2+1 (To - From + 1)

Hi,

Glad you came to a satisfactory result and hanks for the rep.