Comments by The Excel Club (@theexcelclub) - Honouree

The Excel Club

theexcelclub.com

Learn Microsoft Excel and Power BI

@theexcelclub 0

almost 6 years ago

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

0

0

0.000

@theexcelclub 0

almost 6 years ago

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

0

0

0.000

@theexcelclub 0

almost 6 years ago

you are welcome

0

0

0.000

@theexcelclub 0

almost 6 years ago

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'

0

0

0.000

@theexcelclub 0

almost 6 years ago

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

0

0

0.000

@theexcelclub 0

almost 6 years ago

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 e

0

0

0.000

@theexcelclub 0

almost 6 years ago

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

0

0

0.000

@theexcelclub 0

almost 6 years ago

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

2

0

0.000

@theexcelclub 0

almost 6 years ago

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

0

0

0.000

@theexcelclub 0

almost 6 years ago

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

2

0

0.157

@theexcelclub 0

about 6 years ago

Have you been using Power query @complexty?

0

0

0.000

@theexcelclub 0

about 6 years ago

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

1

0

0.000

@theexcelclub 0

about 6 years ago

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

0

0

0.000

@theexcelclub 0

over 6 years ago

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 w

0

0

0.000

@theexcelclub 0

over 6 years ago

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, yo

0

0

0.000