Hi Experts,
Following is the data and I want to concatenate the numbers with unit. The data is extracted from (=SUMIFS()).
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Sometimes there is only one unit i.e. "PCS" or two units i.e. YDS and PAR or sometimes all seven units.
What I am trying to achieve is get the quantity and unit if it is present otherwise return void.
I mean if there is only 938 YDS then a cell must return: "938 YDS".
I mean if there are 1750 SET and 1100 MTR then a cell must return: "1,750 SET, 1,100 MTR".
I mean if there are 1750 SET and 1100 MTR and 1377 KGS then a cell must return: "1,750 SET, 1,100 MTR", 1,377 KGS".
Please guide / advise.
Thanks in advance.
Following is the data and I want to concatenate the numbers with unit. The data is extracted from (=SUMIFS()).
A | B | ||
1 | Quantity | Formula Enetered | Unit |
2 | 1219 | =SUMIFS(F42:F71,G42:G71,"PCS") | PCS |
3 | 1377 | =SUMIFS(F42:F71,G42:G71,"KGS") | KGS |
4 | 1750 | =SUMIFS(F42:F71,G42:G71,"SET") | SET |
5 | 938 | =SUMIFS(F42:F71,G42:G71,"YDS") | YDS |
6 | 1100 | =SUMIFS(F42:F71,G42:G71,"MTR") | MTR |
7 | 2390 | =SUMIFS(F42:F71,G42:G71,"PAR") | PAR |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
Sometimes there is only one unit i.e. "PCS" or two units i.e. YDS and PAR or sometimes all seven units.
What I am trying to achieve is get the quantity and unit if it is present otherwise return void.
I mean if there is only 938 YDS then a cell must return: "938 YDS".
I mean if there are 1750 SET and 1100 MTR then a cell must return: "1,750 SET, 1,100 MTR".
I mean if there are 1750 SET and 1100 MTR and 1377 KGS then a cell must return: "1,750 SET, 1,100 MTR", 1,377 KGS".
Please guide / advise.
Thanks in advance.