Hi everyone,
i have a sheet called "Dump"
On column A there's a list of names.
I have another sheet called "Data"
On that sheet on column A, i want to return all the names in column A of the "dump" file, but only ONCE.
Like, once they get a hit, it goes to the next row and look for another name, until all the name come up on top of each other.
Is that doable?
Attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Does this help?
Excel 2016 (Windows) 32 bit
Bob Bob Bill Bill James James Bob Sarah Bob Sarah Bill
Sheet: Sheet2
Excel 2016 (Windows) 32 bit
=IFERROR(INDEX($A$2:$A$8,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$8),0,0),0)),"")
Sheet: Sheet2
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
That doesnt make it :/
Does that mean it doesn't meet your needs? it doesn't work? it gives an error? it gives the wrong results? I can assure you that if set up properly, AliGW's formula does work.That doesnt make it
Did you place the formula in row 2 (at least)? In Ali's example, it's in B2 and it refers to the cell above it (B1) so you can't start it in row 1.
Did you modify the range A2:A18 to match your data?
Did you properly place the anchors ($ signs) so that range $B$1:$B1 expands as you copy the formula down?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I just don't understand what's in the formula or what it refers to, so trying to adapt to my document might be what is creating the issue.. let me just try again
Try
in A2 of "Data" (A1 is blank)
=IFERROR(INDEX(Dump!$A$2:$A$100,MATCH(0,INDEX(COUNTIF($A$1:A1,Dump!$A$2:$A$100),0,0),0)),"")
If you attached a workbook, as requested, it would be much easier for everyone.Originally Posted by xatomicx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks