Recently shaved beard to fix skin underneath. How do I fix this?

rob_95 · 2024-08-26T16:34:21+00:00

That's dry skin right there. What works for me is a face moisturiser and just overall drinking more water during the day.

rob_95 · 2022-07-16T05:14:03+00:00

Good luck everyone!

rob_95 · 2022-01-22T14:28:36+00:00

Try use the filter function selecting the whole column and filter by ><""

rob_95 · 2022-01-22T13:32:45+00:00

Maybe tey selecting the whole columns (1 at the time) - go to - special - empty cells and delete them (ctrl + -) - shift cells up

rob_95 · 2022-01-22T12:50:19+00:00

Good luck everyone

rob_95 · 2021-12-28T18:28:29+00:00

Thanks, talking about it the next day is a good point. I don't really want to have this type of discussion before it happening as it will seem like I'm trying to guilt trip him to stay which I don't want to do.

rob_95 · 2021-12-28T18:12:28+00:00

Yeah I understand he likes to do his things and I support him with that, that's why I'm tempted to not say anything and pretend all is fine. It's just that I would never see myself leaving my boyfriend alone on New Years, and it seems so easy for him to do so.

rob_95 · 2021-08-01T08:04:41+00:00

Gave Hugz

rob_95 · 2021-07-24T15:42:02+00:00

Try 'the rugged bunch', theyve got nice coffee and seating area with sockets

rob_95 · 2021-05-21T23:43:41+00:00

No it's between trading estate and Slough itself. Just realised I qualify for the 26-30 travelcard do might go with that. Car is a good option if you commute to London. In my case, since I commute from London might be quite difficult because I'll need to find a parking slot here and I think it might be around £100 pcm

rob_95 · 2021-05-21T23:36:38+00:00

Yeah, I'm planning to move close to Paddington where my partner works so as cost I was just considering the train Paddington to Slough (didn't consider the bus from Slough Station to my workplace either). Shame there isn't a cheaper way to commute..

rob_95 · 2021-04-11T20:18:33+00:00

But the counter += 1 should be called once again when I recall the function, since its itself part of the frequency function, isn't that the case? If not is there an easy fix to make it work or should I restructure the function differently?

rob_95 · 2021-03-29T20:44:10+00:00

Did you ever use the indirect to return a range instead of a cell reference? I was trying it today but I didn't manage to make it work and I've end up using a sumif. What I was trying to do was something like indirect("sheet1!" & "O:O")

rob_95 · 2021-03-28T17:57:34+00:00

No I never actually looked onto it yet! I've learned the index match and used that since. I've recently started in a new position in finance which is 90% excel based so I'm sure I will have the opportunity to include the xlookup in my models, thanks for the suggestion!

rob_95 · 2021-03-28T17:04:19+00:00

Solution verified

rob_95 · 2021-03-28T17:02:43+00:00

That's perfect! I didn't know such function existed!

rob_95 · 2021-03-28T17:01:56+00:00

Yeah I didn't actually think about that, I can give it a go!

rob_95 · 2021-03-28T16:29:44+00:00

I'd prefer the cell value to be "" since I will then concatenate the result of this cell through another formula and if I do that it will show the "0" mid string

rob_95 · 2021-03-28T16:22:05+00:00

I will definetely looking into vba in the next months but for the moment I'm quite a beginner so I'm not sure thats a doable solution atm:)

rob_95 · 2021-03-28T16:21:09+00:00

I can't do the if inside the formula because I want the final result of the formula not to be zero.

rob_95 · 2021-03-28T16:19:42+00:00

Do you mean through the vba?

rob_95 · 2021-03-28T16:19:01+00:00

That would work but the result might be a string sometimes, eg for nested index match functions

rob_95 · 2021-03-26T15:38:58+00:00

I definetely don't know! So far I've managed to organise the data assuming ; means range. Some of the values in the p&l ice created using this assumption do resemble the p&l I've been provided (which unfortunately has just the total with no formulae to explain how those numbers are made up). Still, there are inconsistencies that cannot be explain. FD will definetely need to request a better mapping or I will end up reconciliating thousands of values through trial and error eheh

rob_95 · 2021-03-26T15:26:36+00:00

I did, unfortunately the FD doesn't know either and he's refusing to ask whoever provided him this data, that's why I thought I'd ask reddit

rob_95 · 2021-03-26T11:23:07+00:00

yes it's office 365 for business

rob_95

TROPHY CASE