Latest questions in Edureka Community

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,010 points • 403 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,010 points • 689 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,010 points • 460 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,010 points • 430 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,010 points • 4,653 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,010 points • 202 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,010 points • 232 views
0 votes
1 answer

flutter web build JS function with external JS library

The code you provided seems to be ...READ MORE

Apr 10, 2023 in Flutter by vinayak
 • 1,523 views
0 votes
1 answer

how to get Firebase sum of txn amount i got error The operator '+' can't be unconditionally invoked because the receiver can be 'null'

The error message "The operator can't be ...READ MORE

Apr 10, 2023 in Flutter by pooja
 • 1,132 views
0 votes
1 answer

flutter app not running on ios simulator after adding firebase notification

The error message you provided seems to ...READ MORE

Apr 10, 2023 in Flutter by vishalini
 • 4,566 views
0 votes
1 answer

How to disable bouncing animation for pageview in flutter

To disable bouncing animation for PageView in ...READ MORE

Apr 10, 2023 in Flutter by Anitha
 • 4,775 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,010 points • 590 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,010 points • 297 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,010 points • 284 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,010 points • 1,369 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,010 points • 272 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,010 points • 486 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,010 points • 220 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 • 226 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 • 231 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,420 points • 427 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,420 points • 1,416 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,420 points • 251 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,420 points • 346 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,420 points • 2,594 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,420 points • 221 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,420 points • 287 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,420 points • 226 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,420 points • 1,210 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,220 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 • 282 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 • 367 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 • 468 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 • 280 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 • 763 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 • 311 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 • 146 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 • 320 views
0 votes
1 answer

How to host an Android Fragment in a Flutter app as a native view, when the context is a MutableContextWrapper and needs to be added to the View class Ask Question

It seems that the issue is caused ...READ MORE

Apr 6, 2023 in Flutter by pooja
 • 1,741 views
0 votes
1 answer

flutter problem with Getx ,socket.io and node.js

Check that you have added the necessary ...READ MORE

Apr 6, 2023 in Flutter by vishalini
 • 508 views
0 votes
1 answer

InputDecoration in DropdownButtonFormField adds a padding on the right (Flutter)

The right padding you are seeing in ...READ MORE

Apr 6, 2023 in Flutter by seena
 • 4,571 views
0 votes
1 answer

How to prevent deprecated flutter widgets suggestions in vs code?

To prevent deprecated Flutter widgets suggestions in ...READ MORE

Apr 6, 2023 in Flutter by vinayak
 • 618 views
0 votes
1 answer

Lock screen audio player notification not appearing when target SDK is 33?

This issue may be related to the ...READ MORE

Apr 6, 2023 in Flutter by vishwa
 • 1,114 views
0 votes
1 answer

How to fix an invalid CFBundleVersion error?

Yes, the error message suggests that the ...READ MORE

Apr 6, 2023 in Flutter by pooja
 • 5,137 views
0 votes
1 answer

Cloud Firestore exception handling

Cloud Firestore throws a variety of exceptions ...READ MORE

Apr 6, 2023 in Flutter by veena
 • 1,425 views
0 votes
1 answer

Flutter: passing optional List argument through go_router?

The error message suggests that you are ...READ MORE

Apr 6, 2023 in Flutter by Anitha
 • 1,341 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,420 points • 446 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,420 points • 331 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,420 points • 782 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,420 points • 299 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.