andyhcc
11-13-2008, 11:33 AM
Hi everyone ..I am new here...
I have some date in Excel sheet like below:
-------------------------------------------
GroupNO.ResultA1PASSA2PASSA3FailedA4PASSA5PASSB6FailedB7PASSB8PASSB9PASSB10 PASSA1PASSA2PASSA3FailedA4PASSA5PASSB6PASSB7PASSB8PASSB9FailedB10PASSA1PASS A2PASSA3FailedA4FailedA5PASSB6FailedB7PASSB8PASSB9PASSB10PASSA1PASSA2Failed A3PASSA4PASSA5PASSB6PASSB7PASSB8PASSB9PASSB10PASS
------------------------------------------
How can I use VBA make those date become the table like below
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 there the data is changed
GroupNO.CountFailedFailed RateA34375%B64250%A24125%A44125%B94125%A1400%A5400%B7400%B8400%B10400%
Thanks for help
Andy
I have some date in Excel sheet like below:
-------------------------------------------
GroupNO.ResultA1PASSA2PASSA3FailedA4PASSA5PASSB6FailedB7PASSB8PASSB9PASSB10 PASSA1PASSA2PASSA3FailedA4PASSA5PASSB6PASSB7PASSB8PASSB9FailedB10PASSA1PASS A2PASSA3FailedA4FailedA5PASSB6FailedB7PASSB8PASSB9PASSB10PASSA1PASSA2Failed A3PASSA4PASSA5PASSB6PASSB7PASSB8PASSB9PASSB10PASS
------------------------------------------
How can I use VBA make those date become the table like below
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 there the data is changed
GroupNO.CountFailedFailed RateA34375%B64250%A24125%A44125%B94125%A1400%A5400%B7400%B8400%B10400%
Thanks for help
Andy