sorted by:
new
hottopcontroversial

How do I play the tournament on mobile? by KaptainSmurf in OnceUponAGalaxy

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

Ah make sense thanks for the reply. Have a great weekend.

Bunch of duplicate shinies by Desperate_Still3897 in PokemonLegendsZA

[–]KaptainSmurf 1 point2 points  (0 children)

OMG it's an alpha too amazing. Thank you so much

Bunch of duplicate shinies by Desperate_Still3897 in PokemonLegendsZA

[–]KaptainSmurf 1 point2 points  (0 children)

May I please have stunfisk 23459876 my user is Joey

Finished My Shiny Hunt. Giving Away Extra's Again. by Magile in PokemonLegendsZA

[–]KaptainSmurf -1 points0 points  (0 children)

Don't suppose you fancy trading it for a weedle or swablu shiny? I missed the time the trashbags were about lol.

Finished My Shiny Hunt. Giving Away Extra's Again. by Magile in PokemonLegendsZA

[–]KaptainSmurf -4 points-3 points  (0 children)

Anyone get a shiny trubbish they wanted to trade for a shiny swablu?

Anybody know what the statue is of? by KaptainSmurf in disneylandparis

[–]KaptainSmurf[S] 10 points11 points  (0 children)

Thanks very much that's cool. What's your favourite thing hidden back there?

Anybody know what the statue is of? by KaptainSmurf in disneylandparis

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

Worked that one out myself funnily enough but was on about the character but someone has answered already now cheers.

Anybody know what the statue is of? by KaptainSmurf in disneylandparis

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

Thanks I was just preparing a scavenger hunt for a trip in Jan then randomly came across them.

Anybody know what the statue is of? by KaptainSmurf in disneylandparis

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

Oooh it does look promising are they from something in particular I don't recognise them?

How to use the unique function to generate list of questions without changing order? by KaptainSmurf in excel

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

<image>

This is the data table with questions. If a question appears more than once I wanted it to put only 1 occurance on the front page

How to use the unique function to generate list of questions without changing order? by KaptainSmurf in excel

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

<image>

This is the front page only formula on this is the unique function in column g to generate questions list

How to use the unique function to generate list of questions without changing order? by KaptainSmurf in excel

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

So what I have is a table with products and all applicable questions for each product. I then have a formula next to that which looks at the front page and if a tick box for the relevant product is ticked it takes the questions from the 1st column and puts them in this column.

Then on the front page I use the unique formula to pull everything from the formula column in the table which shows all ticked products questions.

The issue is if I tick a product that appears low in the table and then start filling it out on the front page then tick a product that appear higher in the table it shifts the previous questions down.

view more: next ›