PDA

View Full Version : Help!!! About the statistics of data Help!!!



andyhcc
11-13-2008, 11:39 AM
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
11-13-2008, 12:59 PM
Little Help... Anyone?

Bob Phillips
11-13-2008, 01:46 PM
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
11-13-2008, 02:07 PM
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
11-13-2008, 02:11 PM
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
11-13-2008, 02:34 PM
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?: pray2:

georgiboy
11-13-2008, 02:50 PM
Probably a much better approach but such is life

Hope it helps

andyhcc
11-13-2008, 03:08 PM
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
11-14-2008, 10:08 AM
Try this