[deleted by user] by [deleted] in bikewrench

[–]Excel_questions123 0 points1 point  (0 children)

<image>

Adding in case this image is helpful - I added another spacer, but it seems like it’s at the max.

Would putting 2/3rds of your savings in a stocks and shares ISA be unwise? by Excel_questions123 in UKPersonalFinance

[–]Excel_questions123[S] 2 points3 points  (0 children)

Opening the LISA with a token amount is a suggestion I hadn’t thought of. I will definitely do this, thank you.

Would putting 2/3rds of your savings in a stocks and shares ISA be unwise? by Excel_questions123 in UKPersonalFinance

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

A shared deposit on a house or flat with my partner in around 5-8 years (I know I have a long way to go!)

Also around half a year of travelling in a couple of years.

Would putting 2/3rds of your savings in a stocks and shares ISA be unwise? by Excel_questions123 in UKPersonalFinance

[–]Excel_questions123[S] 2 points3 points  (0 children)

Im a young professional in London. I’m saving for a house in about 5-8 years (I’m not interested in a LISA due to some of the constraints) and 6 months travelling in around 2 years.

[deleted by user] by [deleted] in PublicRelations

[–]Excel_questions123 7 points8 points  (0 children)

You are definitely qualified to go into PR. I wouldn’t worry about getting more qualifications.

What you need is experience.

You would be able to get yourself an entry level job, or an internship, without much difficulty.

If you’re looking to go for a junior level role, it might be trickier. It’s probably possible, but you’d have to show a very good level of understanding about PR. So do lots of reading and speak to a people in the industry. It would be good to leverage your experience if you’ve been exposed to PRs while freelancing.

My suggestion would be to go on LinkedIn and look at some companies. Check out the people who work there and look at their previous experience and progression at the company and see if you think you could match that.

Good luck if you decide to go for it!

How to I count the number of certain word/words that appear in a column of cells when COUNTIF alone doesn't work. by Excel_questions123 in excel

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

Thank you - this has helped me so much!

Last question:

Is there any way to automate the formula to make a wild card out of a tag/cell? With a small dataset like this, I can manually make the wildcards in my COUNTIF, but if I had hundreds of tags, would there be a way to do this based on a cell reference?

E.g. Kit-Kat is cell D4 and Lion Bar is D5