ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel 2003- verify that row used in calculation is same within 2 c (https://www.excelbanter.com/excel-worksheet-functions/105611-excel-2003-verify-row-used-calculation-same-within-2-c.html)

a01010

excel 2003- verify that row used in calculation is same within 2 c
 
Does anyone know of a way to verify that a row number being used within
calculations of 2 separate cells is the same?

Example:
Cells B31 and C31 both contain values from the same row within the
worksheet.
B31 (=I12)
C31 (=E12)
I need to verify that both cells B31 and C31 are looking for data within the
same row "12" of the worksheet = is there a way?




All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com