[libreoffice-users] Re: Calc function

Am 18.04.2012 17:56, Johnny Rosenberg wrote:
> Den 18 april 2012 09:47 skrev Andreas Säger<villeroy@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+help@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