Previous Topic Next Topic

Compare two column from two different sheets

Closed
Rana2604 Posts 1 Registration date Wednesday 12 July 2017 Status Member Last seen 12 July 2017 - 12 Jul 2017 à 01:16
 Blocked Profile - 14 Jul 2017 à 10:08
Hi...I want to compare two column from two different sheet which contain time and date.In sheet A column with date and time.In sheet B , there are two column.First column with date and time and in second column there is some text....I want that text in sheet A against Time and Date.but there is one condition ....Time and Date from Sheet B is less or equal to Time and date from Sheet A , by 2 hrs.....Eg. If 19-06-2017 19:53:49 this time in Sheet A then I required data from Sheet B Which is less then equal to (19-06-2017 19:53:49 - 2hrs).

1 response

Réponse 1 / 1
Blocked Profile
14 Jul 2017 à 10:08
To reference another sheet, it is as simple as:
SHEET1!A1 or SHEET2!A1

Are you familiar with logic like <, >, and =? If so, you can use the IF function for something like:

=IF(Sheet1!A1 > Sheet2!A1, true, false)

Have FUN!

Similar discussions

macro to compare two excel sheets
annajins -
Aks -

6 responses
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme
drsuresh26 -
ac3mark -

1 response
How to compare two different columns
ABACUS -
TrowaD -

1 response
compare and count
vinod -
pcsces -

1 response
Compare Fields
Swapnil Arjun Veer -
Mazzaropi -

1 response