| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking numbers across various sheets
Hi
Im trying to chk numbers if they match between sheets. I have 7 sheets in the workbook. Is there a way to put the statement below from sheet1..sheet7? This formula would be on sheet8 where the person would enter the number again to confirm its correct! =IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","") Thanks Mike |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking numbers across various sheets
Are your sheet names really Sheet1, Sheet2, Sheet3, etc?
You want to check and see if cell A1 = cell B1 on all 7 sheets? =SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT( "1:7"))&"!A1:B1"),n))=14 Where n = the number to count, or, use a cell to hold that number and replace n with that cell reference. Sheet8 A1 = 10 =SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT( "1:7"))&"!A1:B1"),A1))=14 Biff "Mike" wrote in message ... Hi Im trying to chk numbers if they match between sheets. I have 7 sheets in the workbook. Is there a way to put the statement below from sheet1..sheet7? This formula would be on sheet8 where the person would enter the number again to confirm its correct! =IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","") Thanks Mike |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking numbers across various sheets
P.S.
TRUE means all the numbers match. FALSE means all the numbers do not match. Biff "T. Valko" wrote in message ... Are your sheet names really Sheet1, Sheet2, Sheet3, etc? You want to check and see if cell A1 = cell B1 on all 7 sheets? =SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT( "1:7"))&"!A1:B1"),n))=14 Where n = the number to count, or, use a cell to hold that number and replace n with that cell reference. Sheet8 A1 = 10 =SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT( "1:7"))&"!A1:B1"),A1))=14 Biff "Mike" wrote in message ... Hi Im trying to chk numbers if they match between sheets. I have 7 sheets in the workbook. Is there a way to put the statement below from sheet1..sheet7? This formula would be on sheet8 where the person would enter the number again to confirm its correct! =IF(NOT(Sheet1!$A1=Sheet1!$B1),"numbers do not match","") Thanks Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbering Sheets incrementally (as in Invoice numbers) | New Users to Excel | |||
| Numbering Sheets incrementally (as in Invoice numbers) | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Checking crossword numbers | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Linear Mode
