Compare two column from two different sheets [Closed]

Report
Posts
1
Registration date
Wednesday July 12, 2017
Status
Member
Last seen
July 12, 2017
-
 Blocked Profile -
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 reply


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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!