Help!!! About the statistics of data Help!!!

[andyhcc]

Hi everyone ..I am new here...
I have some date in Excel sheet. See the attachment
-------------------------------------------
How can I use VBA make those date become the table in a userform (better) or in a sheet?
1. NO. - Every NO. that exits in the Data
2. Count - Count of each NO.
3. Failed _ Count of each NO. that is "Failed"
4. Failed Rate - (Failed / Count) %
5. Sort by "Failed Rate" Descending
6. The data in the table will change once the data is changed

Thanks for help

Andy
------------------
It's a little bit like the the Pivot Tables but the format is not what I want.
See the new attachment at #4

[andyhcc]

Little Help... Anyone?

[Bob Phillips]

If everyone else is like me mate, they would be unable to understand what you want to achieve. The example on the worksheet just didn't explain it.

[andyhcc]

If everyone else is like me mate, they would be unable to understand what you want to achieve. The example on the worksheet just didn't explain it.

Hi...
It is like the Pivot Tables...See the new attachment.
But the format is not what I want...

[lucas]

andy, please don't delete your attachments. It disrupts the thread. Others are here to learn from your project and if you delete posts or attachments it causes the thread to not make any sense.

[andyhcc]

andy, please don't delete your attachments. It disrupts the thread. Others are here to learn from your project and if you delete posts or attachments it causes the thread to not make any sense.

Sorry...I have put it back...
Any idea to sovle it?

[georgiboy]

Probably a much better approach but such is life

Hope it helps

[andyhcc]

Probably a much better approach but such is life

Hope it helps

Thanks for help
But when I add new data, it shows error message, see the attached picture

[georgiboy]

Try this