Sample1 contains 3 columns Number ,RQ and Status.
Sample2 contains 2 columns Number and AQ.
To fill the status column:
If RQ<=AQ, Status = “available” else Status =" less available"
Sample1 sheet contains duplicate value which also needs to be assigned the Status based on the remaining AQ value.
Eg: firstly 3 is assigned Status = “available” then if 3 comes again(duplicate value), it will check for if and else condition for RQ and AQ where the AQ will be net AQ i.e. AQ-RQ.
I really need some help in solving this problem .Thanks a lot in advance.
This is SAMPLE1 sheet
This is SAMPLE2 sheet