BENSON
10-11-2007, 08:09 AM
I have a spread sheet with 12 columns starting at column C representing the 12 months of the year(JAN -DEC) In column "A" a user enters a date and in column "B " a unit amount.I would like the unit amount to be refelected in the appropriate column ie: if the date is 3rd March the amount would show in column E
THANKS
p45cal
10-11-2007, 08:25 AM
if C2 is the top left cell of the data part of your data then paste this formula there:
=IF(AND(MONTH($A2)=COLUMN()-2,$B2<>""),$B2,"")
copy across the 12 months horizontally, then down as far as you need.
This only checks the month, not the year.
p45cal
ps if the top left cell is say, C6, then the starting formula would be:
=IF(AND(MONTH($A6)=COLUMN()-2,$B6<>""),$B6,"")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.