Rectify wrong alignment

If that doesnt work, try this in a helper, copied down...
=IF(L2="","",MID(L2,LEN(L2)-2,99))

What formula was used to produce those results in teh 1st place? could you not just re-run it again?

Thanks, this is just what I needed, but when I click "replace all" it replaces every space in the sheet, no just the L column, the L column is highlighted, I don t know what I'm doing wrong

EDIT: Solved using Ford's formula, many thanks!
No, I couldn't re-run it, can't find a proper way to explain, sorry.

Happy to help and thanks for the feedback

Hi bibu,

I gave you some help on an earlier post a few days ago, and I was interested in what you are doing.

This may be of no use to you, but I became challenged, so thought I'd try something different!



In the attached workbook, I have taken the two books you sent me, and devised a macro which reads through the scores, and gives you the result from the selected players perspective. Same as Col L, but for now, it is in Col O (so that you can see they're the same). Just press the Sets Score button.

In this solution, you don't have to worry about the matches that don't involve the selected player, the macro returns a blank.

I have also had the macro spit out 1st set wins, Match wins and number of sets played.

On the Analysis sheet, you can see many of the results you are after, and you can choose which surface you are looking at. I'm not sure what you are looking for in row 11, but I suspect there is enough information on the Results sheet.

One other thing, there is a macro button to Remove Duplicates. It looks at the first four columns and removes duplications based on names, tournament and date.

COMMENTS:
1. I note that matches which end due to retirement are ignored. I assume this is because there is no indication of who retired!
2. Males playing in majors play 5 sets. The Analysis sheet doesn't allow for this - how would you deal with that?

Anyway - good luck with it! Will be interested if this is of any use!


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Further to my message earlier today.

David