How to show 1st & last number something like below when expanded serial is presented?
In the case two serials are continuing for THE same Branch, that too should reflect in the respective Branch. Eg As per Branch RA it has two serials. Once this is done the final results should be like below
RA 112545-112554 10
RA 115450-115455 6
EH 112555-112563 9
Please refer this data set & recommend me a easy solution. You may send me the formula that should be written to achieve this. QVW cannot be opened up.
Since two serials are applicable for RA00, Can it be shown under two rows such as how I have shown. Because one serial goes from 112545-112554 & other serial from 115450-115455 .
If I cannot have two different serials for RA, the voucher allocation count for RA cannot be properly made. Because if we get the difference of 112545-115455, the answer is not correct. but it should be the difference of (112545-112554) & (115450-115455) separately to have the exacts voucher allocations