Filtering Records Based On A Criteria Value

Copper Contributor

My requirement is to filter records based on a criteria value.

 

List of records in Column A (Filter range)

Criteria in Column B

Output in Column C

 

Criteria is sum of three different ranges in Column A

 

A VBA code is required  provide output in Column C that these values are equal or sum of criteria.

 

Filter RangeCriteriaOutput
13943232.83 
1386.64  
532  
26  
486  
220.66  
1062  
400  
126.27  
170  
3810  
700  
500  
22  
120  
230  
35.65  
421.74  
2129.56  
241.5  
234.78  
25 Replies

@Hans Vogelaar 

Thanks for detailed reply and I solved it.

I did and accomplish it with a name error.

I am using office 2016 and might be filter function is not available this version.

However I am able to corresponding value in A with the help of 1 in column B.

Any comments?

@Hans Vogelaar 

Now I added the actual data which goes to the ending range of line no. 231.

 

In this scenario Excel is replying "Too many variable cells"

 

File is attached for quick reference please.

 

Awaiting for a reply.

@amjadinsaudia 

According to Define and solve a problem by using Solver :

"You can specify up to 200 variable cells."

So your problem is too complicated for Solver.

@Hans Vogelaar 

 

noted the message and ack with thanks.

@Hans Vogelaar 

@mathetes 

 

I have achieved my goal 100% with the help Mr. Hans. I would like to thanks to him and Mr. Mathetes for the kind support on this tech forum.

 

With my regards,

Amjad

@amjadinsaudia 

You're welcome!