Trending questions in Edureka Community

0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

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

How to make a auto counter to print pages

This will loop through all of those ...READ MORE

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

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

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

Dynamic Subtraction formula in excel sheet

Excel is capable of using both a ...READ MORE

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

Underlining Headers from WPF Datagrid when printing using Excel print function

Try this: worksheet.Cells[1, i] = dgCountyEOY.Columns[i - 1].Header; ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 702 views
0 votes
0 answers

ModuleNotFoundError: No module named 'Crypto'

--------------------------------------------------------------------------- ModuleNotFoundError ...READ MORE

Feb 1, 2023 in Python by Webinar
edited Mar 4 • 148 views
0 votes
1 answer

How to hide rows based on dropdownlist?

No need of any variable (besides Target). Please, ...READ MORE

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

Hi, I really need some help using Django on Pycharm.

Hi, I am a student and my ...READ MORE

Feb 1, 2023 in Others by Pahone
edited Mar 4 • 137 views
0 votes
1 answer

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE

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

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 14,914 views
0 votes
1 answer

VBA Help on Splitting Worksheet

In this bit of code: ws1.Range("a:a").Copy Range("a:a") Intersect(.UsedRange, .Columns(i)).Copy ...READ MORE

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

Crawling through multiple excel files, match and copy data to master file

One application only. It would be quicker ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 980 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Using OJDBC 6, I created some Java ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 7,389 views
0 votes
1 answer

All Levels of a Factor in a Model Matrix in R

Yes, you can modify the model.matrix() function ...READ MORE

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

What does continuous engineering in DevOps consist of?

Continuous engineering is that unseen thread, that ...READ MORE

Jan 4, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5 • 9,678 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 6,207 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 • 1,582 views
0 votes
1 answer

Adding formulas to excel spreadsheet using python

You can create any formula that Excel ...READ MORE

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

How to improve VBA Code for Monte Carlo Simulation?

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

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 1,033 views
+1 vote
1 answer

How to rename Docker images without rebuilding it?

Hi@akhtar, You can rename your docker image by ...READ MORE

May 19, 2020 in Docker by MD
 • 95,460 points • 42,685 views
0 votes
0 answers

Concatenate two layers Tensorflow.js

I am new to TensorflowJS and I ...READ MORE

Jan 31, 2023 in Data Science by Tejashwini
 • 5,380 points
edited Mar 4 • 143 views
0 votes
1 answer

Speed up the loop operation in R

To improve the performance of your code, ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 1,238 views
0 votes
0 answers

i want to use one formula which can fill the row table as per same cell but from different worksheets?

same cell in excel from different worksheets ...READ MORE

Jan 31, 2023 in Others by pramod
edited Mar 4 • 118 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

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

INDEX MATCH formula in Excel returning incorrect results in some cells and correct results in others

Step through the formula that produces the ...READ MORE

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

Moving and organizing Java codes on another files

I would like to create a new ...READ MORE

Jan 31, 2023 in Java by Tejashwini
 • 5,380 points
edited Mar 4 • 128 views
0 votes
1 answer

Paste a value from a drop-down list

Check if there is an existing sheet ...READ MORE

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

Delimiters in Excel VBA Regex Patterns, filter something but not others

Change your code to this: Function RemoveTags(ByVal Value ...READ MORE

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

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

Apr 1, 2022 in Database by gaurav
 • 23,580 points • 13,286 views
0 votes
1 answer

Horizontal Loop

There is no need to use Range if you ...READ MORE

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

Conditions in Excel: skip cells with dates without a year

Both Google Sheets and Excel save dates ...READ MORE

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

CSS calc width and height values

Yes, there are CSS variables named vh ...READ MORE

Aug 4, 2022 in CSS by Tanishqa
 • 1,370 points • 7,855 views
0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

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

Vanilla JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it

Use Internet Explorer 9 or later if you're using VANILLA pure JavaScript without jQuery. document.addEventListener("DOMContentLoaded", function(event) { // ...READ MORE

Nov 8, 2022 in Java by Damonlang
 • 700 points • 3,706 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 86,360 points • 1,887 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 • 7,948 views
0 votes
1 answer

Count the sum of difference between two cells

Use a for loop: Sub AbsoluteDifference() ...READ MORE

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

Which of these tools is not associated with DevOps?

Which of the following tools are not ...READ MORE

Dec 12, 2022 in DevOps Tools by Edureka
 • 12,710 points • 1,703 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

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

Excel COUNTIFS with merged cell

Although it is strongly advised to stay ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,572 views
0 votes
1 answer

Find and adjacent cell with criteria

Using FILTER() & MAXIFS() • Formula used in cell F2 =FILTER($A$2:$D$12,(MAXIFS(D2:D12,B2:B12,2,C2:C12,4)=D2:D12)*(B2:B12=2)*(C2:C12=4)) Another alternative is ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 660 views
0 votes
0 answers

How to convert xml to csv file

The data in xml file is someting ...READ MORE

Jan 29, 2023 in Python by Wu
edited Mar 4 • 151 views
0 votes
1 answer

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

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

Excel formula to convert number to both feet and inches

If you want the answer to be ...READ MORE

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

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 86,360 points • 4,144 views
0 votes
1 answer

Copy formula from Excel to Notepad++

If you go to Formulas card, inside Formulas Auditing section there ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 2,157 views
0 votes
0 answers

Yesterday Used jenkins practiced well, today while opening jenkins getting error

java.io.IOException: Permission denied at java.base/java.io.UnixFileSystem.createFileExclusively(Native Method) at java.base/java.io.File.createTempFile(File.java:2129) at hudson.util.AtomicFileWriter.<init>(AtomicFileWriter.java:143) Caused: ...READ MORE

Jan 25, 2023 in Jenkins by anonymous
edited Mar 4 • 325 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 86,360 points • 1,978 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

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

Consolidate orders to single row counting number of orders and averaging the result

Try this: Sub aveCount() Dim rng As Range Dim cl ...READ MORE

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