I have two colums. Both include 8 digits numbers with shorter numbers between. I want to calculate how many rows between two 8 digits numbers have first one and the second one and then I need to add second column next to the first one but with adding missing rows (difference beetwen first one and second one). For example - fist column has 9 rows and second one has 12, so I need to paste second column next to the first with adding 3 extra rows below last row in first column.
Tarwit 0 Newbie Poster
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
Hazuan Nazri 0 Junior Poster in Training
Tarwit 0 Newbie Poster
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
Tarwit 0 Newbie Poster
Tarwit 0 Newbie Poster
Tarwit 0 Newbie Poster
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
Tarwit 0 Newbie Poster
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
TnTinMN 418 Practically a Master Poster
Tarwit 0 Newbie Poster
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
tinstaafl 1,176 Posting Maven
TnTinMN 418 Practically a Master Poster
Tarwit commented: excellent! well done! +0
Reverend Jim commented: Likewise +12
Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
Tarwit 0 Newbie Poster
Tarwit 0 Newbie Poster
TnTinMN 418 Practically a Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.