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: 36526
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: 3 years ago.
Category: Computer
Expert:  Richard replied 3 years ago.
Thanks

Looking at it now Roger

Customer: replied 3 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 3 years ago.
Thanks

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

Customer: replied 3 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 3 years ago.
You never specified S & T Roger.

Look above and you see this.

What do you need for S & T?
Customer: replied 3 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 3 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 3 years ago.

what was down load number


thank you roger

Expert:  Richard replied 3 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 3 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 3 years ago.
Not before I understand how it does not collect any data required.

Give an example please.

Customer: replied 3 years ago.

formulas do not work at all see your 182530 download


nothing works


thank you

Expert:  Richard replied 3 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 3 years ago.














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

amz026-9711128-0585100 is not amz026

Customer: replied 3 years ago.

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


that is not showing any values

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

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


how to do this

Expert:  Richard replied 3 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 3 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 3 years ago.
yes, but give me some time as I need to redo all the formulas again
Expert:  Richard replied 3 years ago.
Done Roger, also S and T added.

File ID is 410940

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

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

Expert:  Richard replied 3 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 and 4 other Computer Specialists are ready to help you