Well I am glad you learned something new, thanks for visiting

I would say you could, you are always working or on hive. But then a bit of rest from work and I bet you would spend it on hive anyway, or visa veras

you are welcome

Ok I got the file by email and returned with the following Well, that took a little creativity, but I think I have a solution. First, let's look at the problem. If you go to your source data cell C92 which

with so much data at this stage, I say the cost of running is high enough

I need to try and replicate the problem, you can share a dropbox/onedrive/google drive link, or, I just sent you an email, maybe you could email me a sample?

I am a little confused. Are all the data types in the same column? Can you share an example?

The answer is yes, there are Hive API,s but I have not looked at them. There is also the SQL which is even easier to get data from, however you have to pay a sub for the SQL data on hive. From the hive

awesome @vinniefarsheds, great to have you here, I hope I can keep you motivated

Hi Dernan, you can not use either formulas or dates column headers to tables. You are doing nothing wrong, its just how Excel works. When I am faced with this issue myself what I tend to do is add a new

Have you been using Power query @complexty?

Embrace Excel, don't hate it. Stick with me and after a while, I bet I can get you to love it :-)

Awesome that you found us via Alison. I hope you enjoy learning excel

I was in the bad camp and was falling for all the FUD but look at China now, they are moving forward and moving on. The rest of the world will follow too. Hang in there.

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

thanks, its a guest post from Chandeep . I am glad you liked it :-). You should check out his blog

XLOOKUP rocks. Do check out Excel for All - The Excel community on the steem blockchain

way cool,

Dohhhhhh......Excel is fun, way fun, you just haven't found the right teacher yet :-)

thats cool, pity about the journey home, you should have walked