Noptes in support of answer for this Post:
https://excelfox.com/forum/showthrea...ll=1#post14591


_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP Wrong results
2
 NSE ACC EQ
1265
1282.7
1246.5
1275.3
1247
22
 BUY
202
 <--Ws1
3
 NSE ADANIENT EQ
151.85
165.45
151.4
151.85
152.35
25
 BUY
303
4
 NSE ADANIPORTS EQ
348
348
338.5
346.55
338.85
15083
 BUY
0
5
6
 output wanted in K of 1.xls which is Ws1 D E F G H I J K L
7
1
 Exchange Symbol Series/Expiry Open High Low Prev Close LTP wanted results
8
2
 NSE ACC EQ
1265
1282.7
1246.5
1275.3
1247
22
 BUY
101
9
3
 NSE ADANIENT EQ
151.85
165.45
151.4
151.85
152.35
25
 BUY
202
10
4
 NSE ADANIPORTS EQ
348
348
338.5
346.55
338.85
15083
 BUY
303
11
5
12
13
14
15
 Ws2 - AlertCodes.xlsx B C D E F G H I J K L
16
1
 NSE
22
6
 <
100
 A GTT
17
2
 NSE
25
6
 <
200
 A GTT
18
3
 NSE
15083
6
 <
300
 A GTT
19
4
Worksheet: 1-Sheet1 13July