If match function
I have 2 seperate excel files
in one file 7 columns ( Data in Text format varying from 10 to 15 digit) in another file 5 columns (Data In Numeric/ number format varying from 10 to 15 digit) Iwant to find the numbers of the first file col. B in other columns as well as in another files columns too. i.e. if in col. B if figure 1234567890 in raw 1 and 2345678901..... whether the same number is available in other columns of the same file as well as another file, and if available then which number ? no. in raw 1 or no. in raw 2 ? can i get the result in a seperate worksheet or a seperate column. Many time i have data more than 60000 lines in one column only. can i use if match function? in if match function it takes lots of time to varify the data and i have to wait even i have 1GB RAM. please help |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com