Ask Your Question

Calc Removing a number from a range [closed]

asked 2012-04-17 19:48:52 +0100

anonymous user


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 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).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 04:01:38.492815

1 Answer

Sort by » oldest newest most voted

answered 2012-08-02 07:47:45 +0100

JohnSUN gravatar image

updated 2012-08-02 07:49:13 +0100

You can not delete data from cells using the formula. But you can display the data without the deleted values ​​elsewhere. Typically use additional columns with formulas on a separate sheet for such operations.

See small example - Removing a number from a range.ods

edit flag offensive delete link more

Question Tools


Asked: 2012-04-17 19:48:52 +0100

Seen: 162 times

Last updated: Aug 02 '12