Adjusting For Deleted Random Numbers

[KevinE]

Hi,

I have a long list of names with numbers associated to each one.
Similar to the cut down version below....

John 7
Bill 5
Dave 1
Fred 6
Mike 4
Nick 8
Paul 3
Alan 2

The numbers are random and the result of another formula. If I delete a
certain name and associated number, is there a formula that will then
adjust all numbers down by one - if they are outside the deleted
number? The total deletions could number one or more.
Similar to this....

John 6
Bill 4
Dave 1
Fred 5
Mike 3
Nick 7

Alan 2


Thanks in advance for any help.

Kevin.

 

[Biff]

Hi Kevin!

When you say the numbers are random and generated by a
formula, does that mean there can be duplicates?

If not then you can try this assuming that the names are
in col A and the numbers are in col B

Use a helper column and enter this formula sat, in C1:

=IF(B1="","",RANK(B1,B$1:B$8,1))

Copy down as needed. Based on your sample data this will
be the output:

John 7 6
Bill 5 4
Dave 1 1
Fred 6 5
Mike 4 3
Nick 8 7

Alan 2 2


Biff