Trending questions in Edureka Community

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,308 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,950 views
0 votes
0 answers

Unable to negotiate with 40.74.28.9 port 22: no matching host key type found. Their offer: ssh-rsa

When using git within Azure DevOps repositories ...READ MORE

Dec 13, 2022 in Git & GitHub by Edureka
 • 12,730 points • 2,975 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,300 views
0 votes
1 answer

Trying to run different macros based on value of cell in a range

This demonstrates one approach to loop through ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,339 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 • 397 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,031 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,331 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 • 838 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

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

Open SAP from Excel VBA

It just means that there is no ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 6,138 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,788 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,098 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,400 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 • 1,914 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,395 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 • 873 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 • 831 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 • 1,991 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,727 views
0 votes
1 answer

white screen on simulator iphone Xcode

After creating the request, you must actually ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 6,522 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,294 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,164 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 • 357 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,595 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,205 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,380 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,523 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,108 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,740 views
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,384 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,700 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,837 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,138 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,277 views
0 votes
0 answers

May I know who is my trainer for the upcoming batch?

Request you to let me know who ...READ MORE

Feb 9, 2023 in Others by Priyanka
edited Mar 4, 2025 • 360 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,865 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,419 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,039 views
0 votes
1 answer

Calculate the rank based on the two or Three criteria

=LET(d, A4:C18, ...READ MORE

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

Amplify pull --sandboxId <UUID> results in "Failed to pull sandbox app"

I'm trying to generate the data models ...READ MORE

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

How to consolidate multiple tables in one table using power bi ?

Hi, I have pdf wanted to upload in ...READ MORE

Feb 10, 2023 in Power BI by Amit
edited Mar 4, 2025 • 299 views
0 votes
1 answer

Find the serial number with criteria

Use the filter function: =FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4)) Maybe you have to ...READ MORE

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

Factorial program in android

Hey guys, I am aware that there ...READ MORE

Sep 21, 2022 in Android by Edureka
 • 13,740 points • 6,421 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,225 views
0 votes
1 answer

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

First, look up all ABC_* values in ...READ MORE

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