Thank you so very much. I am actually trying to convert detailed balance data
into summarised version and your help has been very useful. To advise on
another issue I just noticed €“ could you also please help
Each item has got many values but I just need to pick the last value for
each item eg:
From the list below; I only need to sum/calculate 4 for Plant, 8 for
Furniture & 3 for Motor Vehicle (ie last value for each item one by one)

ITEM VALUE

Plant 5
Plant 5
Plant 4
Plant 4

Furniture 8
Furniture 8

Motor Vehicle 3
Motor Vehicle 3
Motor Vehicle 3
Motor Vehicle 3
Motor Vehicle 3

Your help would be highly appreciated.
Thanks


"Salman" wrote:

Please help. If I have few numbers in a column and I want to delete pairs eg
following should only show 5+4 = 9 (ie delete/cancel off what makes a pair):
5
5
5
5
5
4
4
4

Thanks in advance.