i have 40,000 data in one sheet
i.e.
B1: dinesh kumar c1: kumar dinesh
B2 arun kumar yadav C2: yadav arun kumar
B2:amit kumar thakur c3: thakur kumar amit
i want match data to other column & result true false if possible any formula / macro
i have 40,000 data in one sheet
i.e.
B1: dinesh kumar c1: kumar dinesh
B2 arun kumar yadav C2: yadav arun kumar
B2:amit kumar thakur c3: thakur kumar amit
i want match data to other column & result true false if possible any formula / macro
Please explain the method which column value needs to be matched with which column and the expected output.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
2 column data and i want result true/false (match) in 3 column
i.e.
dinesh kumar kumar dinesh true
amit kumar thakur thakur amit false
arun kumar yadav kumar yadav arun true
Pl see the attached file with macro.
sample sheet attached i m trying this code work good but my excel sheet not work proper please check once again
approximately 37000 thousand data in 2 columns
thanks for reply
Last edited by sonu_kumar444; 10-30-2012 at 11:05 PM.
Hi -
and I suspect you're receiving "overflow" error right?approximately 37000 thousand data in 2 columns
if that would be the case, then change the "Integer" to "Long" on the script from kvsrinivasamurthy
Regards,
event
Pl see attached file. Macro working OK.
thanks macro working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks