Trending questions in Edureka Community

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,684 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,416 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
1,206 views
0 votes
1 answer

How do I get a “select count(*) group by” using laravel eloquent?

Hello @kartik, You could use this: $reserves = DB::table('reserves')->selectRaw('*, ...READ MORE

Oct 21, 2020 in Laravel by Niroj
• 82,800 points
38,026 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,417 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,332 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,933 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,921 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,324 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,730 points
1,941 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,914 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,730 points
3,667 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,515 views
0 votes
1 answer

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

Oct 18, 2022 in Others by narikkadan
• 86,360 points
6,614 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,508 views
0 votes
1 answer

Getting data out of a cell with a #NAME? error in Excel VBA

If you need VBA, use .Formula: Dim f As ...READ MORE

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

How to directly read excel file from s3 with pandas in airflow dag?

Python is not working when I try to read an excel file from S3 inside of an AI flow dag.  It is quite strange because it works when I read it using pd.read excel(s3 excel path) from outside airflow.   How I acted:   Create an AWS account in Airflow (this works well as I can list my s3 bucket) In my Docker environment, where I run Airflow, instal pandas and s3fs. Pd.read excel(s3 excel path) should be used to attempt to read the file. I've tried it outside of Airflow, and it functions as stated.  Furthermore, even after waiting 20 minutes, nothing happens; the dag just keeps running indefinitely (at the stage where it is meant to read the file). (I am attempting to read the file ...READ MORE

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

How to sum the next n non-empty cells in LibreOffice Calc?

Here's a volatile solution (assuming you don't ...READ MORE

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

Text border using css (border around text)

To apply borders to fonts in CSS, ...READ MORE

Jun 28, 2022 in CSS by Edureka
• 12,730 points
11,428 views
0 votes
1 answer

iOS: Random black screen when loading the app

force restarting your iPhone You can always start ...READ MORE

Sep 21, 2022 in Others by rajatha
• 7,680 points
7,727 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

You might keep track of the location ...READ MORE

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

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

Oct 28, 2022 in Others by narikkadan
• 86,360 points
6,143 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 519 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

Add column, custom column, with formula: = ...READ MORE

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

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
• 7,070 points
16,774 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

Oct 21, 2022 in Others by narikkadan
• 86,360 points
6,434 views
0 votes
0 answers

Termux code to install git on termux in Android mobile

$ pkg install github Says: Reading state information... Done E: ...READ MORE

Nov 8, 2022 in Android by Edureka
• 13,730 points
2,975 views
0 votes
3 answers

Command "python setup.py egg_info" failed with error code 1 in C:\Users\Nadeem\AppData\Local\Temp\

You have an out of date version ...READ MORE

Dec 15, 2020 in Python by Rajiv
• 8,870 points
40,334 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,414 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

Nov 6, 2022 in Others by narikkadan
• 86,360 points
5,729 views
0 votes
1 answer

OR and IF function for multiple values

Your OR functions will always return TRUE ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
1,455 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,238 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,343 views
0 votes
1 answer

Macro /excel date format change

You must handle the string Date differently ...READ MORE

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

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

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

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 86,360 points
2,777 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,365 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
• 86,360 points
1,561 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,317 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
1,121 views
0 votes
1 answer

To Keep only 1 header while merging Multiple file

There is potential for improvement here, such ...READ MORE

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

Python Error when I'm converting Excel to JSON

The "Birth Year" value in the p ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 86,360 points
1,746 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,730 points
1,339 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
• 86,360 points
1,271 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

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

How can I automatically formulate a column while adding values ​to another? EXCEL

Use a # in your range references ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,000 points
1,228 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
1,314 views
0 votes
1 answer

How to Use rbind and cbind on Single Dataframe

To obtain the desired output, you can ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
• 1,420 points
3,019 views