ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximum Count (https://www.excelbanter.com/excel-programming/294855-maximum-count.html)

Michael168[_72_]

Maximum Count
 
Can someone help me with the formula or vba to compare row 1 to row 10
of sheet1 (cell,A1:A10) against sheet2 from row1 to row 30
(cell,A1:A10) and write down the highest counts that are the same, i
cell column 12 (cell L) of sheet1 for each individual row ?

Thanks
Michae

--
Message posted from http://www.ExcelForum.com


Frank Kabel

Maximum Count
 
Hi
have a look at
http://www.cpearson.com/excel/duplic...tractingCommon

--
Regards
Frank Kabel
Frankfurt, Germany


Can someone help me with the formula or vba to compare row 1 to row
100 of sheet1 (cell,A1:A10) against sheet2 from row1 to row 300
(cell,A1:A10) and write down the highest counts that are the same, in
cell column 12 (cell L) of sheet1 for each individual row ?

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/




All times are GMT +1. The time now is 09:00 AM.

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