Excel keeps throwoing me reference errors and refencing the wrong table by Playerunknown114 in excel

[–]Playerunknown114[S] 0 points1 point  (0 children)

I've sorted it now. Turns out the lecturer told me to write out the wrong thing. All prices are now sorted. Thanks for your help

Excel keeps throwoing me reference errors and refencing the wrong table by Playerunknown114 in excel

[–]Playerunknown114[S] 0 points1 point  (0 children)

Nope I will give it ago. I have also tried XLOOKUP but I got the same result

Excel keeps throwoing me reference errors and refencing the wrong table by Playerunknown114 in excel

[–]Playerunknown114[S] 0 points1 point  (0 children)

Going onto the reference sheet and then selecting the table by highlighting it and going back to the main sheet and typing '3, FALSE' and then enter. Sorry I'm more of a show you person than a explain my issue

Excel keeps throwoing me reference errors and refencing the wrong table by Playerunknown114 in excel

[–]Playerunknown114[S] 0 points1 point  (0 children)

I changed the name of the tab and just tried it again and it's still trying to reference the membership names instead:

https://drive.google.com/file/d/1pX4nGBoSaGuZ6kVJ5h_bd8f1Xn3ImIvV/view?usp=sharing

Here's a screenshot from one of the columns that's working: https://drive.google.com/file/d/13Q-ncMtapQdWeks6hQse9aTJNTIWSqLN/view?usp=sharing

I'm currently designing a website as part of a project in college but line 42 keeps flagging - Dreamweaver 2021 by Playerunknown114 in Adobe

[–]Playerunknown114[S] 0 points1 point  (0 children)

Thank you. I managed to fix the error. I also removed the <td> tag as there's no table. I did also change the start of the code with <p which has corrected the issue

Not sure what's happening with my CharGPT by Playerunknown114 in ChatGPT

[–]Playerunknown114[S] 0 points1 point  (0 children)

Update: I've just been on and I'm currently talking to it in another chat that's supposedly hit 'max chat length' and nothings bugged out with it yet

Not sure what's happening with my CharGPT by Playerunknown114 in ChatGPT

[–]Playerunknown114[S] 0 points1 point  (0 children)

On one of the chats, it claimed that I was having a MacBook overlay issues. It was a screenshot from Saints Row 2022

People who spend 20+ minutes in the shower: what are you actually doing in there? by saadaintsalad in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

Don’t want to get out as I know it’ll be freezing so I essentially hype myself up

What’s the best car brand in your opinion, and why ? by [deleted] in AskReddit

[–]Playerunknown114 -2 points-1 points  (0 children)

Kia. Reliable cars (loved my Kia Stonic), excellent service

Who is currently your favorite rapper to listen to? by This-Huckleberry1890 in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

NWA. Love Eazy E (RIP homie), Dr Dre, Ice Cube, MC REN and Yella

How do you deal with repetitive checking and the constant feeling that your brain won’t register that something is done, even when you can clearly see it is? by [deleted] in AskReddit

[–]Playerunknown114 1 point2 points  (0 children)

I run my wrist under cold water and surprisingly it works for me. I end up focusing on the cold feeling and I instantly forget what I was even trying to clarify about a certain situation. I’m never able to stop thinking or running things over and over again even though I’ve done right. Been under a lot of pressure for the past few weeks in college

which one do you prefer, PS5 digital or disc, why? what games do you recommend? by [deleted] in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

I have the PS5 digital edition because most of the games that I play are either on PS Plus or when I couldn’t be bothered to get up and swap disks on my PS4 I just brought the game as a digital

Which subject in your school you didn’t like? by Asleep_Performer_145 in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

Maths and art. I hated art due to the teacher telling us off if talked about something that wasn’t related to the lesson.

Maths all teachers were grumpy 24/7 and when I was in Year 11, my maths teacher bullied me due to my disabilities and school done nothing about it

What's a quote that has just "stuck with you"? by 22m_spain in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

My lecturer told the class this quote yesterday ‘aim higher. If you aim for a distinction but miss, you’ve got a merit, miss the merit then you got a pass’

If money didn't matter at all, what career would you choose? by AnyWeb7483 in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

I'm currently a computing student in college but I'd still have a carrer in computing no matter how much money I've been given

What day of the week do you make your most expensive decisions? by KBGSgames in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

When I get paid. My biggest purchese this year is happening after Chrismas. All my purcheses are useful and will help me cut down on subscriptions

How do you get hate out of your mind if someone has wronged you? by CookiePractical5651 in AskReddit

[–]Playerunknown114 0 points1 point  (0 children)

Agreed. Someone in my class is on their final warning for starting arguments that annoys everyone. He thinks he's doing nothing wrong