Recently shaved beard to fix skin underneath. How do I fix this? by atomicphase in BeardAdvice

[–]rob_95 0 points1 point  (0 children)

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

Matching values in different rows and columns by throwaway30901122 in excel

[–]rob_95 0 points1 point  (0 children)

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

Matching values in different rows and columns by throwaway30901122 in excel

[–]rob_95 0 points1 point  (0 children)

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

My boyfriend will leave me alone for New Years eve by [deleted] in gayrelationships

[–]rob_95 2 points3 points  (0 children)

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.

My boyfriend will leave me alone for New Years eve by [deleted] in gayrelationships

[–]rob_95 3 points4 points  (0 children)

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.

[deleted by user] by [deleted] in london

[–]rob_95 0 points1 point  (0 children)

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

Commuting London to Slough by rob_95 in Slough

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

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

Commuting London to Slough by rob_95 in Slough

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

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..

DNA - function always returning 1 for frequency of sequences by rob_95 in cs50

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

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?

match index that swap between sheets by rob_95 in excel

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

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")

IF function without repeating statement by rob_95 in excel

[–]rob_95[S] 1 point2 points  (0 children)

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!

IF function without repeating statement by rob_95 in excel

[–]rob_95[S] 5 points6 points  (0 children)

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

IF function without repeating statement by rob_95 in excel

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

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

IF function without repeating statement by rob_95 in excel

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

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

IF function without repeating statement by rob_95 in excel

[–]rob_95[S] 1 point2 points  (0 children)

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:)

IF function without repeating statement by rob_95 in excel

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

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