Hi All,
I was wondering if anyone could help me, i have a list of people, and payments.
for example :
<colgroup><col><col></colgroup><tbody>
</tbody>
I basically need to find a way that i can list all the values from one person in a separate list
I am using the following formula :
=IFERROR(INDEX(RawData!$B$1:$B$500,SMALL(IF(RawData!$A$1:$A$500="James",ROW(RawData!$A$1:$A$500)-ROW(RawData!$A$1)+1),ROWS(RawData!$A$1:$A500))),"")
Issue i am having is that i have a large number of blanks in my array $A$1:$A$500 in preparation for additional entries, and as a result i cannot obtain a full list of payments
i believe thats the SMALL function doing it but i'm not sure of a way round it,
it is doing my head in, could someone help
Gavin
I was wondering if anyone could help me, i have a list of people, and payments.
for example :
Eddie | 10 |
Steve | 12 |
Steve | 65 |
Steve | 12 |
Steve | 12 |
Steve | 35 |
Steve | 56 |
James | 66 |
James | 73 |
James | 21 |
James | 33 |
James | 21 |
James | 21 |
James | 56 |
James | 5 |
James | 5 |
James | 5 |
James | 78 |
James | 54 |
James | 54 |
James | 5 |
James | 43 |
James | 23 |
James | 43 |
James | 4 |
Paul | 54 |
Paul | 67 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I basically need to find a way that i can list all the values from one person in a separate list
I am using the following formula :
=IFERROR(INDEX(RawData!$B$1:$B$500,SMALL(IF(RawData!$A$1:$A$500="James",ROW(RawData!$A$1:$A$500)-ROW(RawData!$A$1)+1),ROWS(RawData!$A$1:$A500))),"")
Issue i am having is that i have a large number of blanks in my array $A$1:$A$500 in preparation for additional entries, and as a result i cannot obtain a full list of payments
i believe thats the SMALL function doing it but i'm not sure of a way round it,
it is doing my head in, could someone help
Gavin