Trending questions in Edureka Community

0 votes
1 answer

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

By making a new measure that didn't ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,431 views
0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,042 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 2,722 views
0 votes
1 answer

Excel Get different permutation combination of the values

This work can be completed utilising dynamic ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 86,360 points • 1,468 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,329 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 86,360 points • 6,599 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 888 views
0 votes
1 answer

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 1,099 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 6,674 views
0 votes
1 answer

Prevent a user from adding or removing row(s) of a Range, but allow him to do so on another Range on the same sheet

The only thing I can offer is ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 1,097 views
0 votes
0 answers

Best way to keep Azure Postgres in sync with Azure SQL

For the use of pretty much everything, ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,415 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 1,735 views
0 votes
0 answers

How to open WhatsApp using an Intent in your Android App?

I want an Intent to take control ...READ MORE

Nov 23, 2022 in Android by Ashwini
 • 5,430 points • 4,990 views
0 votes
0 answers

What is the role of Advanced SME in Azure Synapse Analytics?

I watched a training video for Azure ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,391 views
0 votes
1 answer

java.lang.ClassNotFoundException: org.springframework.web.servlet.DispatcherServlet

The "Maven Dependency" must be included to ...READ MORE

Sep 20, 2022 in Java-Script by Abhinaya
 • 1,160 points • 7,722 views
0 votes
1 answer

Tableau For Loop a String

In the case of [ { ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,113 views
0 votes
1 answer

Why my new server shows numbers in the URL address?

It looks like the URLs for your ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 1,246 views
0 votes
1 answer

Excel - count if multiple words are in a cell

Try this using wildcards * with TEXTBEFORE()&nb ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,103 views
0 votes
1 answer

Name not recognized error in List.Generate

Try this: let Source = < >, columnsToExpand ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,277 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 1,662 views
0 votes
1 answer

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 2,438 views
0 votes
1 answer

Fixed position but relative to container

The issue with "fixed" positioning is that ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,730 points • 11,309 views
0 votes
1 answer

How to get all Stock list company name and symbol of NSE and BSE with free API?

Check the below link for your answer: http://www.barchartondemand. ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 5,371 views
0 votes
0 answers

Azure Data Engineer Associate certificate - preparation, Microsoft learn platform

Has anyone tried using Microsoft's online training ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,360 views
0 votes
0 answers

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 1,349 views
0 votes
1 answer

Does GCP free trial credit continue if I just upgraded my billing account?

An earlier response is incorrect. Users will ...READ MORE

Nov 10, 2022 in GCP by Ashwini
 • 5,430 points
edited Sep 6, 2023 by Khan Sarfaraz • 5,454 views
0 votes
0 answers

Is Azure DevOps going away?

Could someone tell me whether Azure DevOps ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
 • 12,730 points • 1,268 views
0 votes
0 answers

Function for factorial in Python

How can I compute an integer's factorial ...READ MORE

Feb 15, 2023 in Python by Arya
 • 990 points • 1,236 views
0 votes
3 answers

How to replace negative numbers in Pandas Data Frame by zero?

 If all your columns are numeric, you ...READ MORE

Dec 16, 2020 in Python by Rajiv
 • 8,870 points • 46,715 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 7,990 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

The following should function if you actually ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,440 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Print Copies of Single Worksheet With Increment Option ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 2,299 views
0 votes
2 answers

Sigma code look like this but it’s not working.

ok so u need add a sigma ...READ MORE

Mar 20, 2025 in Python by anonymous
 • 2,435 views
0 votes
0 answers

ErrorDocument 404 /404.php is not working in .htaccess file in PHP

This is the Content of my .htaccess file is: ErrorDocument ...READ MORE

Jun 21, 2022 in PHP by narikkadan
 • 86,360 points • 1,473 views
0 votes
1 answer

Automatically fill cell with a set value on specific calendar day and time

 Use this formula: =IF(NOW()>DATE(2023,3,1)+TIME(8,0, ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 1,120 views
0 votes
0 answers

What is Artifacts in Azure DevOps?

Could someone tell me what are Artifacts ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
 • 12,730 points • 1,223 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Try entering this code in Powerquery's input ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 1,166 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

You can't, in my opinion. When you ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 1,588 views
0 votes
1 answer

Count duplicate words within string and remove if it occurs less than 10 times

Without some sample data, it's challenging to ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 86,360 points • 975 views
0 votes
0 answers

Declaring a resource that is not recognized

Hello All, I am new to Terraform and ...READ MORE

Mar 8, 2023 in AWS by Brandon
edited Mar 5, 2025 • 359 views
0 votes
1 answer

Allow alpha numeric values instead of isnumeric

Here's a small Function you could add to your ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 86,360 points • 1,097 views
0 votes
1 answer

SQL WHERE ID IN (id1, id2, ..., idn)

Option 1 is the only good solution. Why? Option ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 86,360 points • 7,977 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 1,977 views
0 votes
1 answer

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 86,360 points • 1,290 views
0 votes
1 answer

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 1,895 views
0 votes
1 answer

Concatenate only upper case letters?

In ms365, try: The formula in B1‡: =CONCAT(TEXTSPLIT(A1,TEXTSPLIT(A1,CHAR(ROW(65:90)),,1))) ‡ If not a ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,156 views
0 votes
1 answer

How to build a Python project for a specific version of Python?

To build a Python project for a ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 1,115 views
0 votes
1 answer

How to set a column as a range variable as long as there is data in it?

Try this: Dim rng As Range Set rng = ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,152 views
0 votes
1 answer

Fill a FileDialog from another macro

Add an optional parameter to UpgradeEngine - something like: Sub ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 977 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 3,830 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.