So glad you found it helpful! Thanks for watching!
@be4bharat
3 ай бұрын
Very well explained. 👍
@SharonSmith
3 ай бұрын
Glad you found it helpful! Thanks for watching!
@dfergusonmpa
3 жыл бұрын
Very helpful. Thank you.
@SharonSmith
3 жыл бұрын
Glad to help! Thanks for watching!
@ericpresa
3 жыл бұрын
the rank formula isn't working as expected, it's missing the $ on the range reference.
@theresaglenn5421
2 жыл бұрын
Hi. Thank you for the video. Question - why are their duplicate numbers in the ranking column? Seems like each number should only appear once, but I see lots of #1's and a couple # "3s." Thank you for explaining.
@ericturnquist1970
2 жыл бұрын
I'm seeing the same issue, I have multiple RANK of 1, 2, 3, 4 and 5
@mebermudez
Жыл бұрын
Hi Sharon, is there an answer to this question? Thanks
@davekenny9987
Жыл бұрын
As epresa states below, Sharon missed a vital step when copying the RANK formula down the table. She ranked [cell to the left] in a range of,say, d2 to d99. However when she copied it down the RANGE moved, relative to the cell it was copied to. The trick is to use $ to fix the range, or part of it. So instead of ....=RANK(D2,D2:D99) it should have read =RANK(D2,D$2:D$99). Then when it copies down the range would always span 2-99. Hope that makes sense.
@michaelring8248
2 жыл бұрын
Once created, can new rows be added and will it still function? Many thanks.
@Bagsandthingsbysilvia
3 жыл бұрын
Awesome 👏🏼 thank you 🙏🏼
@guiafab
Жыл бұрын
hi. why does the value in RAND change?
@WillOren
2 жыл бұрын
Any way to get this to return last and first name? We have employees with either same last or same first names. We have the first and last names in separate columns as well.
@michaelring8248
2 жыл бұрын
Hi, Re: HOW TO SELECT MULTIPLE RANDOM WINNERS FOR A PRIZE GIVEAWAY - Is there any way to lock the resulting 'Winners' until a 'Clear Results' Button is Pressed. Also Placing a 'Recalculate' Button. I believe both are possible but I don't know how it's done.
@syedikramullah1114
3 жыл бұрын
Nice
@SharonSmith
3 жыл бұрын
Thanks for watching, Syed!
@mohammedmaroof3030
3 жыл бұрын
Appreciate
@SharonSmith
3 жыл бұрын
Thanks for watching!
@fotografmorteneriksen
2 жыл бұрын
Rank does not accept the formula given here..I got the norwegian version of excel. I use the equivalent formula buut no. Sigh
Пікірлер: 24