sheet1

  1. A

    In Excel How to use cell ref as a variable

    In MS-Excel Suppose in Sheet1 A1,A3, A5,.... contains data. The cells A2,A4,.... are blank. These data are again used in ColC of Sheet2 by means of a formula. However, in Sheet2 no row is to be left blank. Thus, cell C1 of Sheet2 refers to cell A1 of Sheet1, cell C2 of Sheet2 refers to cell A3...
Top Bottom