How do you generate a random number in excel? Wrong answers only! 🤡

like
Posting as :
works at
You are currently posting as works at

Delete cells of raw data until only one remains

like

Brilliant

Do a salary survey.

likefunny

It’s sad but true 😂

Copy 500 digits of pi into a cell as text. Use =TEXTBETWEEN and pick two random numbers. See where you end up.

like

Ooh I like it

No machine can produce random numbers, so I guess any answer is correct?

like

Touché, my friend

Create a zapier that pulls three tarot cards and concatenate the results.

like

I don’t recall tarot cards being numbered, how do you propose we codify the resulting string?

March 13, 2024.

I restate my assumptions.

Used to play Go with my mentor and esteemed mathematician, Sol, to discover the pattern that underlies everything. This led to cluster headaches along with near-fatal encounters with Hasidic Jews as well as Wall Street agents.

Taking a drill to my skull made the headaches go away (thank goodness), but now I rely on that stupid RAND() function in Excel.

🍰

10 points to hufflepuff for creativity

Related Posts

Is there any vacancy as a Frontend React UI developer?
4 YOE @capgemini

like

What policy changes are expected post LTI - Mindtree merger?

like

Did anyone hate wedding planning? I’m constantly considering cancelling the wedding cuz I honestly can’t believe how much drama it’s causing with all family members.......

like

I have been offered a job at KPMG within cyber security in the uk. Originally it was a 25% hike offer. Now I have received a 8% hike at Deloitte as part of the current performance cycle along with a 5k bonus (great incentives every year) The only thing is KPMG is offering this in a @kpmg regional location where I’m based plus the disadvantage is I need to pay 2500£ for my dependent visa costs which I can save if I continued with Deloitte. Seen Lot of negative comments about KPMG. Any thoughts ?

like

Thoughts on the corporate strategy team at Visa? Trying to learn more about the regional vs global teams, salary (US btw), career progression etc. Thanks!

like

Bain & Company Hi everyone, This is an Associate from ZS Associates with ~2 YOE What skills/courses does someone need to become financial analyst in JPMC, MG, Moody's, MBBs and so on ? Or Just to enter as analyst in these firms ? ZS Associates JPMorgan Chase Morgan Stanley Bain & Company Goldman Sachs Moody's Corporation

like

Any recruiter in search of a Scrum Master 🙂

like

Hi fishes, can you please tell me why do ppl say join EY GDS and not EY India. I am into Java Fullstack, yoe-4, location -Pune recently cleared online test and given interview and later get to know it's EY India not GDS. Now m worried should I join or not. I have 2 other offers from WITCH companies. EY EY India

like

Hi Fishes,
I belong to construction industry with PGDM from NICMAR in Advance Construction Management having expirence of 2yrs. I want to know how can I boom my career even after so much of higher education and expirence industry has slow career growth and toxic work culture. Iam not getting how to move further with such underpaid industry even sometime I get the thoughts for switching the career with data science which again needs time and money investment please suggest DS scope for Civil eng

like

I've worked with the client for over 7 months now and he still calls me by my dad's name
What do I do 😭😂

like

Walmart hr collected all the documents from me but she hasn't come up with an offer from the last one month...., Will Walmart give me an offer or not??
@walmart

like

Any insight on CAIA? Difficulty and whether it impacts salary?

like

Whats the difference between consulting and advisory in terms of job duties, pay, wlb, etc? I have asked this question to many people in both positions, and no one is able to give an actual answer that differentiates the two.

like

Hi all, I will be joining EY GDS Bangalore (RMZ Infinity Tower 3) in December, and wanted to know the WFH situation ? Are there any plans to return to office ?

like

I have a valid coe and visa of Japan how to search jobs in Japan from India

like

Is bgv closed before joining LTI.
What are the things in BGV closed before joining and after after joining.

like

Does studying for and taking the CPA help you with your job in audit?

like

Is there any requirement for salesforce guys?

like

Hi,
PPL working in Walmart Bangalore.Have you guys already relocated to Bangalore or travelling from your hometown based on the requirements ?

like

Additional Posts in Excel Genius

Anyone know what these badges are?

Post Photo
likefunny

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I compare two sheets to make sure they are identical?

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Any book recommendations on excel modeling for real world business applications?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal