Latest questions in Edureka Community

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,420 points • 304 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,420 points • 528 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,420 points • 405 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,420 points • 322 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,420 points • 204 views
0 votes
1 answer

How to find TableRow in a flutter test?

Based on the code you provided, it ...READ MORE

Apr 4, 2023 in Flutter by pooja
 • 537 views
0 votes
1 answer

How to scan for bluetooth printers and print pdf or image via bluetooth in flutter?

The user wants to scan for Bluetooth ...READ MORE

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

flutter firebase: showing data

It seems that when using different emulators ...READ MORE

Apr 4, 2023 in Flutter by vishalini
 • 553 views
+1 vote
2 answers

flutter_background_service for iOS

If you're problem is solved then please ...READ MORE

Aug 18, 2023 in Flutter by Sneh
 • 150 points • 5,004 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 • 1,970 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,091 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 • 240 views
0 votes
1 answer

Is there a way to have a Excel file attached to Visual C# project without the need of always having the correct directory location?

You can add the file to your ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,010 points • 596 views
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 • 375 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 • 326 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 • 248 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 • 495 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 • 482 views
0 votes
1 answer

Flutter App launch doesn't work in VS Code

It seems that the error message is ...READ MORE

Apr 3, 2023 in Flutter by Tej
 • 5,671 views
0 votes
1 answer

Execution failed for task ':app:processDebugResources'. on flutterlocalnotification

The error message suggests that there is ...READ MORE

Apr 3, 2023 in Flutter by vinayak
 • 5,027 views
0 votes
1 answer

How to get barcode from PDA scanner device in flutter

It's possible that the data sent by ...READ MORE

Apr 3, 2023 in Flutter by seena
 • 1,207 views
0 votes
1 answer

Widget Stack not showing top levels

Based on the code you provided, it ...READ MORE

Apr 3, 2023 in Flutter by Nidhi
 • 733 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,420 points • 300 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,420 points • 324 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,420 points • 408 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,420 points • 396 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,420 points • 316 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,420 points • 172 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,420 points • 363 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,420 points • 203 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,420 points • 229 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 • 347 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 • 426 views
0 votes
1 answer

How to format calculated land size in excel

To get hectare (F2): =A2+QUOTIENT(B2*100+C2,10000) or =QUOTIENT(A2*10000+B2*100+C2,10000) To get are (G2): =QUOTIENT(MOD(B2*100+C2,10000),100) To ...READ MORE

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

Type the max number title in Excel

If you have duplicates and want to ...READ MORE

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

Excel If Statement with Wildcards and Value Search

Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE

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

How to pass a JSON-formatted string from Excel VBA as argument to a MySQL Store Procedure

Set the parameter length to the json ...READ MORE

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

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

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

Modify table data in excel sheet by userform

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

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

Vba range object single column autofill

Just refer to the first column of rng. ...READ MORE

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

Conditional formatting on a calculation in excel

In E5, you could use =IF(COUNTBLANK(E3:E4)=0,E3-E4,"") which would ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 501 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 420 views
0 votes
1 answer

How Do I Correct a ByRef Mismatch Error in VBA for Worksheet_Change Sub in Excel?

Len of a string returns what you need. ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 1,219 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Use COUNTIF and an array if all ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 658 views
0 votes
1 answer

Processing in vba

Try this: Option Explicit Sub Macro2() ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 237 views
0 votes
1 answer

VBA - Insert Spilt Cell Value

Your desired outcome will not be produced ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 256 views
0 votes
1 answer

Loops through Check Box in VBA

Please attempt the next option. Assuming you ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 578 views
0 votes
1 answer

Global Collections

To store your public objects and expose ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 325 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 63,420 points • 202 views
0 votes
1 answer

How to convert json data into array in Flutter?

To convert the JSON data into an ...READ MORE

Mar 31, 2023 in Flutter by seena
 • 9,429 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.