• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 2107
Experience:  20 years experience providing remote computer support
62934938
The-PC-Guy is online now

# Excel macro help

### Customer Question

excel macro help
Submitted: 2 years ago.
Category: Computer
Expert:  cvd4311 replied 2 years ago.
Can you explain more what kind of excel help that you are needing?
Expert:  cvd4311 replied 2 years ago.
excel macro help rather?
Customer: replied 2 years ago.
Expert:  cvd4311 replied 2 years ago.
give me a few to look it over.
Expert:  cvd4311 replied 2 years ago.
Okay this is a little more in depth then I am familiar with. I am going to OPT out so that another expert can come online to help you out. You will receive an email when someone answers.
Customer: replied 2 years ago.

thankyou

do i leave just answer now and wait for an email

kev

Expert:  The-PC-Guy replied 2 years ago.
i have your file but am not following. You want to see if the number in b2, is between column K and L, for example if the value in b2 was 50 and one of the values in column K was 20 and the coresponding value in column L was 60, then the condition would be true? Am I understanding correctly so far?
Customer: replied 2 years ago.

no

if the value in B2 b3 etc falls between the values in K to L i require a list of matches

Attached will be a simplified version of data that appears to work correctly then the more comprehensive list that fails

Attachment: 2015-08-22_201522_simplified_problem.zip

Attachment: 2015-08-22_201540_number_find_problem.zip

 RS/59/08 158800 AA0041 158350 158800 AA0043 158800 159879
Expert:  The-PC-Guy replied 2 years ago.
so the value is coming from column M, and you are looking to basically run through all the values in column A and find the M values that fall within K and L ranges, and if there is more than 1 value, they each go in a separate column starting with column N for that row. However you want only unique values returned?
Expert:  The-PC-Guy replied 2 years ago.
do I have an understanding now?
Customer: replied 2 years ago.

the simplified one does not work either

but yes you have an understanding

its hard to put in words sometimes

its the Values in columm B though.

the reference in M (Poss Ref) that each instance is returned

Expert:  The-PC-Guy replied 2 years ago.
think I got it, I am sending an offer of additional service, please accept it and I will get started