Calc Removing a number from a range [closed]
I am trying to automatically remove a number from a range of cells, if it appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times, it changes color to Red.......got that part.
Then I want to manually enter that number somewhere into J4:N21. once entered into J4:N21, i want that number to erase from B4:G11.
ideally at that point i would also like all remaining numbers in B4:G11 to shift up, leaving no empty cells above cells with values in them (keeping them in the order entered within columns).