05-26-2020 06:47 AM
05-26-2020 07:06 AM
05-26-2020 07:26 AM - edited 05-26-2020 07:28 AM
I'm afraid it's still not clear.
Let's start again. Give me a before and after, clearly specifying what values you have in what cells.
Before (what you have now)
cell A1: x
cell A2: y
cell A3: z
After (what you want to see)
cell A1: z
cell A2: x
cell A3: y
Better still, post an actual workbook.
05-26-2020 07:49 AM
This is a list of data that I have made.
Ik would like to know all the data with an “a”in it in proper order: Result:
These are dat of a volleybal game. Nr 10 is the setter and I want to find or there is a pattern in the way the setter plays.
A 4 – A2 – A 3 are positions at the net.
05-26-2020 11:51 AM - edited 05-26-2020 11:54 AM
Yes, of course, if you're not using an English language-version of Excel then you'll need to do that. I always use this online Excel translation tool:
which, in this case, gives:
I should also have mentioned that this won't work for you if you're using Excel 2007 or earlier. I can provide you with an alternative formula if that's the case.