Ocin - I’m a bit late but I live in Dubai. PM me if you still need help.
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
posted 17 Jun 2022 13:29, edited 17 Jun 2022 13:29
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
17 Jun 2022 16:41
posted 17 Jun 2022 21:27, edited 17 Jun 2022 21:27
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
17 Jun 2022 22:16
Can remember letting them go at a car boot sale approximately 8 years later for 7 quid - prolly wore 'em 5 times
29 Jun 2022 09:53
posted 29 Jun 2022 11:24, edited 29 Jun 2022 11:24
29 Jun 2022 11:57
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.
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
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
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
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
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
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!
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!
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
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
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.
Sign in to post in this thread.
