Most answered questions in Others

0 votes
1 answer

Not Like has no effect while looping an Array

you can add parentheses instead... mixing an ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,010 points
279 views
0 votes
1 answer

excel not reading some data

When using the sep option in the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,010 points
282 views
0 votes
1 answer

Document changes in a graph excel

To be able to trace changes, the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,010 points
291 views
0 votes
1 answer

Copying only one column of Userform ListBox data to single cell in separate spreadsheet with commas separating data

Try this: Private Sub CommandButton1_Click() ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
511 views
0 votes
1 answer

Read excel file without opening it in vb.net

Instead of utilising the variable strFileName, you ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
1,748 views
0 votes
1 answer

Why is my excel calculation bringing back a "value" other than zero?

Column D's formula should be changed so ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
332 views
0 votes
1 answer

Split the column cell value of location in 3 different columns

If the Location column has always the same pattern, ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
425 views
0 votes
1 answer

Laravel : Call to undefined method Maatwebsite\\Excel\\Excel::load()

In the app's exports, I've added InterfaceSupplier ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
3,056 views
0 votes
1 answer

VBA Repeatable Function on button click

Remove Duplicates Based on a Single Column The ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
287 views
0 votes
1 answer

Arrange charts position in 3x5 order

Your code was nearly complete. I believed ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
386 views
0 votes
1 answer

Excel Debt Payoff Calculator

You can change the formula in the ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
293 views
0 votes
1 answer

How to represent the data of an excel file into a directed graph?

The pandas and networkx packages in Python ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,720 points
1,520 views
0 votes
1 answer

How to split columns into two sub columns under their parent column using python in excel

Use str.split: df[['pre', 'post']] = df['Column A'].str.split(r'\s*-->\s*', expand=True) print(df) # Output ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
1,489 views
0 votes
1 answer

Combing data from multiple workbooks into a single master workbook using power query

PowerQuery would scan the contents of all ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
348 views
0 votes
1 answer

Excel VBA SQL Query on not saved Workbook

What can I do to get the ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
424 views
0 votes
1 answer

Excel: importing data from another Excel file using VBA

Refer to the file variables folderName and ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
529 views
0 votes
1 answer

MS Excel Reordering letters in cell

Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
334 views
0 votes
1 answer

VBA - Split table rows based on a column value

Create Type-Specific Worksheets in Excel using VBA Description This ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
901 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
387 views
0 votes
1 answer

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
198 views
0 votes
1 answer

Conditional Formatting not applying to all the cells in a given range

Use the following instead as the Formula: =$P5=75% I ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
444 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
556 views
0 votes
1 answer

Create dropdown list in excel that displays different values from the same lookup table

Looks like the Worksheet_Change() sub needs two ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
395 views
0 votes
1 answer

Python: Converting Datetime into an integer

Try this: import datetime current_date = datetime.datetime.now() print("String Format of ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
953 views
0 votes
1 answer

Count Function for identifying the Unique values in Excel

If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
406 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

For Excel 2019 and above use TEXTJOIN ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
367 views
0 votes
1 answer

Python - Generate PDF from created Excel workbook - cannot save pdf document

The problem is that temp.xlsx doesn't shut ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
672 views
0 votes
1 answer

Plot multiple datasets on the same chart with VBA

Try this: Sub PlotData() Dim ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
509 views
0 votes
1 answer

Comparing worksheets from a directory of xlsx files

Here is a refactored version of your ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
416 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,720 points
259 views
0 votes
1 answer

How to read a dataframe from an excel sheet containing multiple tables?

Here is one option with scikit-image (highly inspired by ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
2,354 views
0 votes
1 answer

Error: AttributeError: 'str' object has no attribute 'row'

You're attempting to extract the row value ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
2,408 views
0 votes
1 answer

Validation of postcodes in several countries

When a value is made up entirely ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
297 views
0 votes
1 answer
0 votes
1 answer

Conditional formatting based on value with offset

Apart than the altered cell, Conditional Formatting ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
459 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
411 views
0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Pivot Tables are mainly designed to create aggregated data from ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
320 views
0 votes
1 answer

VBA Check to see if file is open before reopening a second file

You could replace the line: Set pre = ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
620 views
0 votes
1 answer

Check if cell found is in column "AP"

Find the Last Cell in the Row ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
574 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
345 views
0 votes
1 answer

Excel - FIND function (case-sensitive) ignores case?

Just to show the behaviour of find(): READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
435 views
0 votes
1 answer

Create dependable dropdown of unique items in vba

Try this: Sub UniqueList() Dim ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
508 views
0 votes
1 answer

Field Wrong Calculations

You can accomplish your goals in one ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
479 views
0 votes
1 answer

Export Attachment from outlook to excel cells

You will need to save the attachment ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
376 views
0 votes
1 answer

Choosing a random text value from a list

Try this: =CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1, ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
233 views
0 votes
1 answer

How to get subscript into formulas text string

Convert Digits To Subscript (H₂SO₄) Excel Formula Improvement ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
430 views
0 votes
1 answer

User form to print an array of sheets

It appears that when a UserForm is ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
243 views
0 votes
1 answer

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Replace Occurrences of a Substring With a ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,720 points
312 views
0 votes
1 answer

File module issues with excel format

The xlsx extensions are not supported by ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
432 views
0 votes
1 answer

Copying an existing row which also copies the checkbox with its code

You can make a new checkbox object ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
500 views