shili12
Member
I want all sequences from the below see column First serial to Last Serial :-
the result should be a single column in the next sheet as displayed below, see attachment as well.
# | Transaction Date | Company Name | Certificate Type | First Serial # | Last Serial # | Qty(Out/In) | User Name | Available Balance | comment |
379 | 04/01/2022 16:09 | T Insurance Company Ltd. | Type B - Commercial Vehicle | B12071013 | B12071512 | -500 | William K | | I want all sequences |
380 | 04/01/2022 16:25 | T Insurance Company Ltd. | Type B - Commercial Vehicle | B12063010 | B12063010 | -1 | Insurance API | | |
381 | 04/01/2022 16:28 | T Insurance Company Ltd. | Type B - Commercial Vehicle | B12063011 | B12063011 | -1 | Insurance API | | |
382 | 04/01/2022 16:28 | Stephen Too | Type B - Commercial Vehicle | B12063012 | B12063038 | -27 | Aggrey O | | |
383 | 04/01/2022 16:29 | R Insurance Agencies | Type B - Commercial Vehicle | B12063039 | B12063048 | -10 | Aggrey O | | |
384 | 04/01/2022 16:29 | K Insurance Agency Ltd | Type B - Commercial Vehicle | B12063049 | B12063051 | -3 | Aggrey O | | |
385 | 04/01/2022 16:30 | J Insurance Agency | Type B - Commercial Vehicle | B12063052 | B12063065 | -14 | Aggrey O | | |
386 | 04/01/2022 16:30 | H Insurance Agency | Type B - Commercial Vehicle | B12063066 | B12063069 | -4 | Aggrey O | |
the result should be a single column in the next sheet as displayed below, see attachment as well.
Output Column B |
B12071013 T insurance company Ltd |
B12071014 T insurance company Ltd |
B12071015 T insurance company Ltd |
B12071016 T insurance company Ltd |
B12071017 T insurance company Ltd |
B12071018 T insurance company Ltd |
B12071019 T insurance company Ltd |
B12071020 T insurance company Ltd |
B12071021 T insurance company Ltd |
B12071022 T insurance company Ltd |
B12071023 T insurance company Ltd |
B12071024 T insurance company Ltd |
B12071025 T insurance company Ltd |
B12071026 T insurance company Ltd |
B12071027 T insurance company Ltd |
and so on and so forth till the end....... |
Attachments
Last edited: