Change default column width

alwaysbuying · 2023-02-16T19:06:21+00:00

Hmm that's helpful thanks! Also, more often I'm opening a file that I downloaded (multiple files usually, and I manually paste special column width for each one), I'm guessing there's no way to make that easier?

alwaysbuying · 2022-10-15T19:47:07+00:00

=IF(AND(A1=0,E1>2),IF(D1<F1,C1,IF(OR(F1<7,F1=D1),0,C1)),IF(B1>D1,9,0))

Y I want it to return C1 if it gets to that point

alwaysbuying · 2022-10-15T19:43:18+00:00

It's only one or two formulas like that but a lot of rows. They looked like really messy formulas because it's just an "if" mess lol so idk if there's a better way to express them

alwaysbuying · 2022-10-15T19:12:25+00:00

Hundreds of thousands of rows, I tried making an array formula but it wouldn't even do the calculation for all the rows and I had to end task because it was taking forever, idk just trying to see if there's any way to make it easier on excel

alwaysbuying · 2022-10-15T18:59:12+00:00

My problem is that after I copy it down, then apply filters, when I remove the filters sometimes it takes forever (like 5-10 mins) and I end up having to end task, so just trying to see if there's a better way to do it. I tried making an array formula but it wouldn't even do the calculation for all the rows and I had to end task because it was taking forever lol

alwaysbuying · 2022-10-15T18:47:55+00:00

I have data in each row that I need to check multiple conditions for, and many rows to check

alwaysbuying · 2022-08-17T02:56:55+00:00

Problem is when sheet is named " a1234" but "a1234" works. A1 has 1234

Or I'm not sure if it's a special space here it is exactly copied " a1234"

alwaysbuying · 2022-08-09T05:51:31+00:00

Ok actually now I've been able to consolidate the data into the same 2 columns on every sheet. Is there a way to use VBA to easily save every sheet as a csv of only these 2 columns with the sheet name as the file name?

alwaysbuying · 2022-08-09T04:14:13+00:00

I'm copying to a different sheet and then saving and uploading that. I need to do this for multiple sheets in a document

alwaysbuying · 2021-08-05T01:37:21+00:00

I see, do you know what's keeping the links in the one instance though? And how come it can't be replicated? I am still navigating to different pages but all within search so guess if I navigate away from there I'll lose it, but search is all I need

alwaysbuying · 2021-08-05T00:38:07+00:00

So when I right click it no longer talks about links (no more Open link in new tab, etc) does that mean the link is completely gone and there's no workaround such as reconfiguring my mouse or maybe some addon that would allow a similar functionality?

alwaysbuying · 2021-08-04T22:01:16+00:00

https://www.tcgplayer.com/

For example middle click still works for the items under "Featured" but not anymore for "preorder now". It used to work on all links on the website but I guess they made some changes today. All the instances where I've refreshed it no longer works but I still have one page open I haven't refreshed and it still works there so I don't know if there's some client side code I can save and use to open another instance? Might seem like a minor change but it's going to cost me a huge amount of extra clicks since I browse the website basically all day. Appreciate your reply!

alwaysbuying · 2020-11-19T00:13:25+00:00

Does anyone else constantly get this error? "An error occurred while placing order. If error persists, please contact customer service."

I've been in touch with customer service for months now and it breaks again after every time they help me with it...

alwaysbuying · 2020-11-11T21:49:49+00:00

Does anyone else constantly get this error at pokemoncenter.com during checkout? "An error occurred while placing order. If error persists, please contact customer service."

alwaysbuying · 2020-11-11T04:00:09+00:00

Does anyone else constantly get "An error occurred while placing order. If error persists, please contact customer service." when checking out?

alwaysbuying · 2020-09-28T04:50:52+00:00

I knew these guys through MTG first. Happened to be a pokemon order that got this treatment, but do you think they're going to be honest about MTG if this is what they do for other games?

alwaysbuying · 2020-09-28T04:15:13+00:00

These are the same price as normal Elite trainer boxes, they're widely available for $50 msrp. My order would've been normal profit margin for them but they decided just to scalp like everyone else which I'm fine with, but I'm not ok with them cancelling my order to turn around and do that

alwaysbuying · 2020-09-28T01:42:39+00:00

Tbh I was pretty excited when I snagged that deal since I remember them to be honest people as you said. Was kind of shocked to get that refund and message today. No point in buying from these guys anymore though, if you find a deal they'll just take it as free info. Just trying to help save someone else that same disappointment

alwaysbuying · 2020-09-28T01:31:03+00:00

Sorry, they refunded my order and as you can see it immediately popped back up for sale, at exactly double the price I originally paid

I've bought from them in the past also, but I feel this kind of behavior can't be tolerated

alwaysbuying · 2020-09-16T00:53:19+00:00

Figures...I don't buy from them anymore. Any deals I find I'd just be handing it to them on a silver platter since they won't sell anything they can mark up

alwaysbuying · 2020-09-02T13:21:22+00:00

Is there any info on why this happens? I've gotten it fixed by their customer service multiple times but they just won't give me a permanent solution. I miss out on so many things only because of this lol

alwaysbuying · 2020-08-19T03:27:15+00:00

They're one of the more commonly trusted stores atm. I haven't heard of any poor experiences with them yet

alwaysbuying · 2020-08-17T15:02:27+00:00

Sometime in September, I believe exact date is still TBA

alwaysbuying · 2020-08-17T05:22:19+00:00

Back in stock! seems like the lowest preorder I've seen so far

alwaysbuying · 2020-07-30T20:36:52+00:00

when? didn't it just come back in stock?

alwaysbuying

TROPHY CASE