I am trying to create name list for a column. my values are in Column A up to 10 rows, i would like to assign name in B column corresponding rows. For ex: for LenZ in R1C1, the list name in R1C2, should be LenZ ( ie same name). i tried a lot but unable to increment the R1C1 value. Can anyone help on this.