- Assuming the Titles (Date, Supply No., etc) are in Row 1 and the data
starts on Row 2
- Assuming 'Jan' begins in Column D
- Assuming the Month titles are all 3 letters (Jan ,Feb ,Mar ,Apr, etc)
- In Cell D2 enter the following formula...

=IF(CHOOSE(MONTH($A2),"Jan","Feb","Mar","Apr","May ","Jun","Jul","Aug","Sep","Oct","Nov","Dec")=D$1,$ C2,"")
- Copy the formula over to "Dec" and down the list of data.

HTH,
--
Gary Brown

If this post was helpful to you, please select 'YES' at the bottom of the
post.



"Tiya" wrote:

I export out standing statement file from other prg. to excel. data export
like date, supply no., and o/s amt.
I want to transfer o/s amount month wise next to data as per there month
columns.
Like e.g.
First 3 columns are export.
80020 36362 56890
Date Supply No. o/s Amt Jan Feb March April Like Up to Dec
1-jan-06 A23456 45900 45900
12-jan-06 D67890 34120 34120
02-feb-06 E34679 23784 23784
17-feb-06 R4567 12578 12578
21-mar-06 N5466 56890 56890
Any help.

Thanks in advance