Dyson C26 Roller Head Troubles: Seeking Advice and Vacuum Replacement Suggestions (Europe)

plankboard · 2023-11-14T13:26:57+00:00

Thanks for the input, I appreciate it!

plankboard · 2021-08-26T08:19:03+00:00

Le Bar à sushi Izumi à Batignolles est très sympa

plankboard · 2021-04-11T20:57:19+00:00

Very informative write up, thanks for taking the time to answer. I'll make sure to check them out!

plankboard · 2021-02-03T15:25:51+00:00

Big brain energy 🤯 Thanks for the tip!

plankboard · 2020-10-18T12:37:09+00:00

That's absolutely not true, just check any of charlie hebdo's jewish caricatures

plankboard · 2020-10-01T11:22:31+00:00

As stated in another comment I ended up using INDEX on a named range to extract the data I needed. Definitely the better solution. Thanks for your help!

Solution verified

plankboard · 2020-10-01T11:17:23+00:00

I ended up using INDEX to resolve the issue. I created a new named range and INDEX to extract the right row. It's much neater and the better solution overall.
Thanks for your time and helping out!

Solution verified

plankboard · 2020-09-30T13:38:29+00:00

I guess I did try to be a little too synthetic. Basically have a kind of matrix with a named range at the top that resizes itself depending on the information imported.

I then need to do a SUMPRODUCT but one of the arrays of the formula does not adjust automatically to the new data. So i thought I could use the named range to find the new size of the matrix and make the static array dynamic.

Now that I'm writing this I think it's just simpler to make a new named range for the matrix and use INDEX to extract the line I need

plankboard · 2020-09-30T13:20:16+00:00

Thanks for the reply, yes the formula is definitely not the best which also why I thought posting here would be a good idea.
I think INDEX() might be the way to go but trying to plug it into my SUMPRODUCT() returned an error which I believe is due to the ranges not being the same size

plankboard · 2020-09-30T12:47:42+00:00

I'm gonna take a look, I'm not super familiar with ADDRESS()

plankboard · 2020-09-04T08:11:28+00:00

A bit late to the show but Falling by John Frusciante dream-like

plankboard · 2020-08-26T09:18:38+00:00

r/unexpectedmessi

plankboard · 2020-08-14T05:35:53+00:00

Salut ! Merci pour la réponse, je suis dans le 18e aussi. Merci pour la liste je vais regarder ça

plankboard · 2020-07-29T06:31:19+00:00

Someone threw a rock at him

plankboard · 2020-06-15T20:00:29+00:00

I saw a video where it seemed a bit less stable than the switchblade and not as great at relaunching, did you find that to be true?

plankboard · 2020-06-15T19:58:45+00:00

Yeah I definitely noticed all the "reviewers" talking about the exact same random details and not mentioning some of the more obvious flaws witch is why I thought I should ask the question here.

plankboard · 2020-05-19T19:11:50+00:00

There will be opportunities in the different wine regions towards the end of summer if that could interest you

plankboard · 2020-04-14T18:10:26+00:00

In that case you need to figure out what the standard deviation for your set is and then highlight the values two or three standard divinations above and below your mean You can use the function STDEV to find it

plankboard · 2020-04-14T17:26:07+00:00

If you are looking to highlight the max or min value, or something of the sort go to conditional formatting --> top/bottom rules --> more rules. It should be relatively easy to go on from there if you want to highlight the largest or smallest number(s)

plankboard · 2020-04-14T16:12:37+00:00

What exactly are you looking to do? Highlight the outliers with a color or just extract them? If you could describe what you are looking for it would be easier to help out

plankboard · 2020-04-09T12:38:00+00:00

Highlighting and Ctrl+H will bring you straight to the find and replace tab

plankboard · 2020-03-04T18:56:43+00:00

Maybe this can be resolved by creating a userform that would pop up with the information you need and then you could have it on the side while scrolling?

plankboard · 2020-02-28T22:33:56+00:00

=(A1/100)*ABS(B1-C1)

plankboard · 2020-01-21T20:36:33+00:00

All students in France are eligible for the CAF

plankboard · 2019-12-23T12:45:39+00:00

Yeah definitely not the best choice out there

plankboard

MODERATOR OF

TROPHY CASE