Suppose the following spreadsheet: ID Name ZE2S Ronaldo Alexandre Carlos ZE2S Ronaldo Alexandre Carlos ZE2S Ronaldo Alexandre Carlos ZE2S Ronaldo Alexandre Carlos ZE2S Ronaldo Alexandre Carlos ZE2S Ronaldo Alexandre Carlos ZE3W Deborah Gomes Lachini ZI1A Wanderley Cezario de Souza ZI1A Wanderley Cezario de Souza ZI1A Wanderley Cezario de Souza ZI1A Wanderley Cezario de Souza ZW21 Gustavo Adolfo There are other columns, which I skipped. I need a formula that will return the lines with IDs that appear only once on the spreadsheet. On the example above, the result would be: ZE3W Deborah Gomes Lachini ZW21 Gustavo Adolfo Thank you SO SO much!!!!!!!!!!! AMD Athlon XP 2700+ Asus A7V600-X 512 MB of PC3200 DDR RAM GeForce FX 5200 256 MB Seagate 120 GB SATA

This may help: http://www.mrexcel.com/archive/Data/11300.html M

pivot table with ids and "name numbers" in crossed field. next filter on "1".