How to remove rows from TableView in JavaFX?

Remove duplicates

• My remove duplicates is a bit different from all the others I have seen. I have OfficeService Pack 2. Column D-S contains the same information. Column A-C does not. So to say, A-C has Row 1 with information; Row 2 blank. Row 3 with information, Row 4 blank, and so forth sometimes up to 6,000 rows. (I have done a transpose of anWorksheet [below] so you can see the info). How do I get rid of those with blank in A&C. I would like Row 1656 to remain in remove 1657; Keep 1658, remove 1569? If you notice 1661-1665 are blanks but those highlighted are different. So I cannot do a conditional to show only duplicates of PO #, and filter ship dates -blank, because that will delete those in row 1661-1665 I did Data Tab>Data Tools>Remove duplicates, with Select All. I also tried removing Column A&B. All lines remained. Next one I tried Data Tab>Sort & Filter>Advanced>Copy to Location>List of Range $A$1:$S$2846> InDistro!$E:$S>Select Unique Records Only. I tried other multiple ways, using this method, and still nothing. I am sure it is something easy, but it is just not clicking.

• Answer:

  WENDY, If I understand the question correctly, I would go to column O or the next blank column. then in O3 I would put a formula =if(And(i3=i2,f3=f2),"Delete","Unique") and drag fill down the column. I would then filter on that column for the Delete value and select all the visible rows and delete them. Then remove the filter. Now you did say something about Ship dates - but I don't follow how that helps. If it must be considered as well, you can add that as a condition in the And Statement. If it must be blank then =if(And(i3=i2,f3=f2,c3=""),"Delete","Unique") If the check must be based on the next row instead of the previous row, then start in O2 =if(And(i3=i2,f3=f2,c2=""),"Delete","Unique")