I forgot to add one more piece of information to this question.
Under the same columns as the chq #, there is also a vendor ID#. I want to
only copy down in 'column C the chq #. Is this possible?

25246 (chq #)

8517 5650MAR1508MM need cheque # filled in this column


25247

8518 069


25248

8519 002956009059
8519 002956033059
8519 002957358059
8519 004640086041
8519 861-7022-MAR908

thanks

"Max" wrote:

One easy play which should deliver it for you

Data as posted is assumed in cols A and B, from row1 down,
cheque#s in col A (with in-between blank cells), invoice#s in col B

In C1: =A1
In C2: =IF(A2="",C1,A2)
Copy C2 down to extent of data in col B
Then in D1: =IF(B1="","",C1)
Copy D1 down. Your desired results in col D.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"indigo993" wrote:
I would like to fill in the chq# in the column next to the invoice numbers.
How would I go about doing it?

25246 (chq #)

5650MAR1508MM need cheque # filled in this column


25247

069


25248

002956009059
002956033059
002957358059
004640086041
861-7022-MAR908