If and Countif

[marina123456]

Hi All!

I have a dynamic array that pulls records off the sample data, then these records get listed on another worksheet ( using "IF statement references". I don't mind the same record being pulled twice in the array part, but how do I edit my IF reference, so it only shows once in the main results? . For instance if my current cell is pulling a value form another sheet through if statement: =IF(Selection_Work!C2<>"",Selection_Work!C2,""). The value pulled is an invoice number - and some values are listed twice in the referenced column. However, when I remove duplicated by applying ( DATA, keep unique or remove duplicates), it removes all repeated records ( still need one of them). What is the best way to nest another formula (COUNTIF?) to make sure that records only listed once. Thank you!

[Gregb11]

For best results, please read the yellow banner at the top of the page and then attach a sample file.

[marina123456]

Thank you.

[davsth]

Read the yellow banner and attach a spreadsheet not screenshots.