Find the solution for excel VBE EXCEL: Range:A500" - Last Name, "B2:B500" - First Name, "C1:C500" - Customer ID.

Find the solution for excel VBE

EXCEL: Range: "A1:A500" - Last Name, "B2:B500" - First Name, "C1:C500" - Customer ID.

1) a) Find the fifth customer whose first name starts with 'K', and show his/her customer ID (using Do While loop)

' b) Redo the above exercise with (Do Loop Until)

' c) Find how many Matthew are in the list (using any loop you like)

' and the same time find how many customers are in the list

' Take care of your stop condition