Excel's odd but useful - Indirect Function
5 years ago in Excel For All by theexcelclub (67)
$14.79
- Past Payouts $14.79
- - Author $7.53
- - Curators & beneficiaries $7.25
- > steempress: $1.11
56 votes
- appreciator: $12.97
- paulag: $0.43
- etcmike: $0.23
- steevc: $0.18
- hedge-x: $0.14
- abh12345: $0.10
- theexcelclub: $0.09
- cmplxty: $0.07
- meno: $0.06
- helpie: $0.06
- ew-and-patterns: $0.06
- edkarnie: $0.06
- traciyork: $0.05
- solominer: $0.05
- scholaris: $0.04
- bluerobo: $0.03
- enforcer48: $0.02
- dalz: $0.02
- fragmentarion: $0.02
- mytechtrail: $0.02
- and 36 more
That was pretty interesting actually, I had a comment all typed out for what I thought, then dropped it off. At first I thought it was just going to be getting one number from one spreadsheet into another sheet, like
=April.H33, it was a lot more than that. I am still very basic knowledge wise when it comes to spreadsheets, but since I have been tracking my progress I keep looking for and find things that help.I'm not into data at all yet but that did look like a nice tool for sorting/organizing data.
I am glad you enjoyed it @bashadow. Yeps INDIRECT can do a lot more that one might think. And although you say your knowledge is basic, you have just upped a level by learning this function as it is a function most have never heard of :-)
Your post was a bit motivating, I added a couple of sheets to my Hive Stats Table, and now have a complete, well almost complete history of my Hive Account activities since March 20th.
Are you keeping it manually or updating with hivesql? I need to get back to doing data posts with blockchain data