Display VALUE if Condition Match

Zohaib Hassan

New Member
Joined
Nov 7, 2015
Messages
9
Dear Team,
Kindly help in my query, following is the explanation.
AB
1/3/2018 12:15 pm2/3/2018 03:20 am
5/3/2018 2:15am7/3/2018 9:00 am

<tbody>
</tbody>







CDEFGHI
1/3/20182/3/20183/3/20184/3/20185/3/20186/3/20187/3/2018
OKOKOKOKOK

<tbody>
</tbody>






I WANT, IF A1 HAVE THE STARTING DATE AND B1 HAVE THE ENDING DATE THAN C2 TO D2 WILL DISPLY "OK" SAME AS A3 HAVE STARTING AND B3 HAVE ENDING DATE THAN G2 TO I2 WILL DISPLY "OK" .

SO IF WE CHANGE THE STARTING AND ENDING DATE AUTOMATICALLY IT WILL DISPLY THE RESULT COMPARING WITH THE ASSIGN DATE IN C,D,E,F,...........

VBA NOT ALLOWED.....
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
CAPS OFF please!

This may need changing as your input is not uniform

in C2
=IF(AND(C1>=INT(A1),C1<=INT(B1)),"OK","")
copy to D2

in G2
=IF(AND(G1>=INT(A3),G1<=INT(B3)),"OK","")
copy across to I2
 
Upvote 0
A
B
D
E
F
G
H
I
J
K
L
M
N
O
P
-
-
-
-
1
1-9-2018 12:00 AM
2-9-2018 9:04 AM
DATE
1-9-2018
2-9-2018
3-9-2018
4-9-2018
5-9-2018
6-9-2018
7-9-2018
8-9-2018
9-9-2018
10-9-2018
11-9-2018
12-9-2018
-
-
-
-
2
5-9-2018 12:18 AM
6-9-2018 9:23 AM
DURATION
1
1
1
1
1
1
1
-
-
-
-
3
9-9-2018 12:37 AM
11-9-2018 9:42 AM
4
13-9-2018 12:56 AM
14-9-2018 10:01 AM
5
17-9-2018 1:15 AM
18-9-2018 10:20 AM
6
21-9-2018 1:34 AM
22-9-2018 10:39 AM
7
25-9-2018 1:53 AM
26-9-2018 10:57 AM
8
29-9-2018 2:12 AM
30-9-2018 11:16 AM
Dear what I require is , suppose if I put starting value in A1 and ending value in B1 than E2 to F2 display any value(I display 1) same as if I put starting value in A2 and ending value in B2 than I2 to J2 display any value. Also check In the table M2 N2 O2 DISPLAY 1 B/C A3 and B3 have the exact date comparision with M1-O1. NOTE: The date in column A and B varies not fix, it will display the value with comparison of starting and ending date.

<tbody>
</tbody>
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,908
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top