Latest questions in Others

0 votes
0 answers

how to do hacking course?

Mar 1 in Others by Priyanka
• 700 points
268 views
0 votes
0 answers

what is computer security system?

Mar 1 in Others by Priyanka
• 700 points
257 views
0 votes
0 answers

What is automation in computer?

What is automation in computer? READ MORE

Feb 2 in Others by Hoor
• 540 points
370 views
0 votes
0 answers

How to automate data entry in excel?

How to automate data entry in excel? READ MORE

Feb 2 in Others by Hoor
• 540 points
332 views
0 votes
1 answer

What is CloudWatch in AWS?

Amazon CloudWatch is a monitoring tool provided ...READ MORE

Jan 22 in Others by Preetha
437 views
0 votes
0 answers

what is library automation ?

Jan 5 in Others by Evanjalin
• 360 points
170 views
0 votes
0 answers

what is automation engineering ?

Dec 6, 2023 in Others by Evanjalin
• 360 points
177 views
0 votes
0 answers

pure component in react

What is a pure component in React ...READ MORE

Nov 6, 2023 in Others by Arya
• 990 points
309 views
0 votes
0 answers

what is react native ?

what is react native ? READ MORE

Oct 13, 2023 in Others by Avinash
• 520 points
432 views
0 votes
0 answers

how to get pmp certification

I have been managing projects for 3+ ...READ MORE

Sep 22, 2023 in Others by Rahul
• 240 points
413 views
0 votes
0 answers

What is the shortcut key to delete sheet in Excel?

Could someone tell me what is the ...READ MORE

Sep 8, 2023 in Others by Satyawrat
• 460 points
297 views
0 votes
0 answers

What is the extension of MS Excel?

Could someone tell me what is the ...READ MORE

Sep 8, 2023 in Others by Satyawrat
• 460 points
292 views
0 votes
0 answers

Shortcut to insert row in excel

What is the Excel shortcut for inserting ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
279 views
0 votes
0 answers

How to remove formula in excel shortcut

What is the Excel shortcut key for ...READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
254 views
0 votes
0 answers

What is function in MS Excel?

What is function in MS Excel? READ MORE

Sep 7, 2023 in Others by anonymous
• 990 points
258 views
0 votes
0 answers

Require a dropdown list based on input that matches Column header

The input should be one of the ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
533 views
0 votes
0 answers

List files in specified directory without subdirectories

How can I only go through files ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
563 views
0 votes
0 answers

How do I use text as reference in EXCEL

How can I reference one text-based cell ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
668 views
0 votes
0 answers

Copying values from multiple excel files to a single one with python

I want to replicate the values from ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
867 views
0 votes
0 answers

VLOOKUP with date range does not work as intended

I have two excel tables in separate ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
549 views
0 votes
0 answers

ExcelDataReader, can't read "html-format" file

I have the following code: ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,020 points
640 views
0 votes
0 answers

How to save Excel sheets to PDF using Python

I have a multiple-sheet Excel spreadsheet. I ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,020 points
5,867 views
0 votes
0 answers

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,020 points
342 views
0 votes
0 answers

Why does Excel give me a #NAME? error when I open this CSV file?

The CSV file consists of two lines: ...READ MORE

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

Two different fonts in one cell using excel vba

Public Sub add_degree_symbol() ActiveCell.Value = ...READ MORE

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

Find specific term in a text string and return that term in the previous column

Try: You can either hard code the ...READ MORE

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

Error Trying to Display The Names of All Excel Data Models in a Workbook

It is necessary to list ThisWorkbook.model. Not ...READ MORE

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

Trying to import a CSV file and convert it into a table using VBA

You cannot convert a range that contains ...READ MORE

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

Use AutoFilter on the current visible data

Use the following modified code. It's assumed ...READ MORE

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

How to run Macro when press enter automatically and paste in different cell

A Worksheet Change: Keep Record of Each ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,020 points
694 views
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,020 points
396 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,020 points
400 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,020 points
412 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
612 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
2,130 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
418 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
526 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,429 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
360 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
509 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
389 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,831 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,020 points
1,792 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,020 points
478 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,020 points
535 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,020 points
631 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,020 points
408 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,020 points
1,127 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,020 points
462 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,020 points
317 views