what's the formula if I want to do G4 - J4, G5 - J5, etc so forth and so on? i don't want to write =G4-J4, G5-J5, etc 200 times
The first thing I do when my VDI at work gets updates pushed is uninstall Excel. I don't want to be tempted to use that piece of shit in a moment of weakness.
i had a turkey, american cheese bc i'm not a terrorist, honey mustard, and lettuce sandwich my side was some delicious jalapeno cape cod chips
I remember when I learned that if I wanted to type 1, 2, 3...100 I didn’t need to do all of them, just the first few then select them and drag.
You don't even need to drag rookie. All you have to do is double click the bottom right-hand corner of the cell and it will auto-fill for you
I fear that this thread is going to discourage skiedfrillet from seeking help and his next work project is going to end up like
Didn’t read thread. Trying to figure out how to turn a list where each ID number has a few lines with a different email address, and I want to concatenate them into one cell and line for each. Like: 10001|[email protected] 10001|[email protected] 10001|[email protected] To: 10001|email@mail, person@company, guy@place Not having great success via google so far.
Simple way is writing a formula in column b (cells indicated in your formula above) B1 ‘= a1 ‘ B2 ‘= b1 & “, ” & a2’ Copy cell b2 down the entire column If you just need this one off, that’s easy. Just copy and paste the last row as values. If you need the list frequently and it changes, I have a more complicated formula that determines the max length and uses that to determine the longest row.
Just found this, which worked for my scenario. https://www.exceltactics.com/combine-data-multiple-rows-one-cell/
Is this the only Excel thread we have? Trying to figure out how to compute some power settings on a piece of equipment.
Well hell. So i'm trying to figure out the % of max power a piece of equipment is putting out for each of it's 20 power settings. Normally I figure this would be easy as each setting would be an additional 5% of max all the way to 20 = 100%. But setting 1 does not equal 0, it actually equals 15%. So if setting 1 is 15%, setting 20 is 100%. How do i figure out the % for the other 18? Would I do 85 (the total power spread in %) divided by 18 settings?
You're probably right. More of an engineering or statistics question probably. Was just using excel to do the breakdown and was curious if there maybe a formula that would help or something. Maybe I should just post a new thread. I'm not sure we have a thread that already exists that would help.
if it was 1:1 linear relationship between setting and power then yes, your though would work to spread it over the settings 1-20 between 15-100%. I highly doubt anyone is going to know exactly b/c ever piece of equipment power is probably different.
Yea and the manufacturer is being really slow at answering any emails. This is just a wave maker in an aquarium so it's not any kind of priority. I talked it out with a friend of mine and we got 85 (remaining power after starting at 15) divided by 19 settings = about 4.47% each setting. That puts setting 20 at 99.93% which I'm good with.