Look up column and Extract and print maximum value and beside cell value

[pvsvprasad]

Dear masters,

i need one code for Lookup entire column, extract maximum value and beside cell value to another cells and need one output column(U).i have one good code. please modify for this correction.
i have tried but not successful. so kindly make a modification. my code is as below:

Please Login or Register  to view this content.

please find sample output file of Excel file.

thanking you,
Best regards.

[oeldere]

u4 =MAX(ABS(P4),ABS(Q4)) and drag down.

[pvsvprasad]

u4 =MAX(ABS(P4),ABS(Q4)) and drag down.

Dear sir,
thank you for reply. i need by macro version and i want same value like a -14.59, -32.55 etc.. kindly modify my old code.

Thanking you,
best regards.

[pvsvprasad]

Dear experts kindly solve.

thanking you all,

Best regards.

[abduljaleel.mca]

Try this, I have updated your code. Please check.

Please Login or Register  to view this content.

[pvsvprasad]

Dear sir, thank you for modification.

your code is producing values as "0.00", correct values as -14.59, -32.55 etc, and No values are produced at X4, Y4, Z4 ,AA4, AA5. Please find screen shot.kindly modify the code to produce required result.

please find sample out put format of excel file.

thanking you,
Best regards.

[pvsvprasad]

Please modify the code.

Thanking you,
Best regards.

[abduljaleel.mca]

Hi,
Code is working fine for me here, please see below.
Attached macro file as well.

[bebo021999]

Hello, try below code:

Please Login or Register  to view this content.

[pvsvprasad]

Hi,
Code is working fine for me here, please see below.
Attached macro file as well.

Dear sir,
thank you for providing.with help of your code, at "U" column there is values like 14.59,32.55 etc instead of -14.49, -32.55 etc. these should be with negative values. kindly make small correction in your code.

thanking you,
best regards.

[pvsvprasad]

Hello, try below code:

Dear sir,

i just saw your code. and very nice. thank you for providing.

i am adding 3 columns with inserted simple manual formulas, please insert those formulas to your code.please find the attachment.

AC , AD, AE values should be produced up to where up to AB columns values are available.(AB Column is Manual input only, no need code at AB Column))

and some minutes hanging while using with more data rows.please tweak the code.

Thanking you,
Best regards.

[abduljaleel.mca]

Dear sir,
thank you for providing.with help of your code, at "U" column there is values like 14.59,32.55 etc instead of -14.49, -32.55 etc. these should be with negative values. kindly make small correction in your code.

thanking you,
best regards.

Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[pvsvprasad]

Change this line

Please Login or Register  to view this content.

Dear sir,
thank you for modification.
automatically changed Formula range at "U" column. kindly fix this error.

[abduljaleel.mca]

Updated. Please check.

[pvsvprasad]

Updated. Please check.

Dear sir,

thank you for updating.i am tested with more data, now showing wrong text at "AA4". please find the attachment and update.

thanking you,
Best regards.

[abduljaleel.mca]

It is showing 'N/A' since the number '-47.157' is not in 'MY' column (columns G and H). The data for AA5 should be fetched from columns G and H right? Then why do have the number '-47.157' is in 'MZ' column (columns E and F) instead of 'MY?.

[pvsvprasad]

Oh..sorry i will check once. wait

[pvsvprasad]

It is showing 'N/A' since the number '-47.157' is not in 'MY' column (columns G and H). The data for AA5 should be fetched from columns G and H right? Then why do have the number '-47.157' is in 'MZ' column (columns E and F) instead of 'MY?.

Yes sir, Look up entire G column and find maximum value and paste to Z4 column either positive or negative and another value to AA4 column. data is fetched from G and H columns .(-47.157 is wrong result)

same as for E F columns and fetched from G and H columns.fetched from E and F columns.


maximum value example : if column E or G containing 32 and -62 then paste as a -62.

for rules please See at X2 and Z2 Text.

kindly modify the code.

thanking you,
Best regards.

[abduljaleel.mca]

Please check.

[pvsvprasad]

Please check.

Dear sir,
thank you for modification and updating.

in your code mentioned formula for AC4 is "=SUM(AB5:AB5) + 5", but i need formula as a" =IF($AB4=15,"20",IF($AB4=20,"25",IF($AB4=25,"35",IF($AB4=30,"40"))))" in your code.

W4 value is larger than AC4 so print as "FAIL" at AD4 (sorry, i am unfortunately moved rows AC to AE downwards, now sent Correct position)

AC , AD, AE values should be produced up to where up to AB columns values available.please find the attachment for cell moving correction.(AB Column is Manual input only, no need code at AB Column)

kindly make these modifications.


thanking you sir,
With best regards.

[abduljaleel.mca]

Attached updated file.

[pvsvprasad]

Attached updated file.

Dear sir,
now your code is well. you forgot one column i.e "AE".
AE column cell values should be produce where up to AB columns values range available.

kindly add the missing column code line.

thank you for modification.

Best regards.

[pvsvprasad]

Dear sir,
please add Missing AE column to your code. please find the attachment for sample output in AE column.

Thanking you,
Best regards

[abduljaleel.mca]

Attached updated file.

[pvsvprasad]

Dear Masters,
This is another variant from present code. kindly make a suitable modifications for this sample Output excel file.

thanking you all,
Best regards.

[pvsvprasad]

Plz find this attachment for modification.

[oeldere]

Keeps the questions open I asked you in the beneath link.

http://www.excelforum.com/excel-prog...d-analyze.html

[pvsvprasad]

Keeps the questions open I asked you in the beneath link.

http://www.excelforum.com/excel-prog...d-analyze.html

yes sir, i did. please have a look at thread and solve.

thanking you,
best regards.

[oeldere]

post in wrong threat

[pvsvprasad]

Please check.

Dear sir,
Kindly have a look at this thread and solve.

http://www.excelforum.com/excel-prog...d-analyze.html

Thanking you sir,
Best regards.