- Dec 26, 2004
i'm doing lots of calculations lately and wouldl ike to know if it's possible to apply Access queries to Excel. For example: Sheet1, Column A has 100,000 customerids. Sheet 2, Column A has 30,000 customerIDs. by using formula in Sheet2, columnB: =COUNTIF(Sheet1!A:A,Sheet2!A2), i am able to get which customers match. the calculation takes long time so i was wondering if it could be done in Excel but with Access powers?