• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Matching criteria request in excel..

@Gopigk

@Gopigk

Member
Hi all,
I have a customer receivable amounts in 10 rows in column A. I received an amount from customer and I can adjust that amount with what ever matching receivable amounts are there from column A whether it matches with 2 cells or 3 cell, not an issue.

So, can anybody help me that, is there any function or formula to highlight the cells in column A to match with the receivable amount.

Thanks in advance
 
@Gopigk
Have You thought to use Conditional Formatting to highlight Your needs?
Could You send a sample Excel-file with sample data as well as Your expected results ... based thoseYour given information?
 
@Gopigk
Do You have any ideas - how many combinations should check before You'll find those amounts?
Here are two samples ... both will take some times to solve.
Are You sure that those Your given marked amounts combination in only one possible combination?
 

Attachments

  • Sample File.xlsb
    25.5 KB · Views: 2
@Gopigk said:
is there any function or formula to highlight the cells in column A to match with the receivable amount
Click to expand...
No sure it can be done with formulas and as you forgot to mention which is your Excel version …​
Anyway it can be achieved with a VBA procedure after some processing time, could last for ages as Excel is slow.​
​
 
You must log in or register to reply here.
Back
Top