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 this a good weekend to visit dyker heights? Or is it worth waiting?

like

I need friends 🥺

like

This Bowl is very dull and ppl hardly communicates

like

Hello! Need hearts to unlock my DMs! Thank you so much 💛🙏🏼

likehelpful

Is applying a few days before the “Apply by” date too late? Do most decisions get made early on/they don’t wait for all applications before interviewing/hiring?

like

Hello Fishes.. I had applied for a position and had completed the cultural assessment. Received an automated mail that said “we will be in touch soon”. It’s been more than 20 days and haven’t received any communication. Should I expect any reply now? What’s the usual procedure like?

Please explain if we get internet reimbursement outside the CTC?? Not the tax exemption part . I have heard we get 1200 per month for internet . Is it true ?

like

Anyone have any recommendations for an interior decorator?

like
likehelpful

I am a creative designer/animator with a leading medical tech company with 6 yrs exp and based in NY. Currently looking for new roles because of relocation requirement at my current role. Any tips or referrals would be really appreciated. TIA!

like

Received offers from PNC and UBS. Same position. Same benefits. Purely seeking opinions on the companies. Previous experience at EJ. Left to get away from outside sales nature and isolation.

likehelpful

How much time Accenture takes to come back after some one clears the tech round?

Its already a week, please help.

Should i reach out to them in case they did not?

like

Did anyone attend L3 round in State Street. How this round is going to be?

like

Any folks targeting European schools - Like Insead and LBS?

like

I feel like I've been lowballed, can someone explain the below breakdown please?

Base salary: 60k
Quarterly quota (per quarter): 107k
Quarterly bonus (per annum): 23k
130% Annual bonus = 11.5k
"23% commission on quota minus base": 37k (don't understand this)
"Proposed 23% commission on 150% quota minus base": 86.5k
Sales commission threshold per month: 22k
OTE: 122k
Cost/Sales: 28%

That base salary is lower than my previous base by a significant amount by 32.7%

like

Hi Fishies :) I'm currently recruiting for a couple of senior engineer roles and have been making use of AngelList. The HMs have asked me to look into other similar recruitment tools and I would really appreciate any advice on similar recruitment tools I can look into. Thanks in advance for any help or suggestions :)

like

I don't think this is going the way Ron wanted it to....

Post Photo
likefunny

How long should I have to wait before applying for a transfer to abroad job in USA in the same company? Currently on a contract role as risk investigator L3 in Amazon

like

What is the notice period in Cognizant. I joined on JAN 2021 they didn't mentioned on the order letter as well Cognizant

like

Additional Posts in Excel Genius

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anyone know what these badges are?

Post Photo
likefunny

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How long did it take you to become good at excel? Like fast?

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

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 a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

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

like

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

Post Photo
likehelpful

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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