Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
Hi, I would like to know how it is possible to compare several sheets in one file, which have similar content. I need a function who shows me how to compare it and gives me the result in another sheet (same file) How can I manage this? Thanks a lot, Vicky :) -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=490744 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
http://www.cpearson.com/excel/duplic...tingDuplicates
-- Kind regards, Niek Otten "Vic1978" wrote in message ... Hi, I would like to know how it is possible to compare several sheets in one file, which have similar content. I need a function who shows me how to compare it and gives me the result in another sheet (same file) How can I manage this? Thanks a lot, Vicky :) -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=490744 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
Hello, unfortunately this function doesn´t work. There is always an error... What is wrong with the formula? =(COUNTIF(A2;"1"),TRUE,FALSE) Kind regards, Vicky -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=490744 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
Use
=A21 -- Regards, Peo Sjoblom "Vic1978" wrote in message ... Hello, unfortunately this function doesn´t work. There is always an error... What is wrong with the formula? =(COUNTIF(A2;"1"),TRUE,FALSE) Kind regards, Vicky -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=490744 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
Hi Vicky,
That is not a formula from the link I gave. Please check the examples carefully! -- Kind regards, Niek Otten "Vic1978" wrote in message ... Hello, unfortunately this function doesn´t work. There is always an error... What is wrong with the formula? =(COUNTIF(A2;"1"),TRUE,FALSE) Kind regards, Vicky -- Vic1978 ------------------------------------------------------------------------ Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708 View this thread: http://www.excelforum.com/showthread...hreadid=490744 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 tables with similar content
Vicky,
regardless of the other members' suggestions, the specific formula as you type it: =(COUNTIF(A2;"1"),TRUE,FALSE) will not work. Either you will use comma or semicolon in all arguments. Furthermore, in this case you forgot the IF. =IF(COUNTIF(A2,"1"),TRUE,FALSE) HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Comparing data in tables | Excel Discussion (Misc queries) | |||
Comparing data in two similar worksheets | Excel Discussion (Misc queries) |