#11
|
|||
|
|||
![]() put this in column D1 and copy it dowm
You want need column E delete it =ROUNDUP(100/B1,0) This will divide your rating into 100 and then round it up to the next hole number. Cheers |
#12
|
|||
|
|||
![]() Hi Crackone,
That's exactly what I was after! Thanks for your patience and help - much appreciated. That's what I like about this website the help that is freely available from all sources - Sensational! |
#13
|
|||
|
|||
![]() Quote:
I am a self accredited "gun" at excel so if you want to send me a sample i can see if i can automate more for you. you know Christmas holidays and the like - a bit bored - so need some new projects. cheers Aussie |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|