Get instant live expert help on I need help with excel formula generator
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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 am using drop down selections as an order sheet that searches the document to gather pricing from tables throughout various tabs. In the "order Generator" tab under the "Homeowner delivery" section i want it to show the estimated delivery duration when the price is generated.All the cells outlined in bright red in tabs "order Generator and Topsoil is what you need to refer to. i tried to color code these cells to help explain how it works.
Solved by Z. D. in 30 mins
one of the expers from this company helped write a formula to generate pricing using drop downs. for some reason when i click in cell F5 of the "order generator" tab if i click in units 21 through 25 it gives me a #REF!
Solved by S. A. in 12 mins
I am trying to use nested IF and lookup commands to create multiple outputs from a series of 3 drop down menus. For example: If drop down menu options are A, B, and C then the result will be 0.1 but if it's A, C, C, then the result will be 0. It's sort of a calculation chart/generator type thing.
Solved by Z. A. 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