Serial Number Equation Adjustment

[Hany ali]

Hello My Dear ...I Want Your Help to Correct This Function which in Column E To Work as well

=IF(A91="","",AGGREGATE(14,6,$E$2:E90/($A$2:A91=A91)*($B$2:B91=B91),1)+1& IF(B91="National Park Fees", IFERROR(VLOOKUP(A91,Setting!$E$6:$G$321,3,FALSE),""),""))

AS YOU SEE in this Line

Follow Aqua Center

National Park Fees

01/04/2022

15/04/2022

1F

Serial Number it Must Be 38F Not 1F ..Thanks Alot

 

[bosco_yip]

Try,

In E90, array ("Ctrl"+"Shift"+"Enter") formula copied up or down as per screenshot:

=IF(A90="","",AGGREGATE(14,6,IF(A90="Empty Carpet",$E$2:E89,IF(B90="National Park Fees",LEFT($E$2:E89,LEN($E$2:E89)-1),$E$2:E89))/($A$2:A90=A90)/($B$2:B90=B90),1)+1& IF(B90="National Park Fees", IFERROR(VLOOKUP(A90,Setting!$E$6:$G$321,3,FALSE),""),""))

 

[Hany ali]

thanks alot ..Array work well ,It is really required,But is there a normal equation instead of Array to implement the students, as you know that the Array makes work slow on the excel file