Hi to all. I have a list of 200 numbers (in no particular order) from 0 to 36. How can i catalogue them automatically with oneclick to an excel list from 0 to 36?
Hi to all. I have a list of 200 numbers (in no particular order) from 0 to 36. How can i catalogue them automatically with oneclick to an excel list from 0 to 36?
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi @mariosaba9
what do you mean by: How can i catalogue them ?
to order them?, to count repetitions?, or...
Barriers are there for those who don't want to dream
If you want to them, you can use the sort feature on the data tab
Guessing this is a roulette wheel and the list is the numbers that have won?
Are you trying to complete the matrix?
I refer you back to post #2.
Yes, i refer to order last 200 spins of roulette sorting them into the corresponding spin number.
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
I solved it by using the COUNT.IF function and now I have it solved. Thank you all.
./';lp[poi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks