The objective and examples are provided. I finally took the time to layout the desired outcome and I can see this could be above my knowledge level, even though I'll be plowing into it in the next two weeks. In any case, I could use anything from some insights to a solution to transfer to the final project.
Thanks.
Hi and welcome to the board
Try in B18
As it is array formulae, Confirm with <Ctrl>+<Shift>+<Enter> then Copy down
=IF(COUNT(OFFSET($B$8,,MATCH($C$15,$C$7:$F$7,0),3))<ROWS($A$18:A18),"",INDEX($B$8:$B$10,SMALL(IF(NOT(ISBLANK(OFFSET($B$8,,MATCH($C$15,$C$7:$F$7,0),3))),ROW(INDIRECT("1:"&ROWS($B$8:$B$10)))),ROW(A1))))
In C18
copy down then accross=IF(ISERROR(VLOOKUP($B18,$B$7:$H$10,MATCH(C$17,$B$7:$H$7,0),0)),"",VLOOKUP($B18,$B$7:$H$10,MATCH(C$17,$B$7:$H$7,0),0))
I can up;od workbook if u'd like
Last edited by contaminated; 01-23-2010 at 03:57 AM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Re: Transferring filtered data from one table to another
I'm uploading workbook with ready for me sample...
Thank you Vusal M. Dadashev. I appreciate the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks