Recent questions tagged excel

0 votes

917 views

1 answer

excel - Why won't this formula calculate unless i double click a cell?

See this .xlsx file. No macros, of course! When you open the file, you will see the following cells: [ ... 20,30} items into the spreadsheet. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

910 views

1 answer

excel - compare one column value with all the values of other column using pandas

I have the one excel file which contains the below values I need to compare a_id value with all the value of b_id ... df3['b_id']).astype(int) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

809 views

1 answer

excel - The brute force method using VBA for solving an equation with nine unknown variables

This equation: a+(13*b/c)+d+(12*e)-f+(g*h/i)=87 appears when trying to solve the maths puzzle for ... but it's not nice and very slow. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

excel - VBA Autofilter With Multiple Criteria Using Variables

EDIT: To fix the issue, I changed Dim Placed As Range to As Long. I then changed Set Placed = Rows("3:3 ... ? Any help will be much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

excel - Selenium Webdriver (VBA): Explicit Wait

I am navigating a web application that will often throw an error if there is an attempt to click an element ... I would be extremely grateful. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

excel - get a number of unique values without separating values that belong to the same block of values

I'm OK with either a PL/SQL solution or an Access VBA/Excel VBA (though Access VBA is preferred over Excel ... include all OtherIDs under a fax. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

921 views

1 answer

excel - Trigger event when select from dropdown

I need when a user selects an option from the dropdown menu, it will trigger the event and lock down certain ... any problem with this code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

978 views

1 answer

excel - Multiple Column vs Multiple Column Lookup

I am after a formula to match a number of columns between two worksheets and return the last reference worksheets ... help is much appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - populate combobox in VBA with array elements

I have a VBA procedure (in Excel 2007) where I aspire to set the ListFillRange property of a combobox styled ... just adding element by element. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel - Loop through folder, renaming files that meet specific criteria using VBA?

I am new to VBA (and have only a bit of training in java), but assembled this bit of code with the help ... down to ABCPage#.jpg Thanks SO much! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

913 views

1 answer

excel - Worksheet_Change - Targeting multiple cells simultaneously

VBA beginner here. I have project where I have specified input cells for the user. When one of these ... across multiple cells? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

991 views

1 answer

excel - Xpath syntax to select nodes with multiple attributes in the path

My xml tree contains this in the structure <foo name="bar"> <location order="1">data1</location> <location order ... good> </datas> </IPSGDatas> See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

925 views

1 answer

excel - Scraping text from file within HTML tags

I have a file that I want to extract dates from, it's a HTML source file so it's full of code and ... 's the easiest way to achieve this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel formula - Reference for a dynamic range

I have a table A2:E7, where each column comes from a dynamic array formula. As a result, =A2#, =B2#, etc. ... for a range. Could anyone help? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Padlock symbol through vba

Is it possible to print a padlock symbol (open & closed) in a cell with Chr(), ChrW() or something similar through VBA? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - Query and parse xml attribute value into XLS using VBA

I'm trying to open/load an XML file specified in an Excel worksheet in the range B2. Then, search ... right direction for implementing this. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel - how not to skip empty first cell when saving as .CSV?

I have a question regarding the way data is saved to CSV files. It only occurs when you are trying to save a ... this tread but still no luck. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

886 views

1 answer

excel - Transforming multiple entries in a cell into multiple rows

I have an excel file with the names of bands and their genre. Column A: bandname. Column B: genre. The b ... ? Any clues? Thanks in advance. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

907 views

1 answer

excel - Android - convert doc, docx pages and xls, xlsx sheets to html using apache POI

I am developing an android application. In which I want to show the doc, docx, xlx, xlsx files in my ... org.apache.log4j.lf5.viewer.LogFactor5InputDialog$3) that doesn't come with...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - How to save group of shapes as JPG image?

I place a number of shapes on an image using VBA and want to save the whole group as a JPG. Sub SaveImageTEST( ... to visualize data on a map: See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

914 views

1 answer

excel - How to read attachment content from bot framework C#?

I am writing a bot and expecting the user to send me an attachment, which I want to read and ... attachment xlsx content please? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

913 views

1 answer

excel - VBA: Conver Text -> Number multiplying by 1

I have a table linked to a SQL database that I use to create some reports. The problem is that the ... False, Transpose:=False Any suggestions? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - How to find if substring exists in a list of strings (and return full value in list if so)

I have a list of brand names in A5:A7655 I have a list of potential substrings in D5:D1400 I need to find ... $D$1400)) with no success. Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - Advanced search complete event not firing in VBA

As the title suggests I cannot get the advanced search complete event to fire. I am running VBA through Excel ... (i).SenderName Next End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

922 views

1 answer

excel - Capturing connection errors

Following on from my Connections query, I now want to capture any connections that cannot be reached and throw an ... if this code would work? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel - .NET app.config question

I have created an Excel 2003 add-in that uses the CLR 2.0 and this add-in is to be installed in hundreds ... know of anything else I could try? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

excel - error xlPrimary not defined in Python win32com

I keep getting errors where xlCategory, xlValue and xlPrimary are not recognised in my python script. I am trying to ... 3.3 and Excel 2010. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

excel - VBA code for SUMIFS?

I'm trying to write a custom function that will let me retrieve a cell from the first row in a range that ... , those assumptions won't work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags