-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
optimizer
-
B
How should I replace these words in brackets and the word before it?
I have multiple text strings containing A(a), B(b), C(c), etc. A and a are related over and thousands of these are in one sheet. I want to replace A(a) with a and B(b) with b, so on. Any thoughts please? EX: Optimizer Mode(OM) -> OM Home Snoop(HS) -> HS- bbingr
- Thread
- home modeom optimizer replace thoughts
- Replies: 1
- Forum: Excel Questions
-
A
How to randomize a group of numbers, colors and names from a list without repeating them in the line.
I need to come up with all the combinations for the below data. I have numbers, colors and names. I need to put one number, two colors and three names in a row without repeating a name or color in each row. I would also like to not replicate the rows with the colors or names in a different...- aruen
- Thread
- optimize loop optimizer random list randomize vba
- Replies: 8
- Forum: Excel Questions
-
L
Optimizing/loop help
Hi everyone, This is a bit related to my last post: http://www.mrexcel.com/forum/showthread.php?p=1991644 What I am trying to do is create a specific "optimizer" type macro for some data I will have. What I'm working with is a spreadsheet has the $ costs for different projects and an...- loderdodger
- Thread
- loop optimize optimizer
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
