Microsoft Excel Question: Download MS Excel PDF
Is there a way in excel to write a formula to mark a cell with a symbol or letter or number that is the inverse of coordinates marked. example: if i mark the coordinates c/p with a \"1\" then excel will automatically mark it\s inverse p/c. and if i erase a symbol from, let\s say, d/g, then excel removes a symbol from the inverse which would be g/d. i will need to mark any particular (several, many) particular cells more than once such as 2 or three times. can i do it all with the same symbol or number (or letter).
reason: i want to make a table of sorts where the names of badminton players are listed
down vertically and in the same order horizontally. therefore b,b would have the same name such as carol, c/c might be joe, d,d might be shaun, etc.
that way when, let\s say carol and shaun are partners in a game and i type the symbol in the coordinates b/d, then excel will mark d/b automatically. that way i can keep track by seeing who has played with who already, not at all, or even played together 2 or 3 times. does this make sense to you? (i doubt i mathmatically did not write coordinates properly, maybe it should be a letter then comma then the other letter).
Answer:
No Answer is Posted For this Question
Be the First to Post Your Answer Now
Download MS Excel PDF Read All 143 MS Excel Questions
Be the First to Post Your Answer Now