Spreadsheet: 775152d1648842567-to-find-date-of-this-month-when-sales-is-1st-time-greater-than-max-sales-of-last-month-find-1st-time-greater-sales-date
Sheet: Sheet1

 |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  | M1 - Month 1 (Last to Last)
Symbol | DATE | SALE |  | Symbol | [NAME] |  | 1ST TIME Highest sale inMarch compared to [NAME]  sale of Feb
DIVISLAB | 2022-02-01 00:00:00 | 309874 |  | DIVISLAB | 2585446 |  |  | In H coloumn, I want March month date for every symbol where 1 st time sales is greater than [NAME] sales of Feb Month (Last Month) mentioned in F Coloumn.
DIVISLAB | 2022-02-02 00:00:00 | 346003 |  | HINDALCO | 35212827
DIVISLAB | 2022-02-03 00:00:00 | 504989 |  | TATASTEEL | 17605446
DIVISLAB | 2022-02-04 00:00:00 | 964227 |  | DRREDDY | 982850
DIVISLAB | 2022-02-07 00:00:00 | 380821
DIVISLAB | 2022-02-08 00:00:00 | 436195
DIVISLAB | 2022-02-09 00:00:00 | 280094
DIVISLAB | 2022-02-10 00:00:00 | 559595
DIVISLAB | 2022-02-11 00:00:00 | 2585446 |  |  |  |  | A Coloumn | All Symbols ae there
DIVISLAB | 2022-02-14 00:00:00 | 1147299 |  |  |  |  | B Coloumn | Feb & March month dates are there
DIVISLAB | 2022-02-15 00:00:00 | 371572 |  |  |  |  | C coloumn | Feb & March months Day wise sales for that perticular symbol is there
DIVISLAB | 2022-02-16 00:00:00 | 1373620 |  |  |  |  | F coloumn | [NAME] sale in Feb Month for every symbol is mentioned
DIVISLAB | 2022-02-17 00:00:00 | 601590 |  |  |  |  | H Coloumn | To Find March month Date when 1st time sales in march is greater than [NAME] sale of feb month which is mentioned in F Coloumn.
DIVISLAB | 2022-02-18 00:00:00 | 580486 |  |  |  |  | [NAME] | [NAME] is applicable to give reference of Last month (Here Feb Month whose [NAME] sale data is in F coloumn)
DIVISLAB | 2022-02-21 00:00:00 | 284980
DIVISLAB | 2022-02-22 00:00:00 | 430407
DIVISLAB | 2022-02-23 00:00:00 | 379328
DIVISLAB | 2022-02-24 00:00:00 | 723045
DIVISLAB | 2022-02-25 00:00:00 | 450834
DIVISLAB | 2022-02-28 00:00:00 | 611670
DIVISLAB | 2022-03-02 00:00:00 | 576094
DIVISLAB | 2022-03-03 00:00:00 | 421554
DIVISLAB | 2022-03-04 00:00:00 | 429937
DIVISLAB | 2022-03-08 00:00:00 | 414138
DIVISLAB | 2022-03-09 00:00:00 | 385251
DIVISLAB | 2022-03-10 00:00:00 | 414284
DIVISLAB | 2022-03-11 00:00:00 | 352915
DIVISLAB | 2022-03-14 00:00:00 | 3585448
DIVISLAB | 2022-03-15 00:00:00 | 403394
DIVISLAB | 2022-03-16 00:00:00 | 227588
DIVISLAB | 2022-03-17 00:00:00 | 438327
DIVISLAB | 2022-03-21 00:00:00 | 356749
DIVISLAB | 2022-03-22 00:00:00 | 292831
DIVISLAB | 2022-03-23 00:00:00 | 574783
DIVISLAB | 2022-03-24 00:00:00 | 467266
DIVISLAB | 2022-03-25 00:00:00 | 270912
DIVISLAB | 2022-03-28 00:00:00 | 316896
DIVISLAB | 2022-03-29 00:00:00 | 589480
DIVISLAB | 2022-03-30 00:00:00 | 360504
DIVISLAB | 2022-03-31 00:00:00 | 611205
HINDALCO | 2022-02-01 00:00:00 | 9809417
HINDALCO | 2022-02-02 00:00:00 | 7283452
HINDALCO | 2022-02-03 00:00:00 | 5078613
HINDALCO | 2022-02-04 00:00:00 | 12631663
HINDALCO | 2022-02-07 00:00:00 | 10939353
HINDALCO | 2022-02-08 00:00:00 | 9863290
HINDALCO | 2022-02-09 00:00:00 | 9235351
HINDALCO | 2022-02-10 00:00:00 | 10906403
HINDALCO | 2022-02-11 00:00:00 | 9110193
HINDALCO | 2022-02-14 00:00:00 | 4995178
HINDALCO | 2022-02-15 00:00:00 | 8233217
HINDALCO | 2022-02-16 00:00:00 | 4348474
HINDALCO | 2022-02-17 00:00:00 | 5340469
HINDALCO | 2022-02-18 00:00:00 | 3344269
HINDALCO | 2022-02-21 00:00:00 | 6308263
HINDALCO | 2022-02-22 00:00:00 | 10664925
HINDALCO | 2022-02-23 00:00:00 | 8928934
HINDALCO | 2022-02-24 00:00:00 | 24819208
HINDALCO | 2022-02-25 00:00:00 | 13815949
HINDALCO | 2022-02-28 00:00:00 | 35212827
HINDALCO | 2022-03-02 00:00:00 | 41248362
HINDALCO | 2022-03-03 00:00:00 | 18676314
HINDALCO | 2022-03-04 00:00:00 | 20490598
HINDALCO | 2022-03-08 00:00:00 | 19477245
HINDALCO | 2022-03-09 00:00:00 | 15686460
HINDALCO | 2022-03-10 00:00:00 | 14824703
HINDALCO | 2022-03-11 00:00:00 | 7635725
HINDALCO | 2022-03-14 00:00:00 | 7904911
HINDALCO | 2022-03-15 00:00:00 | 13005715
HINDALCO | 2022-03-16 00:00:00 | 10485661
HINDALCO | 2022-03-17 00:00:00 | 11581454
HINDALCO | 2022-03-21 00:00:00 | 14159371
HINDALCO | 2022-03-22 00:00:00 | 7490300
HINDALCO | 2022-03-23 00:00:00 | 13581577
HINDALCO | 2022-03-24 00:00:00 | 12139664
HINDALCO | 2022-03-25 00:00:00 | 11087146
HINDALCO | 2022-03-28 00:00:00 | 7075442
HINDALCO | 2022-03-29 00:00:00 | 5245788
HINDALCO | 2022-03-30 00:00:00 | 11195965
HINDALCO | 2022-03-31 00:00:00 | 23497993
TATASTEEL | 2022-02-01 00:00:00 | 17075268
TATASTEEL | 2022-02-02 00:00:00 | 7524734
TATASTEEL | 2022-02-03 00:00:00 | 6514090
TATASTEEL | 2022-02-04 00:00:00 | 9317418
TATASTEEL | 2022-02-07 00:00:00 | 14510525
TATASTEEL | 2022-02-08 00:00:00 | 14083984
TATASTEEL | 2022-02-09 00:00:00 | 7352060
TATASTEEL | 2022-02-10 00:00:00 | 9392057
TATASTEEL | 2022-02-11 00:00:00 | 9676226
TATASTEEL | 2022-02-14 00:00:00 | 8021613
TATASTEEL | 2022-02-15 00:00:00 | 10188921
TATASTEEL | 2022-02-16 00:00:00 | 6609214
TATASTEEL | 2022-02-17 00:00:00 | 5655792
TATASTEEL | 2022-02-18 00:00:00 | 4725120
TATASTEEL | 2022-02-21 00:00:00 | 4978732
TATASTEEL | 2022-02-22 00:00:00 | 9385857
TATASTEEL | 2022-02-23 00:00:00 | 4960838
TATASTEEL | 2022-02-24 00:00:00 | 12126867
TATASTEEL | 2022-02-25 00:00:00 | 9212886
TATASTEEL | 2022-02-28 00:00:00 | 17605446
TATASTEEL | 2022-03-02 00:00:00 | 24847532
TATASTEEL | 2022-03-03 00:00:00 | 17450338
TATASTEEL | 2022-03-04 00:00:00 | 16282923
TATASTEEL | 2022-03-08 00:00:00 | 9107822
TATASTEEL | 2022-03-09 00:00:00 | 6934888
TATASTEEL | 2022-03-10 00:00:00 | 13674062
TATASTEEL | 2022-03-11 00:00:00 | 11882299
TATASTEEL | 2022-03-14 00:00:00 | 5278082
TATASTEEL | 2022-03-15 00:00:00 | 9614313
TATASTEEL | 2022-03-16 00:00:00 | 6302451
TATASTEEL | 2022-03-17 00:00:00 | 10623976
TATASTEEL | 2022-03-21 00:00:00 | 8422763
TATASTEEL | 2022-03-22 00:00:00 | 8179588
TATASTEEL | 2022-03-23 00:00:00 | 13055238
TATASTEEL | 2022-03-24 00:00:00 | 9460527
TATASTEEL | 2022-03-25 00:00:00 | 6945744
TATASTEEL | 2022-03-28 00:00:00 | 4655491
TATASTEEL | 2022-03-29 00:00:00 | 4320237
TATASTEEL | 2022-03-30 00:00:00 | 5848316
TATASTEEL | 2022-03-31 00:00:00 | 4006795
DRREDDY | 2022-02-01 00:00:00 | 371663
DRREDDY | 2022-02-02 00:00:00 | 305001
DRREDDY | 2022-02-03 00:00:00 | 221537
DRREDDY | 2022-02-04 00:00:00 | 246993
DRREDDY | 2022-02-07 00:00:00 | 255958
DRREDDY | 2022-02-08 00:00:00 | 396403
DRREDDY | 2022-02-09 00:00:00 | 198880
DRREDDY | 2022-02-10 00:00:00 | 237865
DRREDDY | 2022-02-11 00:00:00 | 337538
DRREDDY | 2022-02-14 00:00:00 | 449386
DRREDDY | 2022-02-15 00:00:00 | 358011
DRREDDY | 2022-02-16 00:00:00 | 380613
DRREDDY | 2022-02-17 00:00:00 | 229031
DRREDDY | 2022-02-18 00:00:00 | 358108
DRREDDY | 2022-02-21 00:00:00 | 587951
DRREDDY | 2022-02-22 00:00:00 | 480840
DRREDDY | 2022-02-23 00:00:00 | 371484
DRREDDY | 2022-02-24 00:00:00 | 697127
DRREDDY | 2022-02-25 00:00:00 | 305433
DRREDDY | 2022-02-28 00:00:00 | 982850
DRREDDY | 2022-03-02 00:00:00 | 1540635
DRREDDY | 2022-03-03 00:00:00 | 1334725
DRREDDY | 2022-03-04 00:00:00 | 1208050
DRREDDY | 2022-03-08 00:00:00 | 784169
DRREDDY | 2022-03-09 00:00:00 | 809369
DRREDDY | 2022-03-10 00:00:00 | 712099
DRREDDY | 2022-03-11 00:00:00 | 1113263
DRREDDY | 2022-03-14 00:00:00 | 570058
DRREDDY | 2022-03-15 00:00:00 | 471294
DRREDDY | 2022-03-16 00:00:00 | 358776
DRREDDY | 2022-03-17 00:00:00 | 772587
DRREDDY | 2022-03-21 00:00:00 | 401639
DRREDDY | 2022-03-22 00:00:00 | 1290222
DRREDDY | 2022-03-23 00:00:00 | 1044114
DRREDDY | 2022-03-24 00:00:00 | 1738147
DRREDDY | 2022-03-25 00:00:00 | 864397
DRREDDY | 2022-03-28 00:00:00 | 496907
DRREDDY | 2022-03-29 00:00:00 | 421084
DRREDDY | 2022-03-30 00:00:00 | 616826
DRREDDY | 2022-03-31 00:00:00 | 611719