ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to align two columns by using insert/shift down (https://www.excelbanter.com/excel-worksheet-functions/141011-i-want-align-two-columns-using-insert-shift-down.html)

Britz

I want to align two columns by using insert/shift down
 
I have two lists that I want to compare. I can create a third list by doing
an if(countif(a:a,b1)0,b1,""), but what I would like to do instead is insert
blank cells (say in columns c thru j) where the lists don't match so that
they are aligned.
So If I have:

a1: D2233 b1:nodate c1:D2233 d1:notime
a2: D2234 b2:sdate c2:D2234 d2:stime
a3: D2235 b3:sdate c3:D2236 d3:stime
a4: D2236 b4:nodate c4:D2237 d4:stime

I would like to shift cells c3 and d3 down 1 so that they are aligned
correctly with a4 and b4 (indexing on columns a and c)



All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com