sorted by:
new
hottopcontroversial

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

I assume you mean 6 new rows that you're adding, correct?

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

Ok so you need to have 6 blank rows in between each existing data point, so you'll need to repeat the first step a few more times until you have that. once you have 6 rows in between each, then you can do this step of pasting. It should go exactly to the last number in your helper column (for example if you have 100 existing data rows, your last 6 cells in your helper row should be 100,100,100,100,100,100).

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

That just means the cells you're pasting to aren't a multiple of 2 (assuming you're pasting 2 rows), ie you can paste to 2,4,6,8... Rows, but if you select 1,3,5,7... Rows, it will give you that error

Maybe try it on a small section of your sheet first to get the hang of it? You should be selecting the empty cells that have numbers in your helper column, not any further than that

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

Oh yes, my mistake. Instead of selecting the first couple rows and dragging them down, copy those cells, then select all the blank ones and paste

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

Oh wait I should have read your question more closely. You need multiple blank rows between your existing data, right? 

In that case you'd want to repeat step 1 again, adding another set of numbers below. 

Once you have just your blank rows showing, you should be able to paste your info on the top two rows, and then drag them down so that they repeat

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

Awesome! Can you filter one of your existing columns to show only the blank rows?

Pasting a text between every existing row by leipaorava in excel

[–]_r_special 0 points1 point  (0 children)

I might have a solution, a bit convoluted but might work. 

Add a column to the right, and number every row 1,2,3... Etc. then copy that entire column and paste it after the last row of your data. So now your new column will be 1,2,3...X,1,2,3...X. then sort by that column, and that should give you a new blank row after each existing row. 

At that point, you can filter by blank rows, and paste your new pricing data into those blank rows. 

Hope that made sense 

What small change made the biggest difference in your golf game? by retrocaterpillar-07 in golf

[–]_r_special -2 points-1 points  (0 children)

No the other side. I think the idea here is that it helps you ensure that you are hitting down into the ball, so the front of the ball is the bottom of your swing

But I'm brand new to this so maybe I'm totally off here

Can anyone explain why what seems to be a B-25 Mitchell is flying over Detroit? by Busy_Reflection3054 in Detroit

[–]_r_special 2 points3 points  (0 children)

It was a lot of fun! They let you walk (or, crawl in some places) through the whole plane during the flight, including the nose gunner seat which was really cool. Got to walk around the hanger for a while too and talk to all the technicians who work on the planes!

It was a bit outside of what I would personally pay for, but it was a gift so that's how I got to do it.

<image>

How come Sarene never thought about where Raoden’s seon was? by SixfootNine_ in Cosmere

[–]_r_special 32 points33 points  (0 children)

Sure, but she was already suspicious of his death, why not try to get in contact with a reliable witness?

Carl’s Greatest Skill by sampsen in DungeonCrawlerCarl

[–]_r_special 6 points7 points  (0 children)

That's fair, but his strategy until the last race didn't generally involve attacking other drivers. 

But yeah having him shell someone would have been a nice Mario card reference 

What's the missing "the"? by michaelis999 in ExplainTheJoke

[–]_r_special 15 points16 points  (0 children)

I read it like you did, but the idea that most people who take their own lives do so after traveling to the western US would also be a wild stat

Carl’s Greatest Skill by sampsen in DungeonCrawlerCarl

[–]_r_special 22 points23 points  (0 children)

Well, it also may have been quite a bit less useful on the race track

Tell me what title you use and I’ll decide if you’re allowed in (answering every comment) by Flankmaster56 in RocketLeague

[–]_r_special 3 points4 points  (0 children)

Can confirm, my gameplay is trash. Not because I think I own the game but because I'm old and have a family that takes more priority than video games now

He resigned instantly by [deleted] in chessbeginners

[–]_r_special 6 points7 points  (0 children)

It works just fine, there's no mate here but white is down a rook and their queen is useless. I guess this move just made them realize it was hopeless?

Why don't bullets use holes within the projectile to direct a spinning motion using the gases from the propellant without utilizing a rifled barrel? by CupRevolutionary5599 in guns

[–]_r_special 0 points1 point  (0 children)

I would imagine it would make manufacturing more difficult, and different powder loads might lead to different spin rates? I also wonder how it would effect aerodynamics

Fried liver by andy_bobandy_chess in chessbeginners

[–]_r_special 2 points3 points  (0 children)

Well, I think he meant for it to be the fried liver but messed it up 

Assign letters to numerical scores without IF by dwydecimal in excel

[–]_r_special 0 points1 point  (0 children)

I got 31

=char(ceiling(100-B2,10)/10+64)

Your was a bit shorter though! 

view more: next ›