I want to align two columns by using insert/shift down

B

Britz

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timesheet formula problem 3
Calculating column A * column B = Results in another column 2
series of formulas to get to one formula 0
Sumproduct in matrix means 3
multiplication of two array in a particular way 2
checking two different cells 1
Shift down and then to the right 1
Data Validation and drop-down list using IF, AND and what else? 8

Top