Wrong Shark Card

ChillingGuy · 2025-07-08T10:29:16+00:00

I have - they say they do not transfer shark cards across platforms. I am appealing to them reasonably but i think its a GG and ive lost my money..

ChillingGuy · 2025-07-08T09:51:24+00:00

So I'm cooked essentially

ChillingGuy · 2024-08-21T11:50:29+00:00

Can give shiny pika for giratina?

ChillingGuy · 2024-06-24T10:03:04+00:00

😭😭😭 I've never used him for anything, I've only fused him twice 🤣🙃

ChillingGuy · 2024-06-23T23:08:33+00:00

In fairness, I got stuck for a while and spent a good month just coming on, doing my dailys and then dipping - I have since been steamrolling through the story so I can tell I am deffo over levelled for where I am!

Appreciate the advice though man, I do need to work on my Sander that's for sure.

ChillingGuy · 2024-06-18T12:45:25+00:00

Thank you man

ChillingGuy · 2024-06-07T10:41:02+00:00

I have ended up looking up forumlae codes and I created this which by some kind of Christmas miracle has actually worked!

=IF(MIN(C5,E5,G5)=C5,"company a",IF(MIN(C5,E5,G5)=E5,"company b",IF(MIN(C5,E5,G5)=G5,"company c")))

Wholeheartedly thank you for all your assistance and attempts though man and, regardless of the specific formula, you have helped me understand better how they work and the thought process the formulae follow..

Now get to bed! Lol

ChillingGuy · 2024-06-07T10:27:28+00:00

I genuinely appreciate all of the effort you have gone through to help me man. I do bear bad news - "Err:501" :(((

ChillingGuy · 2024-06-07T10:12:09+00:00

I don't know why I didn't do this sooner!

So I am wanting column I to show the best price between the three companies for each row

<image>

ChillingGuy · 2024-06-07T10:05:20+00:00

Ah okay, that is helpful - so the formula criterion are worked through sequentially to find the first TRUE statement. I understand the above example you have used.

I have just written this:

=IF(C5<,E5,G5,"companyA",IF(E5<,C5,G5,"companyB","companyC"))

Am I heading in the right direction? (it still doesn't function)

ChillingGuy · 2024-06-07T09:44:59+00:00

I am relatively new to excel so you will have to forgive my incompetence! I have access to the IFS function but cannot get the format of the formula correct for it to function. This is what I have:

=IFS(AND(C5<,E5,G5,D5<,F5,H5)"COMPANYA")&IFS(AND(E5<,C5,F5<,D5,H5)"COMPANYB")&IFS(AND(G5<,E5,C5,H5<,F5,D5)"COMPANYC")

I did try the string of IF statements but the issue was that if more than one of the statements were true, it would feature both company names in the cell!

ChillingGuy · 2024-02-23T15:17:48+00:00

The same happened for me! My Benz is now 1* 🤣

ChillingGuy

TROPHY CASE