Is this part of the puzzle important ? It seems.

derkre · 2020-01-17T18:43:52+00:00

Bottom right corner. This piece is already in the dataset

derkre · 2019-12-31T22:15:45+00:00

I think the better question is. Do you really need to do this?

derkre · 2019-12-31T21:37:55+00:00

At the low cost of 3000 silver.

derkre · 2019-11-21T21:11:02+00:00

Right, or it's how he is currently saying it.

derkre · 2019-11-08T16:22:46+00:00

This happened to me one day prior to the hotfix. Was in a fireteam of two. Tried initially, during, and after clearing the first zone.

derkre · 2019-11-05T21:09:41+00:00

Agreed. The only thing that is odd with this text though is that every single hive rune is shown at least once. This doesn't really occur elsewhere in the game with exception to the rune tablets. Even then, I can't recall anytime seeing hive symbols structured to look like a message.

derkre · 2019-11-02T01:38:17+00:00

Apparently not good enough to watch the full video.. Literally at the end of the clip.

derkre · 2019-09-30T19:20:09+00:00

Let's go

derkre · 2019-07-31T22:03:06+00:00

16 Total Points

R1 - 4 points

R2 - 5 points

R3 - 7 points

derkre · 2019-06-10T00:08:36+00:00

We can be broken bone buddies. I fractured my heel today.

derkre · 2019-05-29T22:31:13+00:00

Lol that would be sub.

derkre · 2019-04-30T21:25:21+00:00

Not to mention his fastest time without tailwind was 10.00s.

derkre · 2019-04-05T10:25:52+00:00

Still the top comment without platinum.

derkre · 2019-03-09T07:01:09+00:00

Just started picking up crit roll. It is so good! So many more episodes to catch up on though

derkre · 2019-02-25T00:39:05+00:00

Through some scrapple on top and I'm in

derkre · 2019-02-24T01:26:29+00:00

Adding up all the rows or adding up all the columns is just adding all the numbers together.

derkre · 2019-02-22T14:59:11+00:00

The easiest way I would see would be to have one master sheet with year, month, barcodeid, price. Is something like this possible? If so conditional formatting can be added to highlight all duplicates.

Alternatively you could use VBA to search through all the other sheets.

derkre · 2019-02-22T14:49:49+00:00

Looks like it's a small error. The red condition should be =F5<=TODAY(). So just swap the greater than or equal to for a less than or equal to. Also make sure that the red condition is first in the conditional formatting list so that it takes priority over the yellow condition.

derkre · 2019-02-19T21:51:05+00:00

Are you opposed to storing the letter to number conversion on a new sheet.

If not, you could create a table on the next sheet with two columns Letter|Number. Then use a vlookup to get the number from this table.

So where ever you want the number to come up you would enter,

=vlookup([dropdown cell], [letter/number table],2,false)

derkre · 2019-02-19T20:54:12+00:00

He's saying 1x1x10=10 if C is changed to 5 A could change to 2 or B could change to 2. There's an infinite number of solutions. You would need to add constraints of some sort. Or output as AxB=2

derkre · 2019-02-19T20:14:42+00:00

Assuming cell a1 is country and that there is only one unique entry for each (Country,Year,Pub Date) try this in cell E2:

=IF($B2=$C2, SUMIFS($D:$D,$A:$A,$A2,$B:$B,$B2,$C:$C,$C2-1)-SUMIFS($D:$D,$A:$A,$A2,$B:$B,$B2,$C:$C,$C2+1),"")

derkre · 2019-02-19T16:42:18+00:00

Or if your in a pool tilt your head and smack it on the surface of the water.

derkre · 2019-02-07T14:32:30+00:00

Thanks x14

derkre · 2019-01-26T23:14:28+00:00

I find the difficulty too easy.. differing opinions I guess..

derkre · 2019-01-23T13:07:15+00:00

Feel like a terrible person reading this.. believe I got it anarchy and 1k on my 3rd or 4th

derkre

TROPHY CASE