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: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 years 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 2 years ago.
The ID number is ***** 385308
Customer: replied 2 years 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 2 years ago.
ok, ill look at the file and get back to you
Expert:  Richard replied 2 years 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.

Related Microsoft Office Questions