Extracting a list of values from column A where column B contains a specific value

خرید بک لینک

From the following table:

ID     Status
001    Done
002    Done
003    Done
004    Error
005    Done
006    Error
007    Done
008    Done
009    Error

I want to extract a list/string of all the IDs with an 'Error'. In other words, a cell which looks like this:

004, 006, 009

Thanks in advance.

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: extracting a list from excel,extracting a list of users from active directory,extracting a list of names from excel,extracting a distribution list from outlook,extracting from a list in r,extracting a continuous list based on criteria,extracting list elements in python,extracting list elements in r,extracting data from a list in excel,extracting values from a list in r, نویسنده: استخدام کار بازدید: 435 تاريخ: چهارشنبه 27 مرداد 1395 ساعت: 9:59

صفحه بندی