Trending questions in Edureka Community

0 votes
1 answer

Excel - function to convert first letter of each word to uppercase

there are two methods to do this: Method ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,314 views
0 votes
0 answers

ionic build ios error ( ionic cordova build ios )

When i run "ionic cordova build ios" ...READ MORE

Nov 15, 2022 in Mobile Development by gaurav
 • 25,260 points • 1,563 views
0 votes
0 answers

Which standard library to use in Kotlin?

When using the JVM with Kotlin, it ...READ MORE

Nov 18, 2022 in Kotlin by Tejashwini
 • 5,380 points • 1,329 views
0 votes
0 answers

Best way to find if an item is in a JavaScript array?

What is the best approach to determine whether an object is in an array? This is the best method I've found: function include(arr, obj) { for (var ...READ MORE

Dec 12, 2022 in Java by Nicholas
 • 7,760 points
edited Mar 4, 2025 • 443 views
0 votes
1 answer

Excel How to programmatically hide columns while keeping navigation buttons in view at top

Obviously, this does not help with the ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 1,903 views
0 votes
0 answers

Can VS Code run on Android?

Does anyone know if Microsoft intends to ...READ MORE

Dec 10, 2022 in Android by Edureka
 • 12,730 points
edited Mar 4, 2025 • 535 views
0 votes
1 answer

Export page to excel with logo image

Try this: Response.ContentType = "application/vnd.ms-excel"; ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 2,808 views
0 votes
1 answer

Excel is not updating cells, options > formula > workbook calculation set to automatic

This occurred to me today in a ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 1,515 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 86,360 points • 3,146 views
0 votes
0 answers

Error code 605 while trying to use biometric authentication on Android phone

The Samsung Galaxy M30S, running Android Q, ...READ MORE

Nov 23, 2022 in Android by Edureka
 • 13,730 points • 1,262 views
0 votes
1 answer

Using "If cell contains #N/A" as a formula condition.

Input the following formula in C1: =IF(ISNA(A1),B1,A1*B1) Screenshots: When #N/A: When not ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,297 views
0 votes
1 answer

Creating an unique export data VBA Macro Function in Excel

Unfortunately, the tables will vary in size. ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 1,634 views
0 votes
0 answers

Input string was not in a correct format

I am working on a basic calculator  ...READ MORE

May 2, 2022 in Other DevOps Questions by Kichu
 • 19,040 points • 4,882 views
0 votes
1 answer

Spell check an Excel sheet in VBA

Use this code to check the whole ...READ MORE

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

SQL Error: ORA-00922: missing or invalid option

The lack of an underscore between "chartered" ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 86,360 points • 4,242 views
0 votes
1 answer

Is it possible to round to different decimal places in excel based on the range?

Where the range is multiple cells: Excel.Worksheet sheet ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 1,439 views
0 votes
1 answer

Using standard deviation function in excel for a specific criteria?

Use this: =STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000)) Depending on one's version this may ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 1,693 views
0 votes
1 answer

How should I show the Developer tab in Excel using Macros? (Excel VBA)

You can activate (mode=1) or deactivate (mode=0) ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 1,561 views
0 votes
1 answer

How to use count and group by at the same select statement

