Trending questions in Edureka Community

0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,680 points
1,150 views
0 votes
0 answers

What is Artifacts in Azure DevOps?

Could someone tell me what are Artifacts ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,690 points
610 views
0 votes
1 answer

Converting excel to pdf using PHP

If utilizing PHP on a Windows PC, ...READ MORE

Oct 23, 2022 in Others by narikkadan
• 63,680 points
5,598 views
0 votes
1 answer

How to use plotly in R shiny

Here's a corrected version of your code: # ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
712 views
0 votes
1 answer

Put text body above the pasted range

Set x before you paste. x = doc.Range.End ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
• 38,020 points
395 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Object Variables in Loops The main issue was ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
869 views
0 votes
1 answer

How can I position my div at the bottom of its container?

Bottom and position properties can be used ...READ MORE

Jun 10, 2022 in CSS by Edureka
• 12,690 points
11,588 views
0 votes
1 answer

ChatGPT is not working

If ChatGPT is not working as expected, ...READ MORE

Feb 7, 2023 in ChatGPT by Elton
• 400 points
919 views
0 votes
1 answer

Sublist on Excel

Try using this formula in sheet 1  =FILTER(Sheet2!B3:B8,Sheet2!E3:E8<2) The ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,680 points
340 views
0 votes
0 answers

PHP file_get_contents() returns "failed to open stream: HTTP request failed!"

I'm having trouble using PHP code to ...READ MORE

Jul 28, 2022 in PHP by Kithuzzz
• 38,020 points
9,364 views
0 votes
0 answers

Android logo as an emoji (symbol) to copy and paste in text form

To use it in text editors, I ...READ MORE

Nov 23, 2022 in Android by Ashwini
• 5,430 points
4,247 views
0 votes
1 answer

R: Generate Random Numbers with "floor" and "runif"

It looks like there's a small issue ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
647 views
0 votes
1 answer

How to solve "Error: Apache shutdown unexpectedly"?

To answer your question, as this port ...READ MORE

Feb 10, 2022 in Others by Rahul
• 9,680 points
16,550 views
0 votes
0 answers

Is Azure DevOps free?

Could someone tell me whether Azure DevOps ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,690 points
562 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Try entering this code in Powerquery's input ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
505 views
0 votes
1 answer

Differences between git pull origin master & git pull origin/master

To answer your question, the git pull ...READ MORE

Feb 11, 2022 in Others by Rahul
• 9,680 points
16,496 views
0 votes
1 answer

Dropdown list circular reference Excel/VBA

Try this: Private Sub Workbook_SheetChange(ByVal Sh As Object, ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,680 points
447 views
0 votes
1 answer

Copying and pasting from one workbook to another doesn't work

Your ranges aren't fully qualified. Excel will make ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,680 points
446 views
0 votes
1 answer

How to build a Python project for a specific version of Python?

To build a Python project for a ...READ MORE

Feb 17, 2023 in AWS by anonymous
492 views
0 votes
1 answer

Excel: Get text between two characters

Try this: =SUBSTITUTE(TEXTAFTER(A1:A4,"/",-1),"'","") Here is the output:  Similarly to get ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
615 views
0 votes
0 answers

Azure Vnet Private IP Ranges

I don't have experience in networking. I'm ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
583 views
0 votes
0 answers

Design for a Cloud Native Application in Azure for ML Insights and Actions

I have a plan to create a ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
581 views
0 votes
1 answer

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

Jan 3, 2023 in Others by narikkadan
• 63,680 points
2,419 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
734 views
0 votes
1 answer

VBA Excel: Write timestamp to cell on change of another cell

Your request is a little vague, and ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,680 points
989 views
0 votes
1 answer

R command for setting working directory to source file location in Rstudio

Yes, you can specify your working directory ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
658 views
0 votes
1 answer

Why the data type in last columns is str instead of float?

Have you attempted to float-ify that column ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,680 points
645 views
0 votes
1 answer

How to deploy Airflow to production being agnostic to Cloud providers?

Yes, deploying Airflow using Docker is a ...READ MORE

Feb 17, 2023 in AWS by anonymous
473 views
0 votes
1 answer

Allow alpha numeric values instead of isnumeric

Here's a small Function you could add to your ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,680 points
423 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

What exactly does W11 contain? In Excel, ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,680 points
1,066 views
+1 vote
1 answer

ng is not recognized as an internal or external command

I solved this problem in accordance with ...READ MORE

Feb 11, 2022 in Others by Rahul
• 9,680 points
16,424 views
0 votes
0 answers

Axios, is it slower to auto catch error responses (such as 404)?

Just out of curiosity, the default setting ...READ MORE

Feb 14, 2023 in AWS by Ashwini
• 5,430 points
614 views
0 votes
1 answer

Calling AWS ELB public DNS from AWS EC2 client. How much do I get charged?

If you are calling an AWS Elastic ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
467 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 63,680 points
2,182 views
0 votes
1 answer

Struggling to move object based on the value to respect sheet

If you are not moving many rows ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
582 views
0 votes
1 answer

Forecast Package from R in Python

Yes, you can use the R forecast ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
588 views
0 votes
0 answers

Azure KeyVault and Authentication on client side

I'd like to know more about the ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
551 views
0 votes
0 answers

What is the difference between Azure DevOps and AWS DevOps?

Could someone perhaps explain how Azure DevOps ...READ MORE

Feb 16, 2023 in DevOps & Agile by Edureka
• 12,690 points
507 views
0 votes
1 answer

Appreciate any suggestion

You could try and add a feature ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
571 views
0 votes
0 answers

What is DevOps cloud engineer?

Could someone please explain what a DevOps ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
• 13,620 points
544 views
0 votes
1 answer

Concatenate only upper case letters?

In ms365, try: The formula in B1‡: =CONCAT(TEXTSPLIT(A1,TEXTSPLIT(A1,CHAR(ROW(65:90)),,1))) ‡ If not a ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,680 points
478 views
0 votes
0 answers

What do CI tools enable DevOps engineers to do?

Can anyone tell me what do CI ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
• 13,620 points
542 views
0 votes
3 answers

How to create multiple charts in one sheet?

Hi, You can place more than one chart ...READ MORE

Jun 7, 2020 in Tableau by anonymous
• 140 points

edited Jun 8, 2020 by Gitika 51,131 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

The following should function if you actually ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
682 views
0 votes
1 answer

VBA How do I replace the range with an array in SUMIF

You can't, in my opinion. When you ...READ MORE

Feb 7, 2023 in Others by narikkadan
• 63,680 points
850 views
0 votes
1 answer

Highlight closest cell value in a table

Conditional formatting will be used to highlight ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,680 points
375 views
0 votes
1 answer

Export from r in excel

Try this: library(xlsx) write.xlsx(x, file, sheetName="Sheet1") READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,680 points
588 views
0 votes
1 answer

sample function in R

It seems like you are experiencing an ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
594 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 63,680 points
878 views
0 votes
0 answers

Testing & Deploy Azure Data Projects

As an Azure developer and data engineer, I enjoy automating cloud deployments and testing.  I'm currently working with a number of Azure resources, including SQL Server, PowerBI, Azure Data Factory, Azure Data Lake Storage, and Azure Data Lake Analytics. Doing some research I've found a bunch ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
532 views