Trending questions in Edureka Community

0 votes
1 answer

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE

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

Error: could not find function ... in R

If you encounter an error stating "'some.function' ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 2,622 views
0 votes
1 answer

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

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

How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

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

How to return the last n number of values corresponding to a specific category?

Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 953 views
0 votes
0 answers

edureka certificate

Hi, I have joined in a course in ...READ MORE

Feb 20, 2023 in Python by A
edited Mar 5, 2025 • 333 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

Application.DisplayStatusBar = True Is cancelling your ...READ MORE

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

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 4,864 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

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

what machine learning model is used in chatgpt application?

It's just out of curiosity but which ...READ MORE

Feb 10, 2023 in ChatGPT by erzan
 • 630 points
edited Mar 4, 2025 • 723 views
0 votes
1 answer

WAMP error: Forbidden You don't have permission to access /phpmyadmin/ on this server

Change the file content of c:\wamp\alias\phpmyadmin.conf to ...READ MORE

Feb 23, 2022 in Others by Aditya
 • 7,680 points • 15,895 views
0 votes
1 answer

When a row is added to one sheet, automatically add a row to another sheet

Use the VLOOKUP function. Your Spreadsheet 2's first column will ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,624 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

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

Excel function to dynamically SUM UP data based on matching rows and columns

Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE

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

jQuery - Round to 2 decimal places and calculate with that number

To format a number using fixed-point notation, ...READ MORE

Aug 1, 2022 in Web Development by rajatha
 • 7,680 points • 9,013 views
0 votes
1 answer

Excel - How do I make rows that contain row headers into two columns

You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 1,344 views
0 votes
0 answers

How to implement XRay in NodeJS project?

I need to create XRay to collect ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
 • 5,380 points • 1,455 views
0 votes
1 answer

Turning a .xlsx into multiple PDFs

You just need to adjust the font ...READ MORE

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

Excel links keep crashing

When the links in the master sheet ...READ MORE

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

Update an Excel sheet in real time using Python

Using xlwings, I have really discovered how ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 4,540 views
0 votes
1 answer

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

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

Jan 29, 2023 in Others by narikkadan
 • 86,360 points • 1,206 views
0 votes
0 answers

java.lang.NoClassDefFoundError: org/openqa/selenium/WebDriver

I added all the selenium  jars in ...READ MORE

Feb 10, 2023 in Selenium by anonymous
edited Mar 4, 2025 • 693 views
0 votes
1 answer

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

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

Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

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

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

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

Calendar React JS

I have a homework to make a ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 5,380 points • 1,295 views
0 votes
1 answer

How to convert an XML file to an Excel file?

Create a CSV file that is in ...READ MORE

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

How can I use the Azure DevOps Pipeline with a specific older version of Ruby?

For a project I'm working on, Ruby ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 811 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

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

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

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

Formula to remove every middle name in a cell in Excel

Use this: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1) What does it do? Finds the ...READ MORE

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

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 2,531 views
0 votes
1 answer

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

You can use OLEDB to create and ...READ MORE

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

How to gentrate Unique Id in ReactJs

You can use useId to create a ...READ MORE

Feb 8, 2023 in Others by Damonlang
 • 1,230 points • 968 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 857 views
0 votes
0 answers

How to find cube root using Python?

This is the best way I've found ...READ MORE

Feb 17, 2023 in Python by Arya
 • 990 points
edited Mar 5, 2025 • 360 views
0 votes
0 answers

How to convert list to string [duplicate]

How can I use Python to turn ...READ MORE

Feb 16, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 396 views
0 votes
0 answers

Base language of Python

What is the base language used to ...READ MORE

Feb 16, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 393 views
0 votes
1 answer

How to calculate percentage with a SQL statement

The following has passed my tests, and ...READ MORE

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

How to properly send a GraphQL update request using Axios?

I created an application using AWS Amplify, ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
 • 5,380 points • 1,383 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 920 views
0 votes
0 answers

Sum of odd numbers using while loop in python

I'm new to programming, I was asked ...READ MORE

Feb 16, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 380 views
0 votes
0 answers

"Develop a python program to print square root of every alternate number in the range 1 to 15." What Do You Mean by alternate number?

My most recent computer test had a ...READ MORE

Feb 16, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 373 views
0 votes
1 answer

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

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

How can I use a Linked List in Python?

How can I utilise a linked list ...READ MORE

Feb 17, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 322 views
0 votes
1 answer

How to check if a cell is empty in a range variable?

Use WorksheetFunction.CountA() (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.counta) function If WorksheetFunction.CountA(rng) = 0 Then ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,716 views
0 votes
0 answers

Multiplication or sum of two numbers

Given two integer numbers, return their product ...READ MORE

Feb 17, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 308 views
0 votes
1 answer

Project ID printed for every task on the API problem

Try this: def teste(id): listID = ...READ MORE

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

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 86,360 points • 3,866 views
0 votes
1 answer

Multiple columns of excel only shown as 1 column

Data is separated into CSV (Comma Separated ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 86,360 points • 1,099 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.