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

Richard
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32264
Experience:  Over 15 years of consulting to the IT industry
32989067
Type Your Computer Question Here...
Richard is online now

have uploaded it as http://wikisend.com/download/506262/roger

Resolved Question:

have uploaded it as


http://wikisend.com/download/506262/roger march 13 op.csv




and
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
Thanks

Looking at it now Roger

Customer: replied 2 years ago.

have uploaded it as


 


http://wikisend.com/download/506262/roger march 13 op.csv


 


 


 


M £ requires value from D only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y


 


 


 


N = Euro value from D only when order number A


 


=amz028, amz403,amz302, amz402, amz304, amz404, and J=Y


 


 


 


 


 


O = $ value from D when L = Y and order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,


 


amz108, amz109, amz110, amz111, amz112, and OP


 


 


 


P = yen value from D when L = Y and order number =A =amz249, amz503,


 


 


 


Q= £non requires value from c only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y


 


 


 


R = euronon Euro value from C only when order number A


 


=amz028, amz403,amz302, amz402, amz304, amz404, and J=Y


 


 


 


S=$ non


 


O = $ value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,


 


amz108, amz109, amz110, amz111, amz112, and OP and J=Y


 


 


 


 


 


P = yen value from C when order number =A =amz249, amz503, and J=Y


 


 


 


thank you roger


 


 




Expert:  Richard replied 2 years ago.
Thanks

Doing it now for you, will let you know when it is done.

Customer: replied 2 years ago.

entered the formulas but they show blank see this upload to you


also no formula in S and T


 


 


 


http://wikisend.com/download/577116/roger march 13 op.csv

Expert:  Richard replied 2 years ago.
You never specified S & T Roger.

Look above and you see this.

What do you need for S & T?
Customer: replied 2 years ago.

T = yen value from C when order number =A =amz249, amz503, and J=Y


 


S = $non value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,


 


my mistake


 


but there were no values in any of formulas MNOPQRst when run down sheet


 

Expert:  Richard replied 2 years ago.
Roger,

Your not looking at my sheet, I gave you a .xls file as it needs to be this.

Your not looking at the sheet I gave you

Customer: replied 2 years ago.

what was down load number


thank you roger

Expert:  Richard replied 2 years ago.
It wasn't Roger, as its not even the same name file.

I will re-give it, it is

182530

It has the extension .xls

Customer: replied 2 years ago.

it still does not collect any data as required


 


also please enter the S and T formulas


 


T = yen value from C when order number =A =amz249, amz503, and J=Y


 


 


 


S = $non value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,

Expert:  Richard replied 2 years ago.
Not before I understand how it does not collect any data required.

Give an example please.

Customer: replied 2 years ago.

formulas do not work at all see your 182530 download


nothing works


thank you

Expert:  Richard replied 2 years ago.
If I set the criteria to meet the conditions they work for me.

So Roger, a proper clear example, with Row and Cells of one that is not working.

Customer: replied 2 years ago.














amz026-9711128-0585100########21.8117.814AMAZONPAIDAUY
Expert:  Richard replied 2 years ago.

amz026-9711128-0585100 is not amz026

Customer: replied 2 years ago.

http://wikisend.com/download/104232/Book3 test.xlsx


that is not showing any values

Expert:  Richard replied 2 years ago.
Roger, Look at the ID number, it does not match what you wanted the formula to match
Customer: replied 2 years ago.

well how do we put this number in can split the row to 5 letters


how to do this

Expert:  Richard replied 2 years ago.
I dont understand your response Roger.

Sorry, but I did a lot of work on this, and I feel you are not really making an effort to explain your requirements.

You are showing me sheets with ID's that do not match what you asked me to do.

eg:M £ requires value from D only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y

And your not telling me everything you want at the start.

I kindly ask roger you take the time and effort to explain what it is you want, in completeness.

Customer: replied 2 years ago.

sorry that is because I am 80 years old etc. dealing with this spread sheet with four currencies and even different order numbers fior each currency


it seems now that the order numbers "amz etc" in cell a I gave you will have to be split into another cell so that the formula will pick up the different order number sequences.


 


this should make it work will it not as we can not have any more order number ids


thank you roger

Expert:  Richard replied 2 years ago.
yes, but give me some time as I need to redo all the formulas again
Expert:  Richard replied 2 years ago.
Done Roger, also S and T added.

File ID is 410940

Let me know if you have any difficulties please
Customer: replied 2 years ago.

that looks like it but will check it out tomorrow thank you roger

Expert:  Richard replied 2 years ago.
No problem Roger.

The question stays open, so any problems, just let me know

If you would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32264
Experience: Over 15 years of consulting to the IT industry
Richard and 10 other Computer Specialists are ready to help you

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:

    151
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | 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:

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

    53
    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.