Am 18.04.2012 17:56, Johnny Rosenberg wrote:
Den 18 april 2012 09:47 skrev Andreas Säger<ville...@t-online.de>:
Am 17.04.2012 19:35, Mike Phelan wrote:
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.
=IF(COUNTIF(B4;$J$4:$N$21);"";B4)
copy down 7 rows and 5 columns to the right.
Copy the resulting range and paste over 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).
Sort each of the 6 columns manually.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
