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 NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Looking i think should be a simple sorting

Customer Question

Looking for help for what i think should be a simple sorting formulated solution.
Needing a formulated solution to the problem of columns BR & BX not calculating the correct "lot #". Each lot should contain 6 coils. Some coils are designated by an "x" in the columns D,Q,AD...indicating that they are OS (offspec) and should be accounted
for between columns BW and BC.
Attachment: CLOSEwMACROsEXP.xls
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
Your file did not attach sorry.
Can you provide it by doing the below instructions please.
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 1 year ago.
The ID number is ***** 385308
Customer: replied 1 year ago.
Sorry, but I'm a day sleeper and am about to crash but would you be open to a skype screen sharing or any other screen sharing program so i could talk to you as i point out certain parts of the spreadsheet?
Expert:  Richard replied 1 year ago.
ok, ill look at the file and get back to you
Expert:  Richard replied 1 year ago.
ok, can you give me the sheet that you are referring to in the file.
And in your own words what the formula should be doing please.