![]() |
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