Hi,
I have a speadsheet of a lot of data which i want to tidy up. Please see attached.
On the worksheet Data, i have a list of codes in column A which are duplicated for different entry in column E. Column E contains account numbers that also are duplicated depending on whether they are associated against the code in column A.
The worksheet Table is how i am trying to format the data.
The problem is i have over 3000 lines of data so copy and pastinf is very time consuming.
Thanks
Andy
in Table!A2
=IFERROR(INDEX(Data!$A$2:$E$1000,AGGREGATE(15,6,ROW(Data!$A$2:$A$1000)/((Data!$A$2:$A1000=A$1)),ROWS(A$2:A2))-(2-1),5),"")
copy down for as many rows as you have in Data Column A, ie over 3000
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Sorted, Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks