Become A (Million Prayer) Millionaire?

KKranz

New Member
Joined
Aug 30, 2002
Messages
19
It's been a number of years since I've been back here ... so, please let me know if I'm doing anything wrong.

My purpose (today ... now that I'm retired ... is to share something(s) I've learned over the past few years.

Specifically ... here ... I had a young person at my church challenge me into "out-praying" him. I did just that with a pivot table that "pushes out" one million prayers in less than five seconds. He admitted I WON!

Please feel free to let me know if this would be helpful to anyone.

Ken
 

Attachments

  • Become a (Million Prayer) Millionaire.jpg
    Become a (Million Prayer) Millionaire.jpg
    66.7 KB · Views: 22

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Does it really count if the "prayers" are just being generated by a computer?
 
Upvote 0
Solution
And in praying do not heap up empty phrases as the Gentiles do; for they think that they will be heard for their many words. (Matt. 6:7)
 
Upvote 0
“Man’s mind, once stretched by a new idea, never regains its original dimensions.” – Oliver Wendell Holmes
 
Upvote 0
Hi!

I am from Turkey. Just curious what is happening in this post?! Can somebody explain to me?
 
Upvote 0
I am from Turkey. Just curious what is happening in this post?! Can somebody explain to me?
As near as I can tell OP wrote some code in Excel that will generate the text of a prayer a million times. OP may think this is equivalent to actually praying a million times.

I had a young person at my church challenge me into "out-praying" him
Also apparently praying is a competitive sport now.
 
Upvote 0
As near as I can tell OP wrote some code in Excel that will generate the text of a prayer a million times. OP may think this is equivalent to actually praying a million times.


Also apparently praying is a competitive sport now.
Oh, that's...that's..let say inspirational.

I can write a VBA code which will fill each cell with a different prayer. So that he can beat the young person.
 
Upvote 0
This is nothing more than a pivot table ... that allows the user to double click on the number (1,000,000) ... and create a table with the prayer (in this case The Lord's Prayer) reproduced/prayed 1 million times.
 
Upvote 0

Forum statistics

Threads
1,223,948
Messages
6,175,575
Members
452,652
Latest member
eduedu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top