• 100% Satisfaction Guarantee

The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 1896
Experience:  20 years experience providing remote computer support
62934938
The-PC-Guy is online now

# Excel macro help

### Customer Question

excel macro help
Submitted: 1 year ago.
Category: Computer
Expert:  cvd4311 replied 1 year ago.
Can you explain more what kind of excel help that you are needing?
Expert:  cvd4311 replied 1 year ago.
excel macro help rather?
Customer: replied 1 year ago.
Expert:  cvd4311 replied 1 year ago.
give me a few to look it over.
Expert:  cvd4311 replied 1 year 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 1 year ago.

thankyou

do i leave just answer now and wait for an email

kev

Expert:  The-PC-Guy replied 1 year 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 1 year 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 1 year 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 1 year ago.
do I have an understanding now?
Customer: replied 1 year 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 1 year ago.
think I got it, I am sending an offer of additional service, please accept it and I will get started

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer

### Bill Fisher

#### Satisfied Customers:

1
Computer system design, networks, integration, general support.