olá pessoal,
Necessito de encontrar na tabela em anexo o maximo de viaturas que se encontram em simultâneo no exterior.
alguma função que devolva esse valor?
obrigado
olá pessoal,
Necessito de encontrar na tabela em anexo o maximo de viaturas que se encontram em simultâneo no exterior.
alguma função que devolva esse valor?
obrigado
Welcome to the forum!
This is an interesting problem. I don't know any short cut formula. I did it the long way.
Hopefully some experts will pick it and help solve the problem in a more elegant way.
Using Google Translate: https://translate.google.com/
Bem-vindo ao fórum!
Este é um problema interessante. Não conheço nenhuma fórmula de atalho. Eu fiz isso pelo caminho mais longo.
Esperançosamente, alguns especialistas irão escolher e ajudar a resolver o problema de uma forma mais elegante.
Obrigado pela ajuda.
Sua solução me ajudou muito, porém ainda é muito complicado de aplicar no meu caso real, pois tenho muitos valores (1 ano com +10.000 linhas).
Talvez alguém ajude como você fez
Atenciosamente.
Perhaps the following will help.
1. The names of the vehicles are listed in F1:J1
2. Cells E2:E16 are populated using: =COUNTIFS(F2:J2,">0")
3. Cells F2:J16 are populated using: =COUNTIFS($A$2:$A$16,$A2,$C$2:$C$16,"<"&$D2,$D$2:$D$16,">"&$C2,$B$2:$B$16,F$1)
4. Cell M1 displays the maximum vehicles out at one time using: =MAX(E2:E16)
Note that this method calculates five vehicles to be out at one time, which by observation appears to be correct i.e. when vehicle A goes out at 10:30, vehicles B and C are still out and before vehicle A returns at 11:00 vehicles D and E go out.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks JeteMc for answering the call of the calvary.
Cell B6 I believe is wrongly stated as Viaura D. If changed to Viatura D, max is 4.
@josephteh, Good catch - Thank You.
I also changed I1 in my file from Viaura D to Viatura D which puts the max at 5.
Oh ya.. by the way.. great formula! Here is a Rep!
@josephteh, Thank You for the feedback and for the added reputation. I hope that you have a blessed day.
You are welcome, JeteMc. You too have a blessed day.
muito bom!
obrigado pelo vosso esforço,
acho que consegui resolver o meu problema.
muito obrigado.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You have given me NEGATIVE reputation - was there a problem? You added the words "thank you" to the reputation comment box, so was this a mistake?
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks