Fetch the player's name with lowest score

[Kamal GKJ]

Hi Friends,

There are 4 peoples, I need to find the min score the people has claimed and add this player name to the list(Loop). It must get upgraded each and every time its updated.

Ex. Pivot data
Name Score
arauv 1
ragav 2
rithu 4
maya 3


Data Dump:
Sl no Name
1 arauv
2 ragav
3 rithu
4 maya
. .
. .
. .
55 ?(the name with lowest score).
Note: 1) This should be able to reflect in google sheet, 2) I have used the syntax (Index(match(max())).

 

[bhos123]

you are looking for VBA Macro, correct?

 

[Kamal GKJ]

Anything is ok with me.

 

[Kamal GKJ]

Formula might be more helpful.

 

[bhos123]

whenever you update the table, the result should add in a new row, macro is must I believe. I will update you on this.

 

[Kamal GKJ]

whenever you update the table, the result should add in a new row, macro is must I believe. I will update you on this.

Sure Please.

 

[bhos123]

Sub abc()


Dim x As Double
Dim y As Integer
Dim z As String
Dim c As Integer


Sheets("Sheet1").Select


x = Application.WorksheetFunction.Min(Range("B2:B5").Value)
y = Application.Match(x, Range("B2:B5").Value, 0)
z = Range("A1").Offset(y, 0).Value


c = Application.WorksheetFunction.CountA(Range(Cells(10, 1), Cells(10000, 1)))


Range("A10").Offset(c, 0).Value = c
Range("A10").Offset(c, 1).Value = z


End Sub

you have 4 names A2 to A5 and score in B2 to B5

type any text say 'Count' in A10

run this macro each time when there is an update in scores, you will get the results below A10. your sheet name should be 'Sheet1'

 

[Kamal GKJ]

thanks