Trending questions in Edureka Community

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 • 2,295 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 • 2,289 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,680 views
0 votes
0 answers

Merge rows based on value (pandas to excel - xlsxwriter)

I'm attempting to use xlsxwriter to output ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 5,086 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 • 3,013 views
0 votes
0 answers

how to list GCP Project in subfolders

Hi, I want to list all GCP projects ...READ MORE

Feb 15, 2023 in GCP by MGX
edited Mar 4, 2025 • 585 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 • 1,100 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,665 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,998 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 • 2,167 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,929 views
0 votes
1 answer

Iterate thru specific controls in a form using a loop

The textbox numbers you want to iterate ...READ MORE

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

TypeError: Router.use() requires middleware function but got a Object

There were some changes made in the ...READ MORE

May 12, 2022 in Java-Script by Kichu
 • 19,040 points • 9,998 views
0 votes
1 answer

Is it possible to run .APK/Android apps on iPad/iPhone devices?

It is not possible to run Android ...READ MORE

Sep 20, 2022 in IOS by Aditya
 • 7,680 points • 6,888 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,548 views
0 votes
1 answer

How can I only detect click event on pseudo-element?

There is a solution. Have you considered ...READ MORE

Dec 15, 2021 in Java-Script by Wave
edited Mar 5, 2025 • 28,278 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,499 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,456 views
0 votes
1 answer

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

Oct 16, 2022 in Others by narikkadan
 • 86,360 points • 5,777 views
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 86,360 points • 6,071 views
0 votes
1 answer

How to print SQL statement in codeigniter model

To display the query string: print_r($this->db->last_query()); ...READ MORE

Sep 17, 2022 in Database by narikkadan
 • 86,360 points • 7,040 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,790 points • 6,853 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,518 views
0 votes
1 answer

Is it possible to see more than 65536 rows in Excel 2007?

Here is an interesting blog entry about the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,395 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,343 views
0 votes
0 answers

my access to my course has been taken.

My access to my course has been ...READ MORE

Feb 13, 2023 in DevOps & Agile by Oumar
edited Mar 4, 2025 • 570 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,450 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,449 views
0 votes
1 answer

Error in the angular compiler requires typescript >=3.4.0 and <3.6.0 but 3.9.10 was found instead

Run this script to find exact version npm ...READ MORE

Aug 3, 2022 in TypeSript by Abhinaya
 • 1,160 points • 8,936 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 • 1,634 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 4,479 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 • 2,625 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 • 1,182 views
0 votes
0 answers

I Want To Print 1 to 100 Numbers Using Arrays In Javascript Only

<!DOCTYPE html> <html> <head> <title>100-Numbers</title> </head> <body> ...READ MORE

Nov 16, 2022 in Java-Script by Ashwini
 • 5,440 points • 4,134 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 • 600 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 • 3,030 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,555 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,374 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,978 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 • 1,096 views
0 votes
1 answer

What is the difference between list and vector in R?

The difference are - A list holds different ...READ MORE

Oct 29, 2019 in Data Analytics by Cherukuri
 • 33,050 points • 52,759 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 • 637 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,491 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

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

Typescript: Debug Failure. False expression: Non-string value passed to `ts.resolveTypeReferenceDirective`

The same as a couple of days ...READ MORE

Aug 3, 2022 in TypeSript by Abhinaya
 • 1,160 points • 8,895 views
0 votes
1 answer

How to open a Bootstrap 4 modal dialog using jQuery

Use the modal('show') Method You can simply use ...READ MORE

Jun 28, 2022 in JQuery by rajatha
 • 7,680 points • 10,865 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,570 views
0 votes
1 answer

Ms-access vba - read from excel and also update that excel

Here is the code that works without ...READ MORE

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

Use python to remove blank cells from column and shift populated cells up

Use pandas to import and modify your excel. import pandas ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,529 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.