Trending questions in Edureka Community

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,420 points • 780 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 • 706 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
 • 647 views
0 votes
1 answer

Multiplication of all numbers in a cell by a specific number

With ms365, try: The formula in B1: =MAP(A1:A3,LAMBDA(x,TE ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,600 points • 459 views
0 votes
1 answer

How to hide blank rows in an excel form if they are blank

If an empty row should be defined ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 805 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,600 points • 1,147 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,600 points • 589 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,600 points • 975 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,000 points • 496 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 • 631 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,420 points • 809 views
0 votes
1 answer

How to set a column as a range variable as long as there is data in it?

Try this: Dim rng As Range Set rng = ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 665 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
 • 623 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,600 points • 436 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,000 points • 738 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,600 points • 566 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 • 757 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 7,044 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,000 points • 848 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,000 points • 714 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 • 648 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,000 points • 841 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,600 points • 530 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,600 points • 742 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,000 points • 697 views
0 votes
0 answers

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

I'm trying to reverse-engineer an Azure SQL ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 710 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,600 points • 608 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,600 points • 736 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,600 points • 988 views
0 votes
1 answer

Do Until replay tree times

Clean Data: Apply Consistent Formatting in Columns Option ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,600 points • 726 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,420 points • 690 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,600 points • 505 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,600 points • 1,017 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 • 642 views
0 votes
1 answer

Violation Long running JavaScript task took xx ms

These messages are classified as warnings rather ...READ MORE

Nov 15, 2022 in Java by Damonlang
 • 1,230 points • 4,593 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

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

Iterator should return strings, not bytes (the file should be opened in text mode)

You can read the data of the ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 63,600 points • 1,692 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,420 points • 703 views
0 votes
0 answers

What are the requirements to become AWS DevOps Engineer?

Could someone please let me know what ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
 • 13,620 points • 625 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 • 610 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 63,600 points • 1,534 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

Apr 1, 2022 in Database by gaurav
 • 23,260 points • 14,425 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 • 598 views
0 votes
1 answer

Index and Match multiple matches

You can try the following (formula 1) ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 790 views
0 votes
0 answers

What is the role of Advanced SME in Azure Synapse Analytics?

I watched a training video for Azure ...READ MORE

Feb 14, 2023 in Azure by Damonlang
 • 1,230 points • 627 views
0 votes
1 answer

How to query a matrix for multiple values and receive value

Try: =IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1) , where MATRIX, LENGTHS, and WEIGHTS ...READ MORE

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

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,600 points • 1,252 views
0 votes
1 answer

Excel Formula Extract any number greater than x charters from a string

Given that you employ two separate delimiters, ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 63,600 points • 512 views
0 votes
1 answer

Hide or visible sheets

Use a loop instead of repeating very similar ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 771 views
0 votes
1 answer

Excel VBA - Out of memory when create a dynamic array formula

Try this: Sub MyArray() Range("A1").Formula2 = "=R[2]C[2]:R[2]C[6]" End Sub But that ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,600 points • 812 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.