Posts by Elienay Junior • 527 points
48 posts
-
-3
votes1
answer53
viewsQ: Extract names formatted with specific colors at different positions
I have names and they have colors corresponding to the name of the color itself. I intend to extract these names referring to the colors I want. The problem is that they are in different positions,…
excelasked Elienay Junior 527 -
0
votes2
answers60
viewsQ: Problems with formulas to extract texts with different spaces
I intend to extract only the numbers in red for the following table "Red", but the spaces are different and I have tested a lot of formulas to solve this issue. I used a rather complex formula, but…
excelasked Elienay Junior 527 -
0
votes1
answer443
viewsQ: Delete whitespace from Activex Excel combo box
I have a default list with values and another list of "Organization" when I delete values from the default list to another organization list, organize values. The problem is that I added a combo box…
-
0
votes1
answer108
viewsQ: Problems with Activex control (option button), counting values according to button marking
I want to count the values according to the marking of the button, for each click on each button, I intend to add 1,2,3 in each cells A29: A31. It also serves only one cell as long as it changes the…
excelasked Elienay Junior 527 -
0
votes2
answers3906
viewsQ: How to add values related to a line, searched with the Index + Corresp function in Excel?
I wanted to add some values related to the names given to the cells "Ref 1, 2 and 3" summing all the values of the columns "N1, N2 and N3" according to the "Ref" sought, for this I used this…
excelasked Elienay Junior 527 -
0
votes3
answers372
viewsA: Help with VBA - Excel to TXT
Use this: saveFile = Application.Getsavefilename(fileFilter:="Text Files (*. txt). I just pulled out the "As" "Getsaveas" and left Getsave, test there and see if it works!
excel-vbaanswered Elienay Junior 527 -
0
votes1
answer2827
viewsQ: How to change the size of the Activex Excel checkbox (Checkbox)?
I can’t change the size of the activex Excel checkbox, there is some way to change the size because it is too small and the font size option is disabled, I really wanted to leave it the desired…
-
-2
votes2
answers47
viewsQ: How to Filter specific values with Excel and add them in another table?
I wanted to filter only the letters "A" from the table on the left and add in the table on the right, bring all the letters "A" to the table on the right, according to the amount that each column(1…
excelasked Elienay Junior 527 -
0
votes1
answer1214
viewsQ: How to display the number of rows in the left sidebar of the VBA Excel?
How do I display the line numbering on the side highlighted in red in the VBA?? without showing the number of lines gets very confusing when debugging, as I do to show the number??…
excelasked Elienay Junior 527 -
0
votes1
answer203
viewsQ: Excel "If" function giving problem when checking if all values are true
I used the "If" and "Cont.se" function, but I wanted the "If" function to check if all sequence values of (C69:C73) are ="500", however when checking the penultimate value it considers that all…
excelasked Elienay Junior 527 -
2
votes2
answers218
viewsQ: How to add only the highest values of a numerical sequence in Excel?
I want to add only the values greater than '600' of this numerical sequence, I tried to use =SOMASE(B51:B60;>600;B51:B60), but it didn’t work! right after inserting the (>)major symbol, it…
excelasked Elienay Junior 527 -
1
votes0
answers63
viewsQ: What formula do I use Excel for product input and output?
I have a small table, where the 'QTD_E' = Input and 'QTD_S' = Output, for each withdrawal of the quantity of product in the 'QTD_E' I wanted to add how many products were removed in the 'QTD_S',…
excelasked Elienay Junior 527 -
0
votes0
answers59
viewsQ: Error "Procv" + "Corresp" function when inserting a combination box (Activex) with numerical references
I made a "procv" + "corresp" function to look for values from a table and added a combo box (activex), and added numbers to the "corresp" to look for the searched value in columns, but when using…
excelasked Elienay Junior 527 -
0
votes2
answers1621
viewsQ: How to use Excel’s "PROCH" function to fetch values from the bottom up?
By default the "Proch" function only looks for values from top to bottom, I intend to do the inverse, fetch the values from bottom to top, I want to search for the "40-D" character through the…
excelasked Elienay Junior 527 -
0
votes1
answer97
viewsQ: How to use Excel subtraction on a set of numbers?
I intend to subtract all the values from this small table, but if I have 100 different values, would I have any formula to summarize all the values in the same way as the sum formula, EX:…
excelasked Elienay Junior 527 -
0
votes1
answer221
viewsQ: "Somarproduct" function of Excel, does not sum the total of two distinct items in relation to the list,?
I used the function "Somarproduto" to add the total of products 1 and 2, but the result of zero, I wanted to add the total values of only two products on the list, but it only works by adding one,…
excelasked Elienay Junior 527 -
0
votes0
answers293
viewsQ: How to insert color formatting through a formula in Excel?
I have two cells with characters with different color formats, but when using the function Concatenar and other functions to extract the characters in another cell, the color format does not apply…
excelasked Elienay Junior 527 -
0
votes1
answer120
viewsQ: How to include weekends in the "=Diatrabalho" function and include additional holidays in Excel?
I have a start date and end of a schedule, I wanted to count the weekends that in case the end date would be 11/11/2018, how to use the function: =DIATRABALHO(C24;E24;Tabela1[DATA]) To count on the…
excelasked Elienay Junior 527 -
0
votes1
answer84
viewsQ: How to display separate characters from different sequences by skipping spaces in Excel
I want to display only the numbers in red of the sequence, but this formula only displayed the first specified number and the other after it or before it, I wanted to display jumps in any specific…
excelasked Elienay Junior 527 -
0
votes2
answers403
viewsQ: How to extract only the penultimate character from a sequence and then use auto-refilling in Excel
I have a numerical sequence separated by spaces, I just want to extract the numbers in red, but when using auto-refill (click and drag down with the cursor) it doesn’t work! how do I extract only…
excelasked Elienay Junior 527 -
0
votes1
answer43
viewsA: How to loop in selected cells in Excel?
Fixing the corresponding cells A15 to A17 and adding a "If" function on the A18 to C18, saying that if it is different from the numbering from 1 to 3 and fixing these values, call the cell…
excelanswered Elienay Junior 527 -
0
votes1
answer43
viewsQ: How to loop in selected cells in Excel?
When I click and drag down the following cells in the appropriate image, in the cell "E21" appears a '3' resulting from tracking the sequence of cells from "A15" to "A18" as I do to loop only the…
excelasked Elienay Junior 527 -
1
votes1
answer699
viewsQ: Function "=SE" with Excel "up" only works in column? but I did not proceed in line
In a small table, I inserted the function "=If" with the ":", but it only works if I put the numbers with their respective colored spheres in column, when I specify what I want from the cells…
excelasked Elienay Junior 527 -
-1
votes1
answer252
viewsQ: EXCEL. "Right" function how to set an automatic size for separate cells that exceeds the number of defined characters
I used the right function in cell "L33" but when I went to click and drag the values defined in the first cell, cell "L34" displayed not only the word 'technologies' but half the word 'software' and…
excelasked Elienay Junior 527 -
0
votes1
answer4265
viewsQ: In EXCEL, How to use Bold formatting of a cell and apply in a "concatenate" function in another cell
I have a small table, I intend to use the bold formatting of the cell "A20" of the number '2001-T' and apply in the function "concatenate" of the cell "F20", but any type of formatting I do in the…
excelasked Elienay Junior 527 -
1
votes1
answer118
viewsQ: How to specify an address that is outside a set of div
I made a menu with 'Hover' effect but I want to change the color of the gray bar of the menu by touching the cursor on the "Search and News" buttons but I do not know how to specify the address .…
-
1
votes1
answer30
viewsQ: Selector 'not' does not work
I have a gray box with a low opacity and inside it a word, when applying the 'not' selector to the main 'div' to cancel the opacity of the word that is in a "p" tag surrounded by that 'div' the…
-
0
votes1
answer73
viewsQ: Method prompt JS - 'if' 'Else if'
I am still a layman in JS, but this question I believe to be simple, I intend if if the user type a numerical value instead of letters, he write on the screen 'Wrong instance! ' and if he typed any…
javascriptasked Elienay Junior 527 -
1
votes1
answer73
viewsQ: @Keyframes, attribute 'Animation-delay' does not work inside a 'from' or 'to'
I intend to give a 'delay' to this animation but I’m not getting a delay before it goes to the center of the page, if I add 'Animation-delay' within the class. ft it already starts in the center of…
-
0
votes0
answers438
viewsQ: Line break inside an input type "search"
How to enable a line break, in an input type="search"? defining the amount of typed characters and the height of the search bar when identifying a specific amount of words for a line break, ??…
-
2
votes2
answers77
viewsQ: Float:; not working CSS
I intend to align these blocks in a horizontal line, but the use of the float:; is not meeting the expected, what mistake I am making? .fl > div{ float:left; } div:nth-child(1){…
-
3
votes1
answer29
viewsQ: How to prevent anchored links from leaving stored history
I have a code that has two blocks on the sides and when clicking on them happens a change of background color of the page, but as they are defined with 'target' that pull each element in an orderly…
-
1
votes1
answer32
viewsQ: To add links in a select and change the width of the select box before clicking
I tried to add a link reference to an item in a list 'select' "number 2" and it was not possible, which solution should I join to link this item?? and it is also not possible to increase the width…
-
1
votes1
answer126
viewsQ: How to Add an "overflow:scroll;" on the side of an extended datalist
I have a search bar type="text" next to a datalist, but I’m not succeeding by adding a scroll bar on the side of the displayed content, because the more we add names in the 'option value="" the more…
-
2
votes1
answer63
viewsQ: Edit an image through a content:url ( )' attribute of the ::after tag
I added an image url to a content:url(); however, I intend to edit the size of this image, straight from the tag. sub::after, after adding a 'width:;' the image continues to the same size, as I do…
-
1
votes2
answers25
viewsQ: Specify element not to receive properties from other main elements
I have a menu and I just wanted to specify an element so it does not receive the same properties applied in the others, in case the element would be #Lk "PRODUCTS" it is receiving all attributes…
-
2
votes1
answer31
viewsQ: Screen fit is not doing its function "@media screen and() { }"
The screen fit is not responding to the defined attributes, it seems to be right, but the width and height of the object when the browser screen is reduced in (max-width:400px) it has no effect,…
-
2
votes2
answers276
viewsQ: Line break control does not work "white-space: nowrap:"
I don’t know where I’m going wrong, but at 5° numerical sequence bar, you don’t want to line up linear, even if you give it a float:left; and a "nowrap" because I want to add a lower scroll bar to…
-
2
votes2
answers75
viewsQ: Slides, transitioning images with JS and radio, while leaning the mouse over the image pause the transition, while removing continue the transition
onload = start; function start(){ var i = 1; function Move(){ i = (i%3)+1; // 4 is the Number of image in slider document.getElementById('t'+i).checked = true; } setInterval(Move,3000); //change img…
-
1
votes0
answers122
viewsQ: Search system on the site itself, how to link as many pages and recognize the typed characters
I have a search bar here, but how do I search my htmls in my own pc directory? function executar(){ var tx= document.getElementById('tx').value; var lista = document.getElementById('ht'); var…
-
2
votes1
answer66
viewsQ: Smooth transition checkbox menu, without using "visibility:;" or "display:None;"
I have a small menu here, which has the use of overflow:Hidden; /max-height:; and height:; to make a smooth transition by clicking on the checkbox and displaying the subs-menus, however I am not…
-
9
votes3
answers2563
viewsQ: Is it possible to apply sound effects to Hover or click css?
Can you transmit a sound effect by touching the mouse to an object, text, etc.? wanted that when you hover over some object with effect 'Hover' that a sound effect, being any type of sound that…
-
0
votes2
answers900
viewsQ: How to increase the input="text" font and cursor according to the desired size?
I applied a 30px padding and the cursor and input source="text" did not increase as the internal spacing applied, is there any possibility of increasing the size as desired?? I tried applying a…
-
0
votes1
answer146
viewsQ: Someone would have a solution to turn "checkbox" into "radio"
I have a Jquery code along with Js, because I intend to turn checkbox into radio, this code works with radios, with just one click on the same location it unchecks the radio if it is marked, and if…
-
1
votes1
answer112
viewsQ: How to know the Jquery library version just by viewing the codes made by other users?
I have a small jquery code here, offered by a member of this site that I ended up finding, and I don’t know which version of the library I should upload and execute someone else’s code. I can’t…
-
1
votes1
answer23
viewsQ: How do I specify a distant address within several others using an input type="checkbox"
I have a menu made with lists 'ul' with a sub-menu when clicking on the "checkbox" The element is very far away and the reference using the "checkbox" is right at the beginning, I do not know how to…
-
0
votes0
answers19
viewsQ: Using "target" navigation anchors and browser history getting crowded!
I’m using Ancoras in a slide application in its proper back and forth arrows, but every click on the anchored arrows with links of the positions and images set in my directory, will store a content…
-
0
votes1
answer86
viewsQ: html and css, link selector through anchors, with next and Prev arrows
Could someone give me a hint on how to make a link selector through anchors, with forward and backward arrows, similar to the one in the image there?? because I only know how to use anchors through…