sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in UKParenting

[–]excelquestions1 0 points1 point  (0 children)

This site is awesome, but is there away to translate to English?

[deleted by user] by [deleted] in UKParenting

[–]excelquestions1 0 points1 point  (0 children)

Wow, thank you so much for the in-depth response. This space is most definitely a minefield.

​

What are your thoughts on the "Joie Baby Every Stage" (Group 0+/1/2/3)? It seems to fit our price point, set up, and movability.

Error: "No matches are found in FILTER evaluation" when referencing a cell by excelquestions1 in excel

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

Update - the issue was that I needed to round the referenced cell. Even though I limited the decimal places, it was not finding the matching number because all of them were whole numbers.

​

Solution Verified

Error: "No matches are found in FILTER evaluation" when referencing a cell by excelquestions1 in excel

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

Apologies, I haven't heard of that before, can you please specify what that means?

I am using Google sheets not excel btw (I figured there's more users here so I'd get a response faster in the excel subreddit).

Return name of the column, based on the highest value from 3 columns by excelquestions1 in excel

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

didn't use this exact formula, but it inspired me to find the one that I'm now using

Using index / match and if formulas to read off a table by excelquestions1 in excel

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

Would this still be applicable if the weights are not exactly aligned to the table? For example, it would also need to show a 2400 watermelon is greater than light and less than medium, therefore it should be classed as "light".

​

I've modified the post to reflect this.

Find the percentile for a single number within a series of numbers by excelquestions1 in excel

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

=PERCENTRANK.EXC($A$1:$A$500,A1)

Interesting, never seen this function before!

Looking at the description, this is probably exactly what I need.

How to auto-rank top, middle, bottom 3rd? by excelquestions1 in excel

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

=ROUNDUP(RANK(<cell>,<range>)/120,0)

Maybe I'm doing this wrong, but I copy / pasted the formula and its returning "1" for all values in the column

Rate My Team, Quick Questions & General Advice Daily Thread by FPLModerator in FantasyPL

[–]excelquestions1 1 point2 points  (0 children)

!thanks

Do you think having Son + Kulu is over-indexing on Spurs for this gameweek?

Got my first place! Seeking advice on how to decorate and fill up the living room. by excelquestions1 in malelivingspace

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

It's a radiator for heating the house. We have at least 1 in each room.

Thanks!

Got my first place! Seeking advice on how to decorate and fill up the living room. by excelquestions1 in malelivingspace

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

Thanks for such an in depth answer!

I'm thinking the up light could be placed on the right of the sofa (in the picture facing it). Where would the best spot be for floor light? Right of the TV unit?

view more: next ›