How identify data of two coulams,Every cell count and show result

[Guest]

Q1. How identify data of two coulams


Q2. Every cell count and show result like
I need like
Coulam A Coulam B
500 1
500 2
500 3
800 1
800 2
800 3
800 4

800 5
800 6
600 1
600 2
600 3
600 4
700 1
700 2
I want to count like coulam B i have data in coulam A and like this

I have two coulam with name as lower,upper,propercase i want to do all in
same case like in proper case how?

 

[Roger Govier]

Hi

In column B enter
=COUNTIF($A$1:A1,"="&A1)
copy down column B as far as required

To convert to proper case, assuming data is in column C, in column D enter
=Proper(C1)
Copy down column D as far as required.
Then copy the whole of column D, locate cursor in cell A1 and Edit>Paste
Special>Values.
You can then delete column D.

Regards

Roger Govier