Hi there,
I have a set of data which I am trying to pull through into a nicer format. Due to the layout of this data the Vlookup and Index Match functions are not a solution.

In Column A I have People's names and the metric descriptions and Column B I have the metric values.
What i'm trying to do is have a function/formula that looks at Column A, Finds Jane Evans and gives me the number of Calls she has answered.


Name Metrics
Adam Smith
Logged in 07:00:00
Calls 10
ACW 00:01:30
Available 00:02:00
Jane Evans
Logged in 08:00:00
Calls 5
ACW 00:02:30
Available 00:01:00
Peter North
Logged in 07:30:00
Calls 15
ACW 00:00:30
Available 00:03:00


Can something be done?