| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
