Sort out "Fail" Text from Columns

[pvsvprasad]

Dear Masters,

I need simple macro for sort out by "Fail" text no.s to another Row.please find sample file.

Thank you,
Best Regards.

[LeoTaxi]

Maybe this

Please Login or Register  to view this content.

Kind regards
Leo

[pvsvprasad]

Maybe this
Kind regards
Leo

Dear Master,

Your Code is really brilliant. Thank you sir.i am adding one column only for counting total "FAIL", please find the sample file for column . this is my final Modification.


Thanking you sir,
Best Regards.

[LeoTaxi]

The it looks like this

Please Login or Register  to view this content.

Kind regards
Leo

[pvsvprasad]

The it looks like this

Kind regards
Leo

Thank you very much Master, Now Everything is working well.


Thank you,
Best Regards.

[pvsvprasad]

The it looks like this

Dear Master,
Thank you for providing excellent code.i have tested with my actual data and getting small error at "AI2" Cell, it should be shown as "0" when "AJ2" is empty. and some times showing Debug error if A Column to AD containing data. why showed Debug error?

please find sample image and file and kindly fix.

Thanking you sir,
Best regards.

[LeoTaxi]

test like this

Please Login or Register  to view this content.

Cheers
Leo

[pvsvprasad]

test like this


Cheers
Leo

Thank you very much sir,

and some times showing Debug error if A Column to AD containing data. why showed Debug error? kindly observe.

Thank you,
Best regards.

[LeoTaxi]

i dont have the error,
can you post the file that give the error ?

[pvsvprasad]

i dont have the error,
can you post the file that give the error ?

Dear sir,

Sure sir, Here i have attached error Developed file.Kindly Test with this file.

Thanking you,
best regards.

[pvsvprasad]

i think this error caused by "FAIL" Strings at "M" and "O" Columns due to many rows.

[sanram]

You can try this code :

Please Login or Register  to view this content.

[LeoTaxi]

where the formula give one error, this code see it as a FAIL

Please Login or Register  to view this content.

Kind regards
Leo

[jindon]

Please Login or Register  to view this content.

[pvsvprasad]

Dear Jindon,

Thank you for providing. with help of your code values are moved and doubled. i need unique no.s of "FAIL". please find sample file.

Thanking you,
Best Regards.

[pvsvprasad]

You can try this code :

Dear sir,

Thank you for providing your nice code. everything is ok. but at AJ4 values are developed as double. please find sample file and make a small correction please.

Thanking you,
Best regards.

[jindon]

Please Login or Register  to view this content.

[pvsvprasad]

where the formula give one error, this code see it as a FAIL
Kind regards
Leo

Dear sir,
Thank you for Modification,

while running code produced un even values. kindly find my sample file requirement and make a suitable minor tweaks.

Thanking you,
Best Regards.

[pvsvprasad]

Dear Jindon,

Your code is exactly worked. only AI Column values missing. these AI column values are counting of AJ column counting no.s. please add AI output. rest of your code is perfect.

Thanking you,
Best Regards.

[jindon]

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[LeoTaxi]

See code in #13


Kind regards
Leo

[LeoTaxi]

With errors in formula

Please Login or Register  to view this content.

Kind regards
Leo

[sanram]

A small correction in my code will do this too :

Please Login or Register  to view this content.

[pvsvprasad]

A small correction in my code will do this too :

Thank you for your kind help,

please solve my another post. http://www.excelforum.com/excel-prog...-criteria.html

Thanking you,
Best regards.

[sanram]

You are welcome and thanks for the rep.