This will do what you want (list of ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 25,260 points • 1,941 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,945 views
0 votes
0 answers

How can I find the first occurrence of a sub-string in a python string?

I'd like to locate the first index ...READ MORE

Nov 24, 2022 in Python by sarit
 • 1,830 points • 1,188 views
0 votes
1 answer

In GCP share a VPN gateway with other projects

You must consider the following factors: Cost: It ...READ MORE

Nov 8, 2022 in GCP by Ashwini
 • 5,430 points • 1,864 views
0 votes
0 answers

How to reduce a huge excel file

I have a short, straightforward *.XLS file ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,078 views
0 votes
1 answer

Android: When should I use a Handler() and when should I use a Thread?

Because Chrome V8 is a JavaScript engine, ...READ MORE

Nov 10, 2022 in Android by Edureka
 • 12,730 points • 1,741 views
0 votes
0 answers

Edureka site is very slow

Edureka site  is very slow , it ...READ MORE

Dec 3, 2022 in Ask us Anything! by Vishal
edited Mar 4, 2025 • 796 views
0 votes
1 answer

MAX function in Excel: is it possible to provide the range by means of variables?

Try this: =MAX(INDEX(A:A,B2):INDEX(A:A,B3)) READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 1,554 views
0 votes
1 answer

iOs build fails with FacebookLogin package

Looks like the problem was my Xcode ...READ MORE

Nov 15, 2022 in Mobile Development by gaurav
 • 25,260 points
edited Mar 5, 2025 • 1,632 views
0 votes
1 answer

Excel Function Goal Seek Equivalent Algorithm in C #

Nuget has libraries available like Trident.GoalSeek and ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 86,360 points • 2,807 views
0 votes
1 answer

How do I declare and initialize an array in Java?

To declare and initialize an array in ...READ MORE

Jun 22, 2023 in Java by Khan Sarfaraz
• 700 points • 1,336 views
0 votes
0 answers

Not all parameters were used in the SQL statement (Python, MySQL)

Error: mysql.connector.errors.ProgrammingError: Not all parameters were used in ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 4,821 views
0 votes
1 answer

Convert an excel file (xls,xlsx) for PDF

Try this: import java.io.FileInputStream; import ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,933 views
0 votes
0 answers

How to get original image when we zoom in and zoom out the image in ios

Hi i am beginner in ios and ...READ MORE

Nov 17, 2022 in Mobile Development by gaurav
 • 25,260 points • 1,414 views
0 votes
1 answer

Formatting Phone Numbers in PHP

This is a US phone formatter that ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 25,260 points • 1,834 views
0 votes
0 answers

Is it possible to get a list of keywords in Python?

I want to obtain a string list ...READ MORE

Nov 24, 2022 in Python by sarit
 • 1,830 points • 1,159 views
0 votes
1 answer

Excel create an Index on the first sheet with links to subsequent sheets

Below example shows how to use the ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 86,360 points • 2,567 views
0 votes
1 answer

Call the official *Settings* app from my app on iPhone

It also functions in iOS versions greater ...READ MORE

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

How to add check symbol in excel cell SXSSFSheet java

Try this: import java.io.FileOutputStream; import org.apache.poi.xssf.streaming.*; class CreateSXSSFUnicode { public ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 1,612 views
0 votes
1 answer

Excel calculating drop rates

Each column's "total" row is just the ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 86,360 points • 2,254 views
0 votes
1 answer

Is there a way to use LOOKUP/VLOOKUP/HLOOKUP to return headers in EXCEL. Current formula returning wrong value

Try this: =SUMPRODUCT(--(Schedule!$B$3:$F$7=A3)) READ MORE

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

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 2,166 views
0 votes
0 answers

Default Ringtone on a VOIP app in iOS

I'm trying to find a way to ...READ MORE

Nov 16, 2022 in Mobile Development by gaurav
 • 25,260 points • 1,487 views
0 votes
1 answer

Cell character counting formula?

With data in column A, in B1 enter: =SUMPRODUCT(--(LEN(A:A)=ROW())) Then copy downwards: I ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,220 views
0 votes
0 answers

How to set audio file as ringtone in iphone programmatically?

I've developed a programme. I may select ...READ MORE

Nov 16, 2022 in IOS by Soham
 • 9,730 points • 1,490 views
0 votes
1 answer

Change color of PNG image via CSS?

The simplest one line that worked for ...READ MORE

Jun 1, 2022 in CSS by Edureka
 • 12,730 points • 8,701 views
0 votes
1 answer

Paste special issue, From Excel to Word

Since the table in the word document ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 86,360 points • 1,292 views
0 votes
0 answers

What is an activity, a context and an intent in Android?

Could someone kindly explain to me what ...READ MORE

Nov 23, 2022 in Android by Edureka
 • 13,730 points • 1,179 views
0 votes
0 answers

Android Facebook API Shows White Blank Page

I use the Facebook API for Android, ...READ MORE

Nov 15, 2022 in Android by Edureka
 • 13,730 points • 1,525 views
0 votes
1 answer

Python: Convert PDF to DOC

Install LibreOffice and try this: lowriter --invisible --convert-to ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 1,504 views
0 votes
0 answers

Difference between upload() and putObject() for uploading a file to S3?

In the AWS-SDK's S3 class, what is ...READ MORE

Apr 19, 2022 in AWS by Rahul
 • 9,690 points • 2,603 views
0 votes
1 answer

GCP App Engine Access to GCloud Storage without 'sharing publicly'

I believe that https://cloud.google.com/storage/docs/access-control/create-signed-urls-program will work for ...READ MORE

Nov 10, 2022 in GCP by Ashwini
 • 5,430 points • 1,690 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.