Hello,
How do I randomly pick one name from a list in excel that has identical names?
Example:
Warehouses names
Ana
Ana
Hou
Hou
Aus
Aus

Every name repeats itself several times. But each of them has different lot numbers associated with them. I only need to pick one lot number number from each warehouse randomly. Is there a formula for that in excel?

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

This is probably not the most effective way to do this but I would do an index match and for the match value I would do a randbetween that generates a random number in a range you specify. So if there are 20 possible rows your randbetween would be 1 & 20.

So: INDEX(‘Identical Name Range’,RANDBETWEEN(first number,final number))

like

Thank you!

There's a conceptual discussion on this - it's IMPOSSIBLE to generate true random numbers on any computer that is not linked to a physical thing.

To give the appearance of a random number, you can either create your own random formula (based on the day of =TODAY for example), or you can use =RAND and =RANDBETWEEN(). The issue of those two is that they are dynamic aka any change in the sheet will make a new number to be calculated.

After you created whatever formula you wanna, just do =INDEX(range of names,#number); where #number is your formula*

* keep in mind you should make the #number a whole number and make sure the number isn't greater than the number of names you have - there are tons of ways to do that, I'd just use =ROUND() and divide it by the amount of names

like

Thank you!

If you can add a column on the left that numbers the rows 1 through N names, then you could do =RANDBETWEEN(MIN(<col>),MAX(<col>))

Thank you!

Related Posts

I’ve been sober about 14 months, and now with things opening up more I’ve been going out to dinner, concerts etc with friends. I’ve been finding it hard to have fun, or not get restless while out. I think a large part of this is maybe I find the company around me boring? and they’re also all drinking. Maybe I just needed to write that out and vent to say, I’m bored! Maybe saying that out loud will help me get out of my comfort zone to find new activities that change my outlook.

likesmart

Is it presumptuous to invite a new coworker to join our company’s LGBT+ employee group? He mentioned in a call that he recently got engaged to his bf. I want him to know he has a resource if he needs it but I haven’t interacted with him before and not sure if it’s the first thing I should bring up.

like

Hey, Guys!

Do we have to take a print out, physically sign and then upload the scanned document of the offer letter or is it enough to accept the offer letter through the SAP portal only?

like

Come get your shoe😂😂

Post Photo
likefunnyuplifting

What areas do small business owners typically struggle with and often need the help of an expert to guide them through the problem ? I’m trying to better understand what things keep small business owners and entrepreneurs up at night and often in need of expert help?

like

Which cloud certification is most important in the current marketplace, e.g, Microsoft, IBM, AWS or Google? This is regard to job placement.

like

Hi I am currently working as a functional Sap SD consultant. Looking for change in profile into project management. Can i expect companies to hire me in pmo team? I don't have any certification.

like

Looking to get into a role as an epic analyst. I have experience using epic just no certification.

like

Does anyone know who Starkey works with for their agency/agencies?

like

What is the approx salary band for a Senior Consultant with 5 Years of Experience in @PWC AC Kolkata?

Tech Skills: Guidewire, Selenium,Cypress,Java

Thanks in advance.

like

Why is that a strong hearted rough individual disliked by other people? It is because they take it as rude? How can one explain the reason he has become tough?

like

Did anyone joined natwest recently....
Was the induction conducted at office or virtual?
What are the freebies we receive during joining......

like
like

33 and still don’t think I want kids. Does that every change?

like

Hammayya

ELRP lock in period 6+2 ani clarity icharu ekkada 8+2 oo ani full ga tittukunna 😂

likefunny

Hi all

Require 3 consultants URGENTLY

please send profile to
abhishek@rskitsolutions.com

1) Client - Kuiqly
2) Whose payroll wil the consultant be on - resources are required on contract -
RSK IT SOLUTIONS
3) Experience - 3+ years
4) Need immediate joinees
5) remote work
6) any part of India.

Regular shifts with support for EST time zone

Senior Full-Stack developer with
Java and Angular experience -1
angular developer - 1
need 2 candidate for angular and 1 sr. full stack developer
Abhishek@infigroup.com

Hello Ads of the world. I’m looking to hire a Senior Ad to join me at red in la. If you’re conceptual, curious and ambitious then this is the best time to be here and make a name for yourself. Books👇

like

It’s a week time already since I accepted the offer from Morgan Stanley , but no Background check initiated yet .. what’s the next step? If anyone who joined recently or experiencing this onboarding process , kindly guide Morgan Stanley

like

Do you read articles on Zerohedge? It has some reputable research report excerpts but I noticed some are advertising gold a lot and asking here if I should be careful on reading the opinions there?

like

What metrics do other firms use to measure performance of junior staff (for bonuses/promotion) -- client utilization, training completion, project performance, on time T&E reporting, etc.?

like

Additional Posts in Excel Genius

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

I'm trying to split one row into multiple rows in a table. The screenshot explains my ask best. In reality, I'm dealing with 1000s of rows, but the picture gets to the essence of the ask. Please let me know any solutions - most google searches are pointing me to text to columns, which isn't what I'm trying to do

Post Photo
like

Is there a key to press to go to the bottom of the row you just copy and pasted into? Ctrl +shift + down goes to the bottom of all the text but I want to see where i stopped the pasting.

like

I have a simple formula outlining the condition that if the range of values for each row is greater than a particular cell within the same row, then highlight. Need to find a shortcut to replicate

like

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.

like

In a usage based ARR model, how would you build out the revenue model for an example customer: March, customer is new and generates 3k rev for company, April: $4k Revenue, May: $5k Revenue, Customer churns June.

From a quarterly perspective, how would you recognize the following? Q1 & Q2 New customer revenue, Q1 & Q2 Change in existing customer revenue, and Q1 & Q2 Lost revenue from customer churn.

I'm stuck on how to recognize Q2 change in revenue of existing customer, & Q2 revenue churn

like

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?

like

Job Opportunity
I'm assuming people in this group are either really good at excel or are really interested in excel - either way, I am looking for anybody who would be interested in being a Junior or Regular Compensation Analyst. I need a person passionate in excel for this job. Please DM me !!

like

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

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)

This is the 🐐 bowl. No fuss and nonsense just all business

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

like

How to best improve excel skills? Any classes or courses I can take online?

like

I truly appreciate this group.

Post Photo
likefunny

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Formula to convert the date on the left to the date on the right? I’ve been using text to columns then concatenation but I feel there must be a better way...thoughts? Thanks!

Post Photo
likehelpful

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

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