Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.