Previous Topic Next Topic

Compare two column from two different sheets

Closed
Rana2604 Posts 1 Registration date Wednesday July 12, 2017 Status Member Last seen July 12, 2017 - Updated on Jul 12, 2017 at 04:14 AM
 Blocked Profile - Jul 14, 2017 at 10:08 AM
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

Answer 1 / 1
Blocked Profile
Jul 14, 2017 at 10:08 AM
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!
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Comparing columns and returning value
ll -
kittu -

35 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses
macro to compare two excel sheets
annajins -
Aks -

6 responses