I would like to do the following, but cannot figure out if it is possible or not.
I have a HUGE List for my website inventory. I am trying to also show Item No. as an accessory type item on our site when the customer does a part search. my jet is similar to below
column / Row format
———-A ———– B——————– C (this is how i would like C to look)
1 —- DG668 —–DG668 —— DG668:T1663:T8262:U8211
2 —–T1663 ——-DG668 —– DG668:T1663:T8262:U8211
3 —- T8262 ——DG668 ——-DG668:T1663:T8262:U8211
4 —- U8211 —–DG668 ——- DG668:T1663:T8262:U8211
I would guess the formula would look down B and find duplicates, then copy the adjacent #'s into C for all of them.. Is this possible?
Date
Votes
6 comments
-
Jet Reports Historic Posts This will definitely confuse the Russians ;) - but I'm not sure I understand it either. Can you please upload the report you made? Or tell us how A, B and C are related to each other? I guess we're missing some tables and fields here.
-
Jet Reports Historic Posts Columns I, J, K are the target columns.
I"m starting to think this is going to be a VLookup function along with the Index Function. Just not sure how to put it together.
Need to look down Column J (using rows 9-12 as examples on the file i uploaded), and find all the duplicates and index the Item No. In Column I. after it finds all the duplicates it will then take all the Item No. from I and concatenate them into K. (If there are no duplicates in J then it can leave K empty. for the Rows 9-12 K would be filled in with 5554T: Row 23-25 Column K would be filled in with KH290:PY423 (The collon is a seperator)
Anyone Understand my Madness? -
Jet Reports Historic Posts Wait a minute… Column I, J and K? These are new to us. And you mention a file you uploaded - we don' see it.
Looks like I haven't fully recovered from the weekend yet - I am seeing things which aren't there and vice versa. More coffee please! :D -
Jet Reports Historic Posts File attached. didn't realize csv files were unauthorized. i zipped it up. I J and K are the columns in the report
-
Jet Reports Historic Posts Am I just not making sense? or does no one really not know how to do this?
-
Jet Reports Historic Posts Sorry, but I'm not sure I understand your csv file either. However, I'm taking my best guess and going to suggest that you look at NP("Join") and NL("AllUnique"). Something like
=NP("Join",NL("AllUnique","Item Cross Reference","Item No.","Cross-Reference No.","@@"&D6),":")
where cell D6 contains=NL("Rows=2","Item Cross Reference","Cross-Reference No.")
I'm attaching a file to show this.
Please sign in to leave a comment.