Forum Widgets
Latest Discussions
Baud rate of 460800 in excel data streamer
Hi, I am trying to acquire data from RPLIDAR C1 in excel data streamer, but the baud rate to make it work needs to be 460800. When I try to change it in excel data streamer it does not offer that speed and when i type it it does not seem to keep it. It's back to 9600 as soon as i close the advanced window. any suggestion?YobelMay 22, 2025Copper Contributor17Views0likes1CommentConditional Formatting for multiple range
I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns? so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100,00%" which is the sum of percentages in each tables. Is there a way to do that?LaosiMay 22, 2025Copper Contributor15Views0likes1Comment网赌被黑怎么办 有办法挽救吗?
(wx:RYG622)(QQ:157764444)(飞机@lmg567)先出款,后收费! I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes a macro to run, and that macro consistently runs for about 30 seconds. The problem is that the reason I'm reformatting the data is to import into Access, and I don't want my users to have to have intimate knowledge of Access or Excel to reformat the data and import it into the Access database. Thus, I've created a form with a button that allows the user to select a file from a dialog box, and then the macro runs on that file. Ad for some reason, when done this way, the macro takes upwards of 6 minutes. I don't know if it would be helpful to post the code of the macro here, or if there's some generic advice that will help. I just can't imagine why this increase in run-time is happening.27Views0likes1CommentRegional CSV Issue
Hi I was wondering if someone could help with a very annoying CSV file issue. I am a remote worker based in South Africa working in a finance team for a UK based company. The company uses Xero as their accounting software, and to import data into xero I need to create CSV columns with data in multiple defined columns (which vary depending on what type of data I am importing) However, for some reason whenever I download the CSV template direct from xero, populate the columns with the data and save it, when it comes to importing into Xero, I get an error message saying Xero can’t read any of the data. I have sent this CSV file to my manager, and when he opens it, the column headers in row 1 are all in the right columns, however the data that I have populated in rows 2 and below are all bunched together in column A, with lots of commas separating the different data points. Likewise, if my manager creates the CSV himself, and then sends me that file, when I open it the same thing happens again (Column headers in row 1 stay in their columns but all data from row 2 and below gets bunched up together in column A) I am pretty sure it is a delimiter issue, but I have tried changing my regional settings to no avail, as well as using the text to columns button and using comma as a delimiter then resaving, but that still doesn’t work. Any advice would be greatly appreciatedselinabissessur72May 22, 2025Occasional Reader11Views0likes1CommentMove up to next blank row after copy/paste from previous sheet.
Snowman got me rolling with code that does almost exactly what Im trying to do. After I hit end of day button Im trying to get the copied data to move up to the next blank cell in column B within a range. If I have any data in B2:B9,B11:B21,B23:B29 marked with a t next to it in column A and hit the end of day button only data in cells marked with that t are moved to the next sheet in the same cells they came from. What Ive noticed is only data in B2:B9 go to the exact same cell. B11:B21 are offset by 1, and B23:B29 are offset by 2. This is fine as the data is still moving. What I want it to do is for those ranges move up to the next blank cell in column B. So if I have data only in B4, and B6 I want that to transfer to next sheet in B2,B3. The same for the other 2 ranges. I also dont want it to overwrite anything that may already be in a cell on the next sheet. If I have "Tree" in B2 of the next sheet I want the data to go to B3,B4. Same for the other two ranges. I have tried xlUp, xlDn, and played with the code that was given to me by Snowman to try and make it work. Im not getting anywhere with this. I thought maybe if I create another macro that after I transfer the data would move everything up into blank cells then Id be okay with that also. Im not having any luck with that either. I even recorded a macro for copy/paste but that wont work if there is data in a cell already that I need to keep, and not be overwritten. I have attached a copy of the workbook. Hopefully this time it will allow it to be published with this query.BrianP475May 22, 2025Copper Contributor14Views0likes1Comment"Reverse FV" function? Or?
Hi all, I need some help please. I would like formula for excel, where I have known inputs: A1 = 30 (number of years) A2 = 500000 (needed capital) A3 = 8% (known yearly return of investment p.a.) A4 = 10000 (initial investment) and I need to calculate needed monthly investment, to reach that required sum (in A2). Thank you very much for your help and time. DanielOBWM_Daniel_OMay 22, 2025Occasional Reader54Views0likes2CommentsExcel
Português (BR): Estou enfrentando um problema persistente na padronização de dimensões de ilustrações, imagens e pictogramas no Excel. Mesmo ao tentar definir uma altura padrão (ex: '1.4' cm para uma ilustração de hexágono) no campo 'Altura' da guia 'Formato da Forma', duas figuras diferentes, com ambas selecionadas (Segurando Ctrl), resultam com tamanhos divergentes (ex: 1,38 cm e 1,36 cm), em vez do valor exato digitado (1,4 cm). Já verifiquei as propriedades, incluindo a fixação da taxa de proporção, e tentei soluções como copiar/colar e reiniciar o Excel, sem sucesso. O mais intrigante é que, por um breve período, consegui padronizar as dimensões corretamente, mas o problema retornou inexplicavelmente, mesmo no mesmo arquivo. Suspeito de alguma configuração ou atalho que possa estar interferindo. Percebi que isso não acontece, por exemplo, no PowerPoint, apenas no excel. Gostaria de saber se possuí algum tipo de configuração específica para não ocorrer esse ajuste/arredondamento automático no Excel. E gostaria de uma solução eficaz para garantir que todas as ilustrações selecionadas mantenham o tamanho exato que digito.JPMCA005May 22, 2025Occasional Reader14Views0likes1CommentExcel no longer opening files with [] in the file name
Since office 365 upgraded to version 2504 our users have been unable to open files with [ ] in the file name. Example a file with the name [12004][]_MCH_12004-SSC Pacific.xlsx excel throws the errors Basically cutting off the whole file and only finding 12004 now. Why was this functionality taken away. We understand that [] is not recommended in an excel file name. We have antiquated systems written in COBAL that auto generate these file with the brackets. Older versions of office still can access the files but anyone with 365 can not. How can we get this functionality back? Nothing in the changelogs for office version 2504 mentions a change to remove this functionality.fair-riteMay 21, 2025Occasional Reader90Views0likes1CommentFormula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Hello everyone! Thank you in advance for any assistance you are able to offer. I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that will populate one employee's evaluation results as a % correct for each of multiple worksheet tables of reviewed items (pass/fail). See attached workbook for details on what I'm trying to do. I would like to be able to choose an employee's name from a drop down on the RESULTS tab, select the months to begin and end a date range and have this return the total reviews and number failed for each 'Review Name' for that employee. Thanks again! :)SolvedMarcus_BoothMay 21, 2025Brass Contributor141Views0likes10CommentsFind and Replace Highlight colour
When I'm using the Find and Replace function and hit find, Excel finds the cell but its very hard to see because of the highlighted colour. Is there a way to change the default colour? Thanks in advance.Solvedmark_murphy_manlukMay 21, 2025Brass Contributor68KViews3likes51Comments
Resources
Tags
- excel42,718 Topics
- Formulas and Functions24,783 Topics
- Macros and VBA6,422 Topics
- office 3656,055 Topics
- Excel on Mac2,659 Topics
- BI & Data Analysis2,382 Topics
- Excel for web1,929 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,647 Topics