Get instant live expert help on I need help with random character generator

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a number generator (randbetween(1,69)) that will generate a table of 5 numbers. I am trying to eliminate previous number rows from the generator.
Solved by Z. Y. in 18 mins
I'm trying to create a random weighted generators based on certain criteria. On the "Magic Items" tab I have a list of things I want the tabs "Shop Generator" and "Item Generator" to pull from with weights based on their rarity from the "Prices" tab. So on the "Shop Generator" tab I want it to populate each shop based off the tab "Shops". For instance Blacksmith will generate 6 items from the tab "Magic Items" with the tags Armor, and Weapon. Then it generates a gold value for each item based on rarity from the "Prices" tab. Then it adjusts all the prices based on the shop quality in the tab "Prices"
Solved by B. B. in 13 mins
Hi, I have a character I need removed from all the rows in column C. It's this character { ' } . Funny thing is that you only see the character when you click on the cells.
Solved by A. S. in 15 mins
Hello, I'm conducting a statistical sample on a worksheet and from the 3000+ data points, I need to pull all of a row's contents for 51 of 3000+ identified from a random number generator (separate worksheet) my workplace uses. How do I take those 51 data points and highlight all of its rows contents (only those 51)?
Solved by O. Y. in 24 mins
DESCRIPTION: Hi Expert, Im having a issue to find a match by checking each character in a cell with raw data. please refer below : Input field : 73182999 1st Checking: If input field match exactly(all 8 digits) then return same value, if not checking continue by taking only first 3 character (731) and check the raw data, if found then it should move to next by taking 4 character(7318). if yes then move to 5th character ,let say if it fail to found the match during its 5th character(73182) then it has to return the 4th character (7318) and most largest found in the raw data with these 4 character prefix.
Solved by S. S. in 18 mins