Excel data compar
Hi everyone,
I have two Excel spreadsheets. On one of them i have two collumns that contains a range of number. Like in cell A1 there is the number 2470000 and in the cell B1 there is 2470099. On the second spreadsheet, there is 2470000 in the cell A1 and 2479999 in cell B1. What i need to do is to check if the range of number i have on the first spreadsheet is included in the range of the second spreadsheet. Any idea how i could do that. Thanks in advance ! |
Excel data compar
http://www.j-walk.com/ss/excel/usertips/tip073.htm
try it hth -- regards from Brazil Thanks in advance for your feedback. Marcelo " escreveu: Hi everyone, I have two Excel spreadsheets. On one of them i have two collumns that contains a range of number. Like in cell A1 there is the number 2470000 and in the cell B1 there is 2470099. On the second spreadsheet, there is 2470000 in the cell A1 and 2479999 in cell B1. What i need to do is to check if the range of number i have on the first spreadsheet is included in the range of the second spreadsheet. Any idea how i could do that. Thanks in advance ! |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com