Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Sorting and Matching

  Asked By: Leona    Date: Nov 18    Category: MS Office    Views: 814
  

I have four columns A B C D contains 10,000 cells

Ex

A : Vehicle number (ex 4445)
B : Time in (ex 11.45)
C : Vehicle number (ex 3524)
D : Time out (ex 12.02)

I need to match Col A and C , if matched
subtract two correspodning time (D-C) and place
it new column with vehicle number

I am new to VBA. Kindly give sample code do this. Treat me as begineer

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Shawna Welch     Answered On: Nov 18

Do you need to search for the matching  Vehicle numbers in the whole
list, or just compare within the same row?

 
Answer #2    Answered By: Luise Fischer     Answered On: Nov 18

I need to search for vehilce numbers in whole list
not within row.

Kindly give me piece of code. So that I can finish
the project.

 
Answer #3    Answered By: Maxine Jones     Answered On: Nov 18

You don't need VBA. Just use the MATCH() and INDEX() functions.

 
Didn't find what you were looking for? Find more on Sorting and Matching Or get search suggestion and latest updates.




Tagged: