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: 5471
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

This answer was rated:

For RRjha only, I have another question for you. I
have data in column A and would like a macro to look throught his data; for example -22 will be placed in the J column and it will show how many times it was found in Column A and place the occurrence in column K; this would do this for all the numbers in Column A but if it sees a number say -22 again it will skip this as it allready shows how many times it had occurred allready. This would be done for Column B placing the -16 into Column L and how many times it had occurred in Column M. then column C placing the -6 into N and placing the occurence of this number in to O. this will continue for D and E and F. I will be adding data so I would like macro to adapt to this. http://ge.tt/21i5vEy/v/0

thanks!

Hi, I'm Josie and I am a moderator for this topic. I sent your requested professional a message to follow up with you here, when he is back online.

If I can help further, please let me know. Thank you for your continued patience.

Customer: replied 3 years ago.

ok thanks


 

Hi,

Received the file. I'll work on it and get back to you.
Customer: replied 3 years ago.

ok thanks

Anytime
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5471
Experience: B.Tech
R.R. Jha and 2 other Homework Specialists are ready to help you
Customer: replied 3 years ago.


ok it works, this was also to be done on the F Column. thanks

I see
Updated the link, please download it again.
Customer: replied 3 years ago.

job well done! thanks again! I will have more questions in the future!

Most welcome!