RAJESH1960
Wellknown Member
 Joined
 Mar 26, 2020
 Messages
 743
 Office Version

 2019
 Platform

 Windows
Hello guys,
I need a little help in altering and adding 2 more conditions in the formula. The formula has 2 corrections to be made. One is instead of giving the result as “Not in GST”, I want the same date derived from the formula as in “Tally” in place of “Not in GST”, as mentioned in the formula. The second one it is displaying a mistake when the amount in Tally is displayed above GST in all the rows.
I am trying to get the dates as per GST in all the rows and same date for the same invoice numbers in Tally.
I need a little help in altering and adding 2 more conditions in the formula. The formula has 2 corrections to be made. One is instead of giving the result as “Not in GST”, I want the same date derived from the formula as in “Tally” in place of “Not in GST”, as mentioned in the formula. The second one it is displaying a mistake when the amount in Tally is displayed above GST in all the rows.
I am trying to get the dates as per GST in all the rows and same date for the same invoice numbers in Tally.
query.xlsx  

A  B  C  D  E  F  G  H  I  J  K  
1  A  B  C  D  No.  Get Dates  Date  Amount  As Per  Result  
2  1  301  NOT IN GST  27032021  7350.00  TALLY  Correct  
3  2  117  06072020  06072020  22050.00  GST  Correct  
4  3  117  06072020  08072020  22050.00  TALLY  Correct  
5  4  127  09072020  09072020  22050.00  GST  Correct  
6  5  127  09072020  11072020  22050.00  TALLY  Correct  
7  39  551  NOT IN GST  19092020  26775.00  TALLY  If Not in GST then dislpay tally date 1902020  
8  40  594  19092020  05012021  2688.00  TALLY  Mistake  Has to show 08012021  
9  41  594  08012021  08012021  2688.00  GST  Correct  
10  109  1209  12032020  12032020  5264.00  GST  Correct  
11  148  694  31032021  31032021  472.00  GST  Correct  
12  149  437  28022021  28022021  2006.00  GST  Correct  
13  150  150  17032021  17032021  6510.00  GST  Correct  
14  207  263  NOT IN GST  22052020  2822.00  TALLY  If Not in GST then dislpay tally date 1902020  
15  208  758  02072020  02072020  1050.00  GST  Correct  
16  209  32  02072020  02072020  1050.00  TALLY  Correct  
17  210  32  26102020  26102020  1050.00  GST  Correct  
18  211  758  26102020  26102020  1050.00  TALLY  Correct  
19  212  2001  19062019  19062019  1956.00  GST  Correct  
20  213  1979  11062019  11062019  2003.00  GST  Correct  
21  214  2490  17012020  17012020  2100.00  GST  Correct  
22  4010  111  17012020  01052021  2100.00  TALLY  Mistake  Has to show 09052021  
23  4011  111  09052021  09052021  2100.00  GST  Correct  
24  4012  111  NOT IN GST  09052021  2101.00  TALLY  Correct  
Exact Match 
Cell Formulas  

Range  Formula  
F2:F24  F2  =IF(I2="GST",G2,IF(COUNTIFS(I:I,"GST",E:E,E2,H:H,H2),G1,"NOT IN GST")) 
Cells with Conditional Formatting  

Cell  Condition  Cell Format  Stop If True  
F2:F24  Expression  =COUNTIFS($E$2:$E$1264,F2)>1  text  NO 
Last edited: