Formatting

[Serene]

Dear everyone,

I have the following data which I imported from MS Access

Position Score QuantumIncrease
GM 1 1.5%
GM 2 2.0%
GM 3 4%
S. Mgr 1 2%
S. Mgr 2 2.5%
S. Mgr 3 4.5%
...

As the Position is repeated, I want to summarise so that the table becomes shorter and easier to read, for example

Position Score QuantumIncrease
GM 1 1.5%
2 2.0%
3 4%
S. Mgr 1 2%
2 2.5%
3 4.5%

How can I achieve this without complex formulas or having to manually edit the contents?

Thanks in advance for your help!
Serene

 

[NARAYANK991]

Hi Serene ,

Assume your data is in columns A , B and C , and that the repetitive data entries are in column A , starting from A2 through say A53.

Select the data range A2:A53 , click on CF , and in the formula box enter :

=$A2=$A1

Select the Font color as White.

This will make the repetitions invisible.

Narayan