Sorry, but I do not write Portuguese.
At 21:19 24/08/2013 +0300, M Valdes Velasque wrote:
Sempre que a coluna A tiver célula igual a A1
localizar e copiar a terceira célula que esta
embaixo. Preciso localizar e copiar
simultaneamente somente as terceira célula que
esta embaixo de todas quando for idêntica
A1. Quando for idêntica a A1 localizar e copiar
a terceira celula que esta embaixo
It's not entirely clear what you are expecting as
your result here: do you just need a list in,
say, column B of these values - with nothing in
the cases where the value is not equal? In B2, enter:
=IF(A2=A$1;A5;"")
and fill this down column B. This will give a
list of the values you require, interspersed with
empty strings where the value in A does not equal A1.
Note that your sample list displays one problem
with your requirement: what would you like to
happen towards the bottom of your list when the
third cell below one that matches is off the end
of the list and therefore empty?
It is perhaps worth saying that if you run into a
problem such as this, it may well be sensible to
look back at the design of your
spreadsheet. Perhaps there is an easier method
of achieving what you actually need. If you
explain the original problem you are trying to
solve, someone may be able to give you more useful help.
Note that there are Portuguese-language (and
indeed Brazilian Portuguese) mailing lists: see
https://wiki.documentfoundation.org/Local_Mailing_Lists .
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
