macro or formula needed for matching criteria

[excelhelpseeker]

Hi Champs,

I have a record set from col A to col E

Doc #, Code, Account, Description and amount.

i need a macro or function to display all the line items of the doc # (A col) with code 40 or 50 (B col) with amount in 5 series (starting with 5) in Ccolumn.

that is if doc # has code 40 or 50 with 5 series account all the line items of the respective doc # has to be displayed. I have attached the sample.

pls help.sample.xlsx

[ashishmehra2010]

Hi,

May be this will help you.

Regards,
AM

[ashishmehra2010]

Hi,

In Range A4:E31 try the

Please Login or Register  to view this content.

in CF.

Regards,
AM

[naveenmarapaka]

You want Macro to provide your result for input ? or Output also ?

Below will work for Phase 1 which is input...

Please Login or Register  to view this content.

[excelhelpseeker]

Hi Asishmehra 2010,


Your formula pulls the record of code 40 and 50 only, but if the doc has 40 or 50 with 5 series, all other codes should also be displayed as in my sample file. Pls help

[ashishmehra2010]

Hi,

I have tried using Conditional Formatting which is matching with the Output that you have provided in the initial post.
Refer to sheet CF.

Regards,
AM

[excelhelpseeker]

yes conditional formatting is perfect... but i need to display only the matched record and not the other ones. iif i get my input and run the macro or formula, the output mentioned in my sample has to be displayed. pls help

[naveenmarapaka]

Check attached...

[ashishmehra2010]

Hi,

Unfortunately your statement contradicts.
Post#7: I need to display only the matched record and not the other ones.
Ans: Refer to file attached in post#2

Q: If I search for greater than equal to 40 or less than equal to 50 in Code column then which rows would you like to skip.
Please define the logic.

Regards,
AM

[ashishmehra2010]

Check attached...

Hi Naveen,

Thanks for sharing file, the code is working fine. Clean(C1) does the trick.

I learned something new from you.

Regards,
AM