So let's say that I want to create a fake listing of bank transactions. I want all 1000 transactions to happen at 1 of four branches:
1. Eastern Ave
2. Wall Street
3. 112th Ave
4. Broadway
How do I tell Excel to pick from my list of 4 branches and populate the list?
| +81 | AI and white collar work | 49 | 15h |
| +25 | Where to Buy Rope? | 9 | 6h |
| +12 | Where to stay in Vienna for a special occasion, can you help with any recommendations? | 5 | 55m |
| +11 | Visiting NYC | 11 | 3d |
| +4 | Addict Monkeys? | 5 | 3d |
| +4 | Deciding what Keyboard is the best | 7 | 16h |
| +3 | WSO King Kong deal toys for 1,000+ bananas? | 5 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Here's my take
There are multiple ways to do it using rand function - based on probability distribution etc.
However for the sake of a single-cell formula to fill the list: =IF(RANDBETWEEN(1,4)=1,"Eastern Ave",IF(RANDBETWEEN(1,4)=2,"Wall Street",IF(RANDBETWEEN(1,4)=3,"112th Ave","Broadway")))
And you basically want to hard copy the list (special paste value) to another tab/sheet to avoid the list changing everytime you refresh the worksheet.
Cheers
Maybe this is a bit more elegant and easier to expand: - Assume your branch locations are in E4:E7 - Use formula: =INDIRECT("E"&RANDBETWEEN(4,7))
i'm going to try this when i'm back at the office, thanks euro
i had seen solutions that looked more like hswc but I was thinking there had to be a more simplistic way
Enim recusandae autem aut. Enim at esse cum. Numquam sequi itaque non sunt culpa ad. Ut voluptas aut minima deleniti sapiente. Quia deserunt alias tempora et.
Aliquid autem quas ut suscipit nihil distinctio. Rerum suscipit quidem dolore ipsum cumque. Placeat accusamus ut veritatis harum. Autem cum voluptatem et voluptatum amet. Reprehenderit architecto omnis iure quasi. Et dolorem et facilis sunt natus et voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...