Hi all,
I have been trying this for a while and I am not really sure there is a solution but I hoped maybe someone in here would know this.
So I have a table with a lot of information and i would like to consolidate it by customers.
So for example for John I would like the formula to return any info there is of john on any of the other rows.
I have attached an excel spreadsheet that hopefully will make it clearer.
Hope someone can help me,
Rompetelo
Try this ARRAY formula in D15, copied down and across...
=IFERROR(INDEX(D$3:D$11,SMALL(IF(($C$3:$C$11=$C15)*(D$3:D$11<>""),ROW($D$3:$D$11)-2),1)),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks