Conditional Vstack?

hollytrab

New Member
Joined
Jan 29, 2025
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Hello,
I need to return a unique list of employee IDs if a column contains specific text. I need to vstack EEID if Column B contains Supplemental Life Insurance. With no duplicates, desired result below.

0090Supplemental Life InsuranceChildren-Supplemental Life and AD&D -Child Only
0090Supplemental Life InsuranceEmployee-Supplemental Life and AD&D - Employee Only
0127Supplemental Life InsuranceEmployee-Supplemental Life and AD&D - Employee Only
0161Supplemental Life InsuranceSpouse-Supplemental Life and AD&D -Spouse Only
0080Basic Life InsuranceEmployee-Basic Term Life and AD&D

0090
0127
0161
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
How about
Excel Formula:
=UNIQUE(FILTER(A2:A100,B2:B100="Supplemental life insurance"))
 
Upvote 0
Solution
Perfect! Thank you!
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.
 
Upvote 0

Forum statistics

Threads
1,226,525
Messages
6,191,566
Members
453,665
Latest member
WaterWorks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top