Re: [libreoffice-users] busca de soluções para Excel

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: users+unsubscribe@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