Trending questions in Edureka Community

0 votes
1 answer

Open webpage in fullscreen in Safari on iOS

No, javascript cannot be used to switch ...READ MORE

Nov 4, 2022 in IOS by Rahul
 • 9,690 points • 5,766 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 5,206 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
 • 86,360 points • 1,265 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
 • 86,360 points • 1,394 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 6,225 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,730 points • 1,272 views
0 votes
1 answer

Automatically fill cell with a set value on specific calendar day and time

 Use this formula: =IF(NOW()>DATE(2023,3,1)+TIME(8,0, ...READ MORE

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

Count duplicate words within string and remove if it occurs less than 10 times

Without some sample data, it's challenging to ...READ MORE

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

Fill a FileDialog from another macro

Add an optional parameter to UpgradeEngine - something like: Sub ...READ MORE

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

Excel formula in Pandas

 Use this: df['col2'] = df['col1'].shift().lt(df['col1']).astype(int) I hope this helps ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 3,020 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
 • 1,205 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 • 1,321 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
 • 86,360 points • 1,141 views
0 votes
0 answers

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 2,041 views
0 votes
1 answer

Laravel - Connection could not be established with host smtp.gmail.com [ #0]

While using the Laravel project directory, edit ...READ MORE

Feb 22, 2022 in Others by Aditya
 • 7,680 points • 16,702 views
0 votes
0 answers

Declaring a resource that is not recognized

Hello All, I am new to Terraform and ...READ MORE

Mar 8, 2023 in AWS by Brandon
edited Mar 5, 2025 • 391 views
0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 86,360 points • 1,642 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
 • 86,360 points • 1,212 views
0 votes
0 answers

which phase of software production are the focus of devops?

Which phase(s) of software products are the ...READ MORE

Dec 22, 2022 in DevOps & Agile by Edureka
 • 13,740 points • 3,477 views
0 votes
0 answers

I want to create excel driven framework in selenium java

I m working on selenium java framework, ...READ MORE

Feb 28, 2023 in Selenium by Rajat
edited Mar 5, 2025 • 701 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,580 points • 5,599 views
0 votes
0 answers

how to count the number of methods other than OPTION on AWS API Gateway with python?

I need to count the number of ...READ MORE

Feb 14, 2023 in AWS by Ashwini
 • 5,430 points • 1,223 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
 • 86,360 points • 978 views
0 votes
1 answer

VBA Create and Rename Tables

Convert Table to Excel Table (ListObject) Option Explicit Sub ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,188 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
 • 86,360 points • 1,320 views
0 votes
1 answer

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 86,360 points • 7,992 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,730 points • 1,194 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
 • 86,360 points • 954 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
 • 86,360 points • 1,469 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 • 1,384 views
0 votes
0 answers

In which language is basically written Chrome Browser on Android?

What language is the Android version of ...READ MORE

Nov 10, 2022 in Android by Edureka
 • 13,740 points • 1,706 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 3,547 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 • 1,244 views
0 votes
1 answer

What VBA Code to Hide Excel Quick Access Toolbar?

Use this: Sub HideQuickAccessTB() Application.ExecuteExcel4Macro ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 2,190 views
0 votes
1 answer

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

First off, if you're starting a new ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 86,360 points • 7,788 views
0 votes
1 answer

How to increment a column value if it repeats, otherwise reset to 1?

Use COUNTIF: =COUNTIF(A$2:A2,A2) The absolute and relative cell coordinates ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,670 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,730 points • 1,167 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
 • 86,360 points • 1,275 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
 • 86,360 points • 1,060 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
 • 86,360 points • 1,272 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Call the API property to activate the autofilter: import xlwings ...READ MORE

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

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,650 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
 • 86,360 points • 1,391 views
0 votes
1 answer

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

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

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,647 views
0 votes
0 answers

I want to build open source billing system for Open Stack with easy deploy.

I want to build open source billing ...READ MORE

Feb 15, 2023 in OpenStack by Sumon
edited Mar 4, 2025 • 1,189 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
 • 86,360 points • 1,044 views
0 votes
1 answer

How do I copy a specific range of cells after I use AutoFilter in VBA?

Set the range of filtered data Set Rng ...READ MORE

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

iOS 13 Custom Fonts download and installation

Step 1: From the Home screen, tap ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
 • 23,580 points • 4,323 views
0 votes
1 answer

Where are the Microsoft Visual C++ 2015-2022 Redistributable (x64) packages installed?

They are, in my opinion, at their best. C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Redist\MSVC It's worth noting ...READ MORE

Jun 15, 2022 in C++ by Damon
 • 4,960 points • 11,725 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.