Trending questions in Edureka Community

0 votes
1 answer

javascript filter array multiple conditions

You can do like this var filter = ...READ MORE

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

Calculating a Rolling IRR in Excel

I'm assuming a little bit here, but ...READ MORE

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

VBA copy data from other file - problem with file name change

To look for the source file, use ...READ MORE

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

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 816 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 • 8,678 views
0 votes
0 answers

SEO friendly url using php

I wanted to use php to make ...READ MORE

Feb 18, 2022 in Others by Kichu
 • 19,040 points • 1,572 views
0 votes
1 answer

How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

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

Python/Openpyxl: change cell A1 in all excel worksheets within a workbook to equal the name of the worksheet tab

You made a mistake when you used ...READ MORE

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

Convert excel file to jpg in c#

You can use Aspose : http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/category1129.aspx For example : http://www.aspose.com/docs/display/cellsnet/Converting+Worksheet+to+Image Sample ...READ MORE

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

Excel formula returning multiple values according to two criterias

Unique Column Cells With Two-Column Duplicates =LET(rCol,F2:F16,uCol1,G2:G16,uCol2,H2:H16, ...READ MORE

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

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Since WorksheetFunction.RTD() method (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.rtd) signature (i.e.: how many parameters it is ...READ MORE

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

How to sum the value of 2 rows with vlookup by only using 1 formula?

 Try in Excel Online: • Formula used in cell C3 =SUM(SCAN(0,M3:N3,LAMBDA(x,y,VLOOKUP(y,P3:Q12,2,0)))) Works ...READ MORE

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

Spill formula to lookup matching row data in one sheet with column data in another and evaluate corresponding cells

Your formula's output will match I2size #'s ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,498 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,997 views
0 votes
1 answer

How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

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

Are there any services like Databricks but without compulsion of AWS/Azure/Google Cloud?

I'm doing a course on Udemy for ...READ MORE

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

Select employee details of dept number 10 or 30

Dept Table:                     DeptNo Dname Loc 10 Accounts Bangalore 20 IT Delhi 30 Production Chennai 40 Sales Hyd 50 Admn London Emp ...READ MORE

Feb 12, 2023 in Database by Nischitha
edited Mar 4, 2025 • 395 views
0 votes
1 answer

Suggestions of excellent examples of real C/C++ code

I'd like to particularly bring up memcached.  ...READ MORE

Dec 17, 2022 in C++ by narikkadan
 • 86,360 points • 2,829 views
0 votes
1 answer

Getting a specific value from a dictionary in a function

You must assign the outcome. I changed your ...READ MORE

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

VBA, Loop through sheets not detecting parameters?

Rewriting to prevent in addition to removing ...READ MORE

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

npm dotenv environment variables not recognized in nodejs module

process.env object that are defined in the ...READ MORE

Jun 10, 2022 in Node-js by Neha
 • 9,020 points • 10,999 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

All you have to do is copy ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 1,348 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,813 views
0 votes
1 answer

Repercute value on other sheet with "auto-detect"

Try in K9: =INDEX(IFNA(VLOOKUP(C9:C; Sheet2!B:H; 7; 0))) READ MORE

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

How to define a circle shape in an Android XML drawable file?

I'm having some trouble locating the Android ...READ MORE

Nov 22, 2022 in Android by Edureka
 • 12,730 points • 3,840 views
0 votes
1 answer

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 5,401 views
0 votes
5 answers

Moving mouse pointer to a specific location or element using C# and Selenium

n order to perform a 'mouse hover' ...READ MORE

Dec 16, 2020 in Selenium by Gitika
 • 65,730 points • 53,741 views
0 votes
1 answer

Macro that deletes all asterisk signs from cells

Try this: Sub RemoveNonNumeric() Dim ...READ MORE

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

How to list projects inside the folders in folders in GCP

How can we list the GCP projects ...READ MORE

Feb 10, 2023 in GCP by MGX
edited Mar 4, 2025 • 426 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, 2025 • 864 views
0 votes
1 answer

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

The filtering criteria applied to a column ...READ MORE

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

Vlookup error when lookup value cell has been populated with formula

Your formula returns 4 characters. =LEFT(M8,FIND(" ",M8)-1) will return ...READ MORE

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

How can a column be set to display multiple spaces and tabs (white space) in a cell?

By entering your "code" in Word and ...READ MORE

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

How to solve IndentationError

 for intent in intents['intents']:         ...READ MORE

Feb 11, 2023 in Python by anonymous
edited Mar 4, 2025 • 359 views
0 votes
1 answer

VBA Loop To Import Changing File Names

You can use a FOR loop and ...READ MORE

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

iOS: Random black screen when loading the app

force restarting your iPhone You can always start ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 6,509 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,909 views
0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

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

Given a column of int64, make a REST call for each value, return results to a single table

Create a query like this in PowerQuery ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 1,251 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,903 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,934 views
0 votes
0 answers

VBA Excel MID Function Array

In order to calculate a UPC Check ...READ MORE

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,112 views
0 votes
0 answers

The AWS Access Key Id you provided does not exist in our records

I am getting invalid aws access key ...READ MORE

Dec 22, 2022 in AWS by Tejashwini
 • 5,380 points • 2,563 views
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,623 views
0 votes
1 answer

Comparing data in Excel

A quick and mildly dirty VBA approach. ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 86,360 points • 1,279 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 • 2,009 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,730 points
edited Mar 5, 2025 • 10,329 views
0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Try this: Sub IFSomething() With ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,143 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 • 1,315 views
0 votes
0 answers

Not all parameters are used

def update_data(self):         if self.var_dep.get()=='Select Department' or self.var_std_name.get()=='' or ...READ MORE

Feb 10, 2023 in Python by Aryazayo
edited Mar 4, 2025 • 376 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.