Dear All,
Thanks in advance for your time to help me with my inquiry.
I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it.
Example of output required.
ENOC SITES : 140 ARE. [ Data below is having different Site numbers, but I want to group them all together]
SHARJAH CO-OP : 260 ARE.
[TABLE="width: 568"]
<tbody>[TR]
[TD]9-Mar-17
[/TD]
[TD]ENOC SITE 1032 DUBAI UAE
[/TD]
[TD]ARE
[/TD]
[TD]95.01
[/TD]
[/TR]
[TR]
[TD]8-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]16.95
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL ZAJIL FAIRS MANAGEM SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL ZAJIL FAIRS MANAGEM SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]90.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]ADNOC AL ASRAR ABU DHABI ARE
[/TD]
[TD]ARE
[/TD]
[TD]114.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]73.55
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]50.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]40.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]55.00
[/TD]
[/TR]
[TR]
[TD]5-Mar-17
[/TD]
[TD]AL MANAMA H/MARKET-BR DUBAI ARE
[/TD]
[TD]ARE
[/TD]
[TD]63.90
[/TD]
[/TR]
[TR]
[TD]4-Mar-17
[/TD]
[TD]ENOC SITE 1036 DUBAI UAE
[/TD]
[TD]ARE
[/TD]
[TD]112.01
[/TD]
[/TR]
[TR]
[TD]3-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]100.80
[/TD]
[/TR]
[TR]
[TD]2-Mar-17
[/TD]
[TD]GIFTS MARKETS GEN.TRAD SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]49.50
[/TD]
[/TR]
[TR]
[TD]1-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]142.40
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for your support and efforts.
Thanks in advance for your time to help me with my inquiry.
I have some expenses data where I want to select common or close text from a list and sum the amount spent for a specific month "Mar". Then I will work on creating a dashboard out of it.
Example of output required.
ENOC SITES : 140 ARE. [ Data below is having different Site numbers, but I want to group them all together]
SHARJAH CO-OP : 260 ARE.
[TABLE="width: 568"]
<tbody>[TR]
[TD]9-Mar-17
[/TD]
[TD]ENOC SITE 1032 DUBAI UAE
[/TD]
[TD]ARE
[/TD]
[TD]95.01
[/TD]
[/TR]
[TR]
[TD]8-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]16.95
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL ZAJIL FAIRS MANAGEM SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL ZAJIL FAIRS MANAGEM SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]90.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]ADNOC AL ASRAR ABU DHABI ARE
[/TD]
[TD]ARE
[/TD]
[TD]114.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]73.55
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]50.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]40.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD]6-Mar-17
[/TD]
[TD]AL SHAAB VILLAGE-AL ZA SHARJAH UAE
[/TD]
[TD]ARE
[/TD]
[TD]55.00
[/TD]
[/TR]
[TR]
[TD]5-Mar-17
[/TD]
[TD]AL MANAMA H/MARKET-BR DUBAI ARE
[/TD]
[TD]ARE
[/TD]
[TD]63.90
[/TD]
[/TR]
[TR]
[TD]4-Mar-17
[/TD]
[TD]ENOC SITE 1036 DUBAI UAE
[/TD]
[TD]ARE
[/TD]
[TD]112.01
[/TD]
[/TR]
[TR]
[TD]3-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]100.80
[/TD]
[/TR]
[TR]
[TD]2-Mar-17
[/TD]
[TD]GIFTS MARKETS GEN.TRAD SHARJAH ARE
[/TD]
[TD]ARE
[/TD]
[TD]49.50
[/TD]
[/TR]
[TR]
[TD]1-Mar-17
[/TD]
[TD]SHARJAH CO-OP, HALWAN SHJ ARE
[/TD]
[TD]ARE
[/TD]
[TD]142.40
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for your support and efforts.