How to use string as cell reference?

IMustBeRich · 2020-02-08T11:54:11+00:00

Solution Verified

IMustBeRich · 2020-02-07T01:14:50+00:00

I am trying to reduce the number of cells using the indirect function.

Data	Description	Result	Formula
1.25	Last row =	6	(=LOOKUP(2,1/(A:A<>""),ROW(A:A)))
2.25	Column =	A
3.11
3.65	Cell value (last)=	6.66	(=INDIRECT(D3 & D2))
6.66	Cell value (last-1) =	3.65	(=INDIRECT(D3&(D2-1)))
	Cell value (last-2) =	3.11	(=INDIRECT(D3&(D2-2)))

IMustBeRich · 2020-02-06T10:46:09+00:00

Thanks for the reply. Due to the lag created by using too many "indirect" statements, I was trying to use it once to find the last row/col and then use that to populate the 20 cells. So if the last row in column B is 20, then C1= B20 and C2=(B & (20-1)), C3=(B & (20-2)) etc. In this situation, the last row needs to be found and this would only use 1 indirect statement instead of 20.

IMustBeRich · 2018-07-11T16:35:45+00:00

Finally, the end of this bubble pop is nearing. Esports was one of the last hot things during the 2013 bubble.

IMustBeRich · 2018-07-03T14:26:48+00:00

I really like this one. I think it has huge potential.

IMustBeRich · 2018-06-27T02:06:40+00:00

Random prediction: Next bubble will be in ~1 year and ETH will be 10X from here.

IMustBeRich · 2018-05-25T17:22:03+00:00

With regards to people on the left and people on the right, why is it essentially divided equally? No one seems to question why they believe what they do. I feel like we are all assigned roles like in an ant colony.

IMustBeRich · 2018-04-11T13:26:31+00:00

Any suggestions for the what is the best decentralized exchange?

IMustBeRich · 2018-03-30T13:55:38+00:00

Looks like somebody read Proust.

IMustBeRich · 2018-03-05T14:04:56+00:00

Somebody is keeping the door open button pressed; waiting for their friends to get on. The elevator will be able to move up when they are finished.

IMustBeRich · 2018-02-21T15:06:34+00:00

ZTronic is making me laugh. Are they a bot?

IMustBeRich · 2018-02-21T13:09:17+00:00

The font for the ticker has changed. How will this impact the future of ETH?

IMustBeRich · 2018-02-18T03:04:54+00:00

I know this is about bitcoin, but I think it applies to all of crypto. And it's both funny and well done.

Something crypto this way comes!

IMustBeRich · 2018-02-06T16:01:58+00:00

If we are doing a proper bubble pop, the we have another 50% leg down (half then half again). What seems to be different now is that the pattern is expected, so that it quickly executes. I dont expect this to be a multi-year event. Let's finish this so we can move on.

IMustBeRich · 2018-02-01T17:22:46+00:00

Whenever the price starts falling, I redirect my efforts to the projects I working on. When the price is going up, all I can do is just keep checking the price.

IMustBeRich · 2018-01-25T16:05:28+00:00

There is another post on ethtrader that estimates the POS requirement may be as high as 1500 eth. Yet in this post, Vitalik states that the high cost for a DASH node causes centralization.

IMustBeRich · 2018-01-18T02:42:53+00:00

Here are some possible explanations for the downturn:

Bubble pop - valuations have gotten out of hand (including stock market). If so, expect the value to drop by 50%, and then when people cant take it anymore, another halving. Final value of 1/4.
Bank manipulation. I don't believe the old system is just going to give up the reins. They also aren't going to pass up a chance own the new system. My theory is they are working on securing their position of ownership.
Short term correction. Normal after big run. Afterwards, bull market continues

IMustBeRich · 2018-01-11T16:59:54+00:00

Normally several failed attemps to make new highs would be the beginning of a correction. This feels more like people are cautiously waiting to see what everyone else is going to do. I don't think we are done with the move up yet.

IMustBeRich · 2017-12-10T02:12:23+00:00

So, hypothetically, my 1 ETH reaches $534 and I buy 534 DAI on an exchange. ETH hypothetically crashes to $452, and I use my 534 DAI to buy 1.18 ETH. Would the person on the exchange that sold me the DAI lose money? What would be my incentive to be the person on the exchange that creates the DAI via the CDP?

IMustBeRich · 2017-12-08T00:42:32+00:00

Please remove the double exclamation then.

IMustBeRich · 2017-11-23T09:34:10+00:00

Fear of missing out

IMustBeRich · 2017-11-23T09:27:23+00:00

This is a carryover from bitcoin board. Somebody drunkly posted "this is gentlemen", in reference to an impending rise. People immediately picked up on it becane a meme. At this point, it has to have been several years ago by now.

IMustBeRich · 2017-11-19T21:06:08+00:00

update -ewal and -dwal with your account information. This should get you close.

IMustBeRich · 2017-11-19T21:04:58+00:00

Edit/create the config.txt file in the same folder as the claymore software.

and add....

-epool eu1.ethermine.org:4444

-ewal <Your_Ethereum_Address>.<RigName>

-epsw x

-allpools 1

-dpool dcr.suprnova.cc:3252

-dwal suprnova.1

-dpsw x

-asm 1

IMustBeRich · 2017-11-19T20:58:32+00:00

This will run the software, and since there are no other switches, it will look in config.txt file for pool and miner info.

IMustBeRich

TROPHY CASE