LinkBack URL
About LinkBacks
kimudao 
hi expert
index match use for no duplicate primary key?
I 'd like to show all data into new sheet , don't delete duplicate.
how can i use new formular?
Please suggest.
hi expert
index match use for no duplicate primary key?
I 'd like to show all data into new sheet , don't delete duplicate.
how can i use new formular?
Please suggest.
If you want to show all the data, then why use a formula?
Cheers!
Deep Dave
use your formula with small modification as shown below
=IFERROR(IF(INDEX(Sheet4!$1:$1048576,ROW(),MATCH(Sheet4!A$1,Sheet4!$1:$1,0))=0,"",INDEX(Sheet4!$1:$1048576,ROW(),MATCH(Sheet5!A$1,Sheet4!$1:$1,0))),"-")
or
=IFERROR(IF(HLOOKUP(A$1,Sheet4!$A$1:$F$6,ROW(),0)=0,"",HLOOKUP(A$1,Sheet4!$A$1:$F$6,ROW(),0)),"")
Try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Agree with Dave, why not just ...
=IF(Sheet4!A2="","",Sheet4!A2)
copied down and across?
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
hi
i have to use formular due to i need all data but project switch column between origin data and new sheet.
So show us what what you want, and what you dont want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks