Posts by Márcio Feitosa • 57 points
7 posts
-
0
votes2
answers125
viewsA: EXCEL - ELEGANT FORMULAS
Hello, I could separate, as suggested by the colleague. A simple way to separate is by using Let or right and opening other columns. In your case you will have to open the columns from "F" to "K"…
excelanswered Márcio Feitosa 57 -
0
votes1
answer36
viewsA: Excel - Match Rows in Another file
Hello, you have to do this through VBA or want to do for work and can be by formulas? if it can be done by formulas the solution is rather simple. Just do an index-match or a simple Vlookup(procv)…
excelanswered Márcio Feitosa 57 -
1
votes2
answers1536
viewsQ: function to return the integer number
what I’m doing wrong in my job? num2 = float(input("digite um número não inteiro: ")) def arrend(numero): if num2 - math.floor(num2) < 0.5: numero = math.floor(num2) return numero return…
-
1
votes2
answers409
viewsQ: returning python list indexes
I’m having a problem on the line index, because it does not accept float. But how can I get around it? def median(numbers): numbers.sort()#The sort method sorts a list directly, rather than…
-
0
votes3
answers2710
viewsA: get the 3 largest numbers from a python list
It worked that way: def top_three(input_list): input_list.sort() tops=input_list[-3:] q=sorted(tops, reverse=True) return q list1 = top_three([2,3,5,6,8,4,2,1]) print (list1)…
-
1
votes3
answers2710
viewsQ: get the 3 largest numbers from a python list
someone can help me find the mistake? """Returns a list of the three largest Elements input_list in order from largest to smallest. If input_list has Fewer than three Elements, Return input_list…
-
2
votes3
answers1432
viewsQ: Print element from a specified position in the list
I need to get you to print the August days number on the list, but without using the: def how_many_days(month_number): """Returns the number of days in a month. WARNING: This function doesn't…