Trending questions in Edureka Community

0 votes
1 answer

How to do multiple transpose in excel vba

Use Dictionary object Sub test2() With New ...READ MORE

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

how to use json file in html code?

<html> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"> </script> <script> ...READ MORE

Aug 8, 2022 in HTML by Vikas
 • 8,496 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

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

VBA Insert row instead of copy

Try this: Option Explicit ' declare all variables Sub ...READ MORE

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

Can an Excel xll function indicate that the return value should be displayed as a date and not a number?

To my knowledge, the only method to ...READ MORE

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

Extracting info from hyperlink

This will offer you an example of ...READ MORE

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

How to extract text before the last "," in excel formula?

Using FILTERXML() • Formula used in cell B1 =FILTERXML("<m><b>"&SUBSTITUTE(A1,", ","</b><b>")&"</b></m>","//b[last()-1]") You can ...READ MORE

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

Get the query string value and display it in my html page

I can see the query string values ...READ MORE

Jul 21, 2022 in HTML by Ashwini
 • 5,430 points • 2,309 views
0 votes
0 answers

import .cert file to azure keyvault issues

I added a.cert certificate to Azure DevOps ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 540 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 • 739 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE

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

PMT function in Javascript

Try the following settings to better understand ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 2,941 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 • 332 views
0 votes
0 answers

Is there a way to import multiple repos at once from github into azure devops?

I would like to transfer a github&nbs ...READ MORE

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

Using createobject("Excel.application") to create excel 2007 application

Try the next adapted way. No need ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,595 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,485 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,140 views
0 votes
0 answers

Unable to build the ASP.Net Core 7 in azure devops pipeline (CI)

ASP.Net Core 7 cannot be built in&nbs ...READ MORE

Dec 19, 2022 in DevOps on Cloud by Damonlang
 • 1,230 points • 1,845 views
0 votes
1 answer

Excel VBA move pivot item to last position

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

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

Get inserted image to adjust the row height in Excel

Try this: 'just find Photo1 cell and select ...READ MORE

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

VBA How To Paste With Blank One Column Over?

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

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

EXCEL: Auto number rows until value in cell

You can utilize SEQUENCE if you have ...READ MORE

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

Unprotect an Excel file programmatically

Try this. It worked for me.  def Remove_password_xlsx(filename, ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 86,360 points • 2,994 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 • 355 views
0 votes
1 answer

VBA to protect and unprotect in given range in sheet

It needs a minor tweak to become ...READ MORE

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 3,716 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 • 304 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

It should work if you simply supply ...READ MORE

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

Python Math - TypeError: 'NoneType' object is not subscriptable

“TypeError: 'NoneType' object is not subscriptable” is ...READ MORE

Jan 4, 2023 in Python by Elton
 • 400 points • 1,926 views
0 votes
1 answer

CSS border less than 1px

The minimum width that your screen can ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,730 points • 10,217 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 • 783 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,229 views
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,090 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 • 323 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 • 2,560 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,381 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 • 782 views
0 votes
1 answer

xlsx package:Write excel file to a custom path

The issue is that when you send ...READ MORE

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

How do I get it to select a single row based on the value?

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

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

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

VLOOKUP will work: vlookup =VLOOKUP(G2,$A$2:$D$11,3,FALS ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,068 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,068 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,150 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 • 934 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,196 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 • 333 views
–1 vote
1 answer

Error response from daemon: This node is not a swarm manager. Use "docker swarm init" or "docker swarm join" to connect this node to swarm and try again.

docker swarm init --advertise-addr  192.168.99.1 READ MORE

Jun 3, 2022 in Docker by anonymous
edited Mar 5, 2025 • 25,295 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,704 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,532 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 4,987 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,857 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,480 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.