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 R.R. Jha Your Own Question

R.R. Jha
R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5470
Experience:  B.Tech
20870358
Type Your Homework Question Here...
R.R. Jha is online now
A new question is answered every 9 seconds

For RRjha only, I have another question for you. I have data

Resolved Question:

For RRjha only, I have another question for you. I have data in columns E,F,G,H,I some data is left unfilled meaning no color, and the other data is filled in with color. The data to be used is the unfilled data. I want a macro where I label the columns where the data is found in for EX: E labeled A, F labeled B, G labeled C, H labeled D, and I labeled E. once I enter this A,B,C,D,E I want to run a search in the range of data L78 through AKC5988. pick a number from the column "called" A which will be number 9 then look into column "called B to find number 15, and so on with each column "called C,D,E. and to find every combination being sure to follow that the column "called" A the only numbers used for the first column only are the ones in the E column "called" A and so on. this way it ensures for ex: 1-4-19-21-26 or 1-4-19-21-31 etc.    http://ge.tt/1WHLxjy/v/0

Submitted: 11 months ago.
Category: Homework
Expert:  R.R. Jha replied 11 months ago.
Hi,

Received the question. Give some time to assimilate your requirements. I'll be back to you asap.
Customer: replied 11 months ago.
Hi, ok, thanks
Expert:  R.R. Jha replied 11 months ago.
No problem.
Expert:  R.R. Jha replied 11 months ago.
Ok, could you break it down in simple steps. Once I pick numbers 9, 15, 22, 24 ,26 from the five columns how exactly the macro should search and how should it output the results?
Customer: replied 11 months ago.

ok I pick the A B C D E , this model or format will be used to pick a number from the column E, then the next number will be picked from F , G, H, and I it will search for all combinations one number from each column then return the row column and row in which it is found in Column N.

Customer: replied 11 months ago.

ok I pick the A B C D E , this model or format will be used to pick a number from the column E, then the next number will be picked from F , G, H, and I it will search for all combinations one number from each column then return the row column and row in which it is found in Column N. but keep in mind it is only using the numbers unfilled with color. then I may choose another format like B,C,D,B,E. In the column L shows which one I may choose at any time.

Customer: replied 11 months ago.

ok I pick the A B C D E , this model or format will be used to pick a number from the column E, then the next number will be picked from F , G, H, and I it will search for all combinations one number from each column then return the combination and place it in the N column but keep in mind it is only using the numbers unfilled with color. then I may choose another format like B,C,D,B,E. In the column L shows which one I may choose at any time. its easier just to list the combinations found to the N column.

Expert:  R.R. Jha replied 11 months ago.
Ok, for example if you picked B,B,B,C,C then first combination to be placed in N would be 15-12-4-22-23?
Customer: replied 11 months ago.

yes, and all possible combinations than can come from the B,B,B,C,C

Expert:  R.R. Jha replied 11 months ago.
Alright, how should I read the desired format? I can prompt for input or you can select the cell having the format and then run the macro?
Also, I believe I've to clear the existing combinations when searching for a new format?
Which cell should I place the first combination?
Customer: replied 11 months ago.

 


prompt for an input, yes clear the ones that were produced in the Coulmn N for new data.


N100.


As I add data the unfilled cells will change. so the macro will identify the unfilled numbers to use only?

Expert:  R.R. Jha replied 11 months ago.
Ok, the macro would identify and use only unfilled numbers even if you add more data.

This might be time taking. Is it ok if I finish this by tomorrow?
Customer: replied 11 months ago.


sure. Thanks

Expert:  R.R. Jha replied 11 months ago.
Ok, thanks
Customer: replied 11 months ago.

Thanks again

Expert:  R.R. Jha replied 11 months ago.
No problem (Forum policy compels us to reply to your every post Undecided)
Expert:  R.R. Jha replied 11 months ago.
Here it is. Please make sure unfilled data is not filled with even white color.

https://app.box.com/s/dujurupdnynhq08njrt7

Thanks

R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5470
Experience: B.Tech
R.R. Jha and 4 other Homework Specialists are ready to help you
Customer: replied 11 months ago.
I can't check now as I am at work. Ill check it later and reply. Thanks again
Expert:  R.R. Jha replied 11 months ago.
No problem.
Customer: replied 11 months ago.

ok it worked! everything looks good! the data that is in column N the results is good, I would also like the data to be unmerged into the column O,P,Q,R,S so that I can selected the data and do a sum of each combination. but unchanging the anything just adding the unmerged data to the columns to the right. thanks ill add bonus for the additional work.

Expert:  R.R. Jha replied 11 months ago.
Ok, I'll unmerge it and get back to you. And is option to add bonus appearing above?
Customer: replied 11 months ago.
Not yet but when I get home ill add it.
Customer: replied 11 months ago.
Thanks again:)
Customer: replied 11 months ago.
Ok I called and the justanswer assisted me to add the bonus for the work.
Customer: replied 11 months ago.
Thanks
Expert:  R.R. Jha replied 11 months ago.
Hi,

I've updated the macro. Please download it again from the same link above.

Let me know if I could help with anything else.

Thanks
Customer: replied 11 months ago.
I will check when I get home. Thanks again!
Customer: replied 11 months ago.

Hi, I ran another Search with AAABD and the result didnt come out right it list the number 3 3 3 28 28, can you fix this error? it suppossed to use only the unfilled number and not repeat in the same combination. it worked on the ABCDE but not on the AAABD http://ge.tt/8rq06sz/v/0

Expert:  R.R. Jha replied 11 months ago.
Ok, let me see.
Customer: replied 11 months ago.
Ok thanks
Customer: replied 11 months ago.
Just wondering if you got a chance to look at the error. Thanks
Expert:  R.R. Jha replied 11 months ago.
Hello,

Sorry for late reply. I've been away from laptop due to health issues. I'll look into the problem as soon as possible.

Regards
Customer: replied 11 months ago.
Ok, no problem. Thanks
Expert:  R.R. Jha replied 11 months ago.
Ok, thanks
Customer: replied 11 months ago.
How ya doing?
Expert:  R.R. Jha replied 11 months ago.
Still recovering. But I'll look into it and try to get back to you by tonight.
Customer: replied 11 months ago.
Ok, get well. You can get it to me tomorrow. Thanks again.
Expert:  R.R. Jha replied 11 months ago.
Ok, working on it. Just need some clarification.
Suppose there are only 2 unfilled cells for 'A' which is column 'E'. Now if you enter AAABC what should be the output? Should I leave the output blank? or indicate in output that data for that column is missing? This is a case even if you enter all five distinct columns but they don't have the unfilled cells to show?
Customer: replied 11 months ago.
If it doesn't have enough unfilled for the AAABC then state missing data.
Customer: replied 11 months ago.

Thanks

Customer: replied 11 months ago.
So like you said if there are only 2 unfilled in the column E which is A and I put AAABC then put put missing data. Thanks
Expert:  R.R. Jha replied 11 months ago.
Ok, seems no easy way around the duplicates. I'll keep working on it and let you know.
Customer: replied 11 months ago.
Ok, thank you very much. :)
Expert:  R.R. Jha replied 11 months ago.
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.
Expert:  R.R. Jha replied 11 months ago.
Hi,

Anything else I could help with in this regard? All set, please let me know when you've sent the bonus. As of now, it's only showing that $5 bonus you sent on original rating the other day.

Thanks
Customer: replied 11 months ago.
I tried sending but it was stating to pay another 50.00. It wouldn't let me send the 15.00 to 20.00 bonus, I called and they stated just answer added 15.00 before I asked this last f/u question. I will call to see how I can fix this so I can add the bonuses. Thanks
p.s. the program worked thanks!
Expert:  R.R. Jha replied 11 months ago.
Ok, Thanks.
Customer: replied 11 months ago.
While I work on the bonuses for you do you have knowledge of prediction type models based on historical data and location of data? If so let me know and if I can't set up bonus through justanswer I can add to next question. Thanks
Customer: replied 11 months ago.
Ok this is what I'll do,I have another question and ill add the bonuses on to it. I want to know if you have experience with prediction type models or programs with vba based on history of data etc.
Expert:  R.R. Jha replied 11 months ago.
I know about some of the prediction techniques. I'll have to see what type of data do we have to see if any of those technique could be applied.
Customer: replied 11 months ago.
Ok, I really don't like the forecast as it isn't really accurate nor the trend really. I will work on the which data I will use and set up the question. Thanks
Expert:  R.R. Jha replied 11 months ago.
Alright

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • 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 Los Angeles, CA
  • 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 Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • 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 Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3458
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3124
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2385
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1988
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1876
    Bachelors Degree and CPA with Accounting work experience
  • http://ww2.justanswer.com/uploads/avremote/photoa.jpg Seanna's Avatar

    Seanna

    Tutor

    Satisfied Customers:

    1781
    3,000+ satisfied customers, all topics, A+ work
 
 
 

Related Homework Questions