How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Computer
Satisfied Customers: 1845
Experience:  20 years experience providing remote computer support
62934938
Type Your Computer Question Here...
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

PS sorry about wording

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/08158800AA0041158350158800
AA0043158800159879
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.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Last | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/MI/mikew4950/2011-12-26_1606_mikephoto2s.64x64.jpg MikeW's Avatar

    MikeW

    Computer Engineer

    Satisfied Customers:

    49
    32+ years Computer and Networking Experience
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

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