Columns
You could use MATCH
Eg assuming the years (2008, 2007, etc) are numbers entered in B1 across then in say, A20: =MATCH(2008,$1:$1,0) will return the col number for 2008 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "904allen" wrote: I have a work sheet with 6 columns the headers of the columns are A=Class Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a cell as to the column number for the years example for 2008 column 2 for 2007 column 3 and so on. |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com