Trending questions in Edureka Community

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,600 points • 510 views
0 votes
1 answer

How do I adjust the size of the pasted image in Outlook email?

Try this : Option Explicit '~~> Since we are ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,600 points • 1,521 views
0 votes
1 answer

How to turn a number recognized as string to number

Try this: =VALUE(SUBSTITUTE(A1," ", "")) Or select cells with ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,600 points • 586 views
0 votes
1 answer

A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,600 points • 585 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,000 points • 452 views
0 votes
1 answer

Flutter scrollable positioned list support rtl text direction?

To support RTL text direction in the ...READ MORE

Mar 18, 2023 in Android by vishalini
 • 1,164 views
0 votes
1 answer

List Fridays and Saturdays in excel

 Try this: =TEXT(FILTER(SEQUENCE(DAY(EOMONTH(A4,0)),,EOMONTH( ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 536 views
0 votes
1 answer

Macro VBA code failing to execute a section of the code without an error

You get your code to make a ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 836 views
0 votes
1 answer

Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 660 views
0 votes
1 answer

Extracting tabular data from multiple .xlsx files with inconsistent structures

For a cell that is consistent across ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 787 views
0 votes
1 answer

How to detect value in change in excel using python?

You might keep a txt file with ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 831 views
0 votes
1 answer

Trying to redo my Export Button Function on my document

You could directly publish the data to ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,600 points • 566 views
0 votes
1 answer

How can I dismiss the on screen keyboard?

To dismiss the on-screen keyboard, you can ...READ MORE

Mar 1, 2023 in Android by vishalini
 • 1,791 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,600 points • 385 views
0 votes
1 answer

How to do the comand IF THEN in Excel

Try this: =SUM(IF(AND(H39<=38,H39>=20),1,0),... If so then maybe this is ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 642 views
0 votes
1 answer

Another method to extract the last row containing data in a column

The "used range" might not be accurate. ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 641 views
0 votes
1 answer

Why does this VBA Macro that copies and paste range into email in the wrong order?

When a message body is created by ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 942 views
0 votes
1 answer

VBA & Ascii Art

This is possible with a two-dimensional array. ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 764 views
0 votes
1 answer

iCell.Value takes too long

Please try the following modified code. The ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 634 views
0 votes
1 answer

Processing in vba

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

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

Adjacent excel cells show same cell address on using =cell("address") formula.

Use the reference argument: =CELL("address",L54) From the docs: reference: The cell that you ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 493 views
0 votes
1 answer

Run time error 3343 unrecognized database format

Try using ADODB. Option Explicit Sub Export1line() ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 749 views
0 votes
1 answer

TextEffect to TextFrame Adjustment (Mismatch)

Delete the original shape and then replace, ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 737 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,000 points • 362 views
0 votes
1 answer

Selenium extract data after </strong>

Try this: phone_element = OBJ.find_element_by_xpath("//*[@id='main']/div[1]/div[2]/div[2]/div/div/div/div/div/section/div/div[1]/div[2]/ul/div/div[3]/li/div/div/strong/following-sibling::text()") phone_number = phone_element.strip() Using the ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 581 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
 • 63,600 points • 8,807 views
0 votes
1 answer

Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 704 views
0 votes
1 answer

I am creating mobile application on flutter but facing error of tflite library

The error you're encountering means that there ...READ MORE

Mar 18, 2023 in Android by pooja
 • 1,060 views
0 votes
1 answer

Should we edit answers that suggest OP ask ChatGPT?

Yes, it is generally not helpful to ...READ MORE

Mar 28, 2023 in ChatGPT by anonymous
 • 300 points • 620 views
0 votes
1 answer

VBA how to calculate depth of items in excel, simliar to a BOM system

Add on the sheet an ActiveX Microsoft ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 732 views
0 votes
1 answer

Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!$B$2:$G$18,B2:K2)>0)) so ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,600 points • 599 views
0 votes
1 answer

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

Concatenate If Not Blank Replace the J with I to replace as ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,600 points • 462 views
0 votes
1 answer

Openpyxl password protect excel file python

Workbooks can be secured against certain actions, ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 8,560 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

A VBA Lookup: Lookup Headers in an ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,600 points • 585 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,600 points • 368 views
0 votes
1 answer

Linking 3 Flutter Projects in One Flutter Project

Yes, it is possible to combine multiple ...READ MORE

Mar 20, 2023 in Flutter by vinayak
 • 927 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 834 views
0 votes
1 answer

What is one key purpose of DevOps?

DevOps is a set of practices that ...READ MORE

Mar 23, 2023 in DevOps & Agile by Edureka
 • 13,620 points • 878 views
0 votes
1 answer

Do you use Firebase for your flutter apps?

Firebase is a popular backend-as-a-service (BaaS) platform ...READ MORE

Mar 20, 2023 in DevOps & Agile by Anitha
 • 924 views
0 votes
1 answer

How do I build a loop into this TimeStamp VBA Code?

As Target is a range, it may ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 529 views
0 votes
1 answer

Python: How do I get multiple results in the same excel sheet?

Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 652 views
0 votes
1 answer

Adding a splash screen to Flutter apps

To add a splash screen to your ...READ MORE

Mar 18, 2023 in Android by anonymous
 • 1,106 views
0 votes
1 answer

How to read an Excel CSV file in Python?

The csv module or the pandas library ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 895 views
0 votes
1 answer

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,600 points • 627 views
0 votes
1 answer

Move multiple Azure Devops projects into one project same org

Yes, it is possible to move all ...READ MORE

Mar 23, 2023 in DevOps & Agile by Edureka
 • 13,620 points • 841 views
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Here's how Excel functions. Not a bug, ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 569 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 649 views
0 votes
1 answer

Runtime Error while dynamically adding controls to a userform

You appear to be attempting to execute ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 63,600 points • 511 views
0 votes
1 answer

How can I set a number for a public variable at userforms in excel?

Try: Public b As Integer Private Sub exa_Click() b = ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 547 views
0 votes
1 answer

Extracting a Variable Number of Letters from a Formula using VBA Code

Please, try the next function: Function extractLetter(rng As ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 532 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.