Trending questions in Edureka Community

0 votes
1 answer

Trying to make my VBA run a little bit faster

Using Variables In regards to efficiency, that's about ...READ MORE

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

dfd ffgfh zfggh zfxgfdgh zfgfgh zdfgh zdfg

dfd ffgfh zfggh zfxgfdgh zfgfgh zdfgh zdfgdfd ...READ MORE

Jan 20, 2023 in Azure by Rasel
 • 100 points
edited Mar 4, 2025 • 814 views
0 votes
1 answer

Rails - Export records to downloadable excel file using axlsx gem (Keep MVC)

Use  axlsx_rails Gem with the template. In my case, ...READ MORE

Nov 19, 2022 in Others by narikkadan
 • 86,360 points • 3,484 views
0 votes
0 answers

Which SDLC model is the best?

Which SDLC model is the best? READ MORE

Jan 17, 2023 in Software Testing by Hie
edited Mar 4, 2025 • 951 views
0 votes
1 answer

Excel Count if with index match

Try this: Countif(Index(rangeoflookupvalues,,match(Columnvaluetobe ...READ MORE

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

How to use aws ec2 create-tags (from aws cli) to give different values to the same tag across multiple resources?

Suppose I have a list of instance ...READ MORE

Dec 15, 2022 in AWS by Tejashwini
 • 5,380 points • 2,365 views
0 votes
1 answer

How to convert excel to PDF using Python

Specify your whole output path instead of ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 3,864 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, 2025 • 416 views
0 votes
1 answer

Excel Power Query Group by

Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE

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

Excel Conditional Formating to find numbers a cell with text

Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 1,212 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 • 4,195 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

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

Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 5,634 views
0 votes
0 answers

Most relevant learnings to radio communications speciality

I come from the military communication field ...READ MORE

Jan 21, 2023 in Career Counselling by anonymous
edited Mar 4, 2025 • 741 views
0 votes
1 answer

Excel how to find the default file extension

Make a dict of xlfileformats:extensions and use ...READ MORE

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

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

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

the best IT speciality for a 40 years old discharged military officer to learn

My career in the armed comes to ...READ MORE

Jan 21, 2023 in Ask us Anything! by anonymous
edited Mar 4, 2025 • 732 views
0 votes
0 answers

how to connect ELK to Oracle DB using JDBC input plugin

How do I connect to ORACLE DB an ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 1,428 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 • 27,400 views
0 votes
1 answer

Excel Online Script for Message Boxes

Use "throw" followed by your text to ...READ MORE

Nov 7, 2022 in Others by narikkadan
 • 86,360 points • 3,946 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 3,688 views
0 votes
0 answers

Object cannot be cast from DBNull to other types

I am getting this error and I am ...READ MORE

May 14, 2022 in Others by Kichu
 • 19,040 points • 3,193 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

Oct 15, 2018 in Power BI by Hannah
 • 18,520 points • 35,458 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

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

the cloud platform which are not used for devops implementation?

Among which if the following cloud providers ...READ MORE

Dec 22, 2022 in DevOps on Cloud by Edureka
 • 13,740 points • 1,999 views
0 votes
2 answers

Render HTML in React Native

React Native does not provide any specific ...READ MORE

Apr 1, 2023 in HTML by DSKView
 • 180 points • 2,762 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

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

Call Kotlin suspend function in Java class

Assume we have the following function: suspend fun doSomething(): ...READ MORE

Nov 18, 2022 in Kotlin by Tejashwini
 • 5,380 points • 3,293 views
0 votes
1 answer

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

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

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

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

Get the name of a dynamo table created with AWS CDK

Using the example from here. I can create ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
 • 5,380 points • 1,398 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,040 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 • 51,910 views
0 votes
1 answer

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Excel will automatically make assumptions about the ...READ MORE

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

Is there a way to search the iOS app store online?

Apple finally made it possible to just use ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 5,902 views
0 votes
0 answers

What is "main" branch in context of Azure DevOps pipeline caching?

I'm attempting to employ the Azure DevOps ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 1,445 views
0 votes
1 answer

How do I install Java on Mac OSX allowing version switching?

With Homebrew and Jenv: Assumption: You have a ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
 • 220 points • 1,428 views
0 votes
1 answer

How do I transpose a column to a matrix in Excel?

With data in column A, pick some cells ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 86,360 points • 3,111 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

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

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

Feb 16, 2022 in Others by Edureka
 • 13,690 points • 15,276 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,430 points • 3,247 views
0 votes
0 answers

Azure devops pipeline variable for a task step name

Is a variable available for the name of an Azure devops pipeline task step, as highlighted below? image from the pipeline I went over the predefined variables at https://learn.microsoft.com/en-us/azure/devops/pipelines/build/variables?view=azure-devops&tabs=classic  However, ...READ MORE

Jan 5, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 1,354 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 • 5,133 views
0 votes
0 answers

Referencing an element while using count in terraform resource and handling the case when count is 0

I have an AWS WAFv2 Web ACL ...READ MORE

Dec 20, 2022 in AWS by Tejashwini
 • 5,380 points • 2,038 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

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

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

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

Logon failed, use ctrl+c to cancel basic credential prompt to Git in Azure DevOps

When I clone a git repository from Azure Repos into my local system, the clone succeeds, however I receive the following message: Logon failed, use ctrl+c to cancel basic ...READ MORE

Dec 15, 2022 in DevOps on Cloud by Nicholas
 • 7,760 points • 2,262 views
0 votes
1 answer

Adding column to Excel using Apache POI

The quickest way to add a column ...READ MORE

Nov 19, 2022 in Others by narikkadan
 • 86,360 points • 3,344 views
0 votes
1 answer

ExcelJS wrapText in Table columns

I implemented a workaround by detecting what ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 5,519 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,699 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.