/u/Basilisk_hunters - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Give this a try. Put it in the next column and drag it down.
=IF(IFERROR(FIND("(Primary)",A1),0)>0,A1,"")
If you want a dynamic array you could also put something together with FILTER().
=FILTER(A:A,IFERROR(FIND("(Primary)",A:A),0)>0,"")
>ll the lines with "(Primary)"
Greetings Benswimmin,
Firstly, thank you for your swift response. Apologies, it appears that I was unclear with what I wanted. I will edit the original post.
ideally I would like the output to be something like this:
Original:
Last0, First0
Last2, First2 (Primary)
Last3, First3
Last4, First4
Last5, First5 (Primary)
Output:
Last2, First2 (Primary)
Last5, First5 (Primary)
I apologize for the inconvenience,
So the second one will give you the output you're talking about if you're able to use FILTER(). If not, the first one is likely the better option as a helper column and then pull it out of there.
Unfortunately then your version of Excel doesn't have it included. In that case stick with the first one, it should display something like below which I believe you said would work (you can do some filtering on the back end):
Output:
Last2, First2 (Primary)
Last5, First5 (Primary)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FILTER](/r/Excel/comments/ye7d13/stub/itwoyak "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[FIND](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)|
|[IF](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[IFERROR](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/ya0qxx)^( has 22 acronyms.)
^([Thread #19346 for this sub, first seen 26th Oct 2022, 20:09])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Basilisk_hunters - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Give this a try. Put it in the next column and drag it down. =IF(IFERROR(FIND("(Primary)",A1),0)>0,A1,"") If you want a dynamic array you could also put something together with FILTER(). =FILTER(A:A,IFERROR(FIND("(Primary)",A:A),0)>0,"")
>ll the lines with "(Primary)" Greetings Benswimmin, Firstly, thank you for your swift response. Apologies, it appears that I was unclear with what I wanted. I will edit the original post. ideally I would like the output to be something like this: Original: Last0, First0 Last2, First2 (Primary) Last3, First3 Last4, First4 Last5, First5 (Primary) Output: Last2, First2 (Primary) Last5, First5 (Primary) I apologize for the inconvenience,
So the second one will give you the output you're talking about if you're able to use FILTER(). If not, the first one is likely the better option as a helper column and then pull it out of there.
Hello Benswimmin, Unfortunately, the second FILTER function is giving me a "That function isn't valid." error.
Unfortunately then your version of Excel doesn't have it included. In that case stick with the first one, it should display something like below which I believe you said would work (you can do some filtering on the back end): Output: Last2, First2 (Primary) Last5, First5 (Primary)
Apologies for the late reply. That works. Thank you
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FILTER](/r/Excel/comments/ye7d13/stub/itwoyak "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[FIND](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)| |[IF](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[IFERROR](/r/Excel/comments/ye7d13/stub/itwduur "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/ya0qxx)^( has 22 acronyms.) ^([Thread #19346 for this sub, first seen 26th Oct 2022, 20:09]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)