General Discussion: The life advice thread. Never do, say, eat or drink anything without asking how to do it in here first!


Show original post
Trent
Trent avatar

2045 posts since 18/1/09

17 Jun 2022 12:35
Ocin - I’m a bit late but I live in Dubai. PM me if you still need help.
Mancunia
Mancunia avatar

921 posts since 29/10/12

posted 17 Jun 2022 13:29, edited 17 Jun 2022 13:29
RickRude wrote: Hayfever is insane today - what’s everyone’s go to solution atm?

try quercetin mate, a good non-pharma allergy relief

whenever you get symptoms take 2-3 tablets, should clear it up within an hour or so

https://welleasy.co.uk/products/time-health-quercetin-maximum-bioavailability-120-capsules?variant=39624538849464¤cy;=GBP&utm;_medium=product_sync&utm;_source=google&utm;_content=sag_organic&utm;_campaign=sag_organic
Mancunia
Mancunia avatar

921 posts since 29/10/12

17 Jun 2022 13:30
+ zero drowsiness
zappa1903
zappa1903 avatar

504 posts since 26/8/14

17 Jun 2022 16:22
What would be the best place to sell a lot of clothes, maybe like 100 items mostly vintage things like prada, stoney, cp and a heap of other non fuk approved brands. Original plan was eBay but might be too much of a hassle.

Any other suggestions?
inversesquare
inversesquare avatar

6776 posts since 7/6/08

17 Jun 2022 16:36
Marrkt for some of it
Razorlight123
Razorlight123 avatar

5119 posts since 13/1/10

17 Jun 2022 16:41
Might be worth doing both eBay & inverse's suggestion.

eBay are currently doing 80% off Final Value Fee (FVF usually 10% iirc), which might work out quite well for you.

https://www.rsvp.ebay.co.uk/rsvp/signup/1005975/LjN1BFJ4mUk?mkcid=1&mkrid;=710-53481-19255-0&siteid;=3&campid;=5336549684&customid;=2361798931&toolid;=10001&mkevt;=1
NigelBenn
NigelBenn avatar

4778 posts since 6/2/08

17 Jun 2022 16:47
I still think there should be an in person marketplace event for selling old gear. Especially with the Y2K craze still going strong
zappa1903
zappa1903 avatar

504 posts since 26/8/14

17 Jun 2022 17:04
Never used marrkt so will likely eBay it all, just was wondering if somewhere would maybe buy all to save me selling individually which is going to be a pain and time consuming
Crackajack
Crackajack avatar

8200 posts since 21/4/05

17 Jun 2022 20:19
zappa1903 wrote: Never used marrkt so will likely eBay it all, just was wondering if somewhere would maybe buy all to save me selling individually which is going to be a pain and time consuming

Speak to places like Dukes Cupboard or Rag Parade Contemporary. Marrkt don't usually carry those brands.
inversesquare
inversesquare avatar

6776 posts since 7/6/08

17 Jun 2022 20:34
Stick some of it up on here?
zappa1903
zappa1903 avatar

504 posts since 26/8/14

posted 17 Jun 2022 21:27, edited 17 Jun 2022 21:27
inversesquare wrote: Stick some of it up on here?

Don't think it would be things that would sell on here and no GJ because not sure if working

But plenty of things looking to offload for bargains such as prada SI Burberry etc rest is brands with no interest here but too good for charity shop such as boss evisu Paul smith etc which is nearly new. Only doing on behalf of my brother as he also can't be bothered
NigelBenn
NigelBenn avatar

4778 posts since 6/2/08

posted 17 Jun 2022 21:59, edited 17 Jun 2022 21:59
Evisu sells for good money atm
zappa1903
zappa1903 avatar

504 posts since 26/8/14

17 Jun 2022 22:07
Yeah managed to sell 7 pairs of jeans for about £600 not long ago but now mostly shirts and trainers, got a pair of near dead stock puma x evisu but think it would be next to nothing so better to give to charity
Burt
Burt avatar

6313 posts since 3/1/10

17 Jun 2022 22:16
NigelBenn wrote: Evisu sells for good money atm
Bought a pair of Evisu's from Monty Smith in Cheltenham in about 94/95 - they were £140; the bird that I was seeing at the time thought I was nuts.

Can remember letting them go at a car boot sale approximately 8 years later for 7 quid - prolly wore 'em 5 times Cry
TROYBOY
TROYBOY avatar

1136 posts since 28/2/12

20 Jun 2022 10:43
AHHHH
Seventyfour
Seventyfour avatar

9593 posts since 6/10/05

20 Jun 2022 19:14
Anyone know where I can buy antibiotics online without fucking about with doctors
Dreep
Dreep avatar

1907 posts since 29/7/08

20 Jun 2022 19:15
alpha
swiftus
swiftus avatar

1873 posts since 1/7/09

29 Jun 2022 09:53
Any Excel geeks on here?

Trying to solve a problem, and no idea how to do it.

I basically have two tables.

Table 1 has two columns (Product and Batch Code)

Table 2 has a column for each Product. In each of the cells under the Product, I want to be able to use a drop down list to select the appropriate Batch Code for that Product.

For example,

Table 1:

Product Batch Code
Apple AP1
Banana BA1
Apple AP2
Apple AP3
Banana BA2
Pear PE1

Table 2:

Apple Banana Pear
(Choose from AP1,AP2,AP3) (Choose from BA1,BA2) (Can only select PE1)

Posted in hope more than anything!
Razorlight123
Razorlight123 avatar

5119 posts since 13/1/10

posted 29 Jun 2022 11:24, edited 29 Jun 2022 11:24
You should be able to use three things by the sounds of it, if I've got what you're trying to do correctly

i.e. selecting a product from a list in Cell A1, gives the user the option to choose from a list of batches in Cell B1, based on the product selected.

Things to use:
- named_range
- Define list
- and IF statements which will say IF(A1="apple", prsent-listA, IF(A1="pears", present-listB, etc etc)

Ideally you would want to soft code the A1="apple" part to like A1=Product1

You can then easily update what product 1, is over time without needing to change the formula. E.g. you stop selling apples and now start selling satsumas instead.

This is where named range comes in
swiftus
swiftus avatar

1873 posts since 1/7/09

29 Jun 2022 11:57
Razorlight123 wrote: i.e. selecting a product from a list in Cell A1, gives the user the option to choose from a list of batches in Cell B1, based on the product selected.

Kind of, but a little different. The products aren't selected. They are the (fixed) headings in the second table.

The first table is also being continually updated with more products and batch codes.