Trending questions in Edureka Community

0 votes
1 answer

Is it possible to create a universal hyperlink in excel for windows and mac without programming

You may learn whether it runs on ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,000 points
1,000 views
0 votes
1 answer

Create dropdown list in excel that displays different values from the same lookup table

Looks like the Worksheet_Change() sub needs two ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,600 points
598 views
0 votes
1 answer

Can't able fetch data form json using class in flutter(dart)

To fix the issue of null temperature ...READ MORE

Mar 18, 2023 in Android by vinayak
1,480 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

For Excel 2019 and above use TEXTJOIN ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,600 points
594 views
0 votes
1 answer

How to set permissions for a user in Jenkins?

Hi@akhtar, You can give access to your user ...READ MORE

Dec 7, 2020 in Jenkins by MD
• 95,460 points
37,308 views
0 votes
1 answer

Excel Debt Payoff Calculator

You can change the formula in the ...READ MORE

Apr 9, 2023 in Others by narikkadan
• 63,600 points
452 views
0 votes
1 answer

Mapping cells between between two ranges

Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,600 points
1,012 views
0 votes
0 answers

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
• 38,000 points
403 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,000 points
643 views
0 votes
1 answer

Field Wrong Calculations

You can accomplish your goals in one ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
686 views
0 votes
1 answer

Create dependable dropdown of unique items in vba

Try this: Sub UniqueList() Dim ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
682 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,600 points
767 views
0 votes
3 answers

TypeError: 'module' object is not callable

Solve By Calling with Module Name Another solution to the TypeError: 'module' object ...READ MORE

Jan 4, 2021 in Python by Carlos
35,926 views
0 votes
1 answer

MS Excel Reordering letters in cell

Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,000 points
485 views
0 votes
1 answer

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
• 38,000 points
998 views
0 votes
1 answer

VBA - Applying border around the areas with value/text

Try this: Sub BorderArroudAreas() Dim sh ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
782 views
0 votes
1 answer

Global Collections

To store your public objects and expose ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,600 points
729 views
0 votes
3 answers

TypeError: Index(...) must be called with a collection of some kind, 'Email' was passed

It is not working because your code ...READ MORE

May 13, 2020 in Python by anonymous

edited May 13, 2020 by Gitika 55,014 views
0 votes
1 answer

Export Attachment from outlook to excel cells

You will need to save the attachment ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
640 views
0 votes
1 answer

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Try this: Sub Test() Dim ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
• 38,000 points
1,199 views
0 votes
1 answer

Loop through each cell in a given range and change the value depending on value in a column in the same row

Use match() and if() without code at ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
• 38,000 points
978 views
0 votes
1 answer

jQuery Ajax error handling, show custom exception messages

Make sure you're setting Response.StatusCode to something other than ...READ MORE

Jun 2, 2022 in JQuery by Edureka
• 13,690 points
13,768 views
0 votes
1 answer

File module issues with excel format

The xlsx extensions are not supported by ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,000 points
636 views
0 votes
1 answer

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Replace Occurrences of a Substring With a ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
594 views
0 votes
1 answer

How to create arrow buttons in Excel to scroll the table left and right?

Ctrl-shift-home goes to the upper-left of all ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
• 38,000 points
927 views
0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,000 points
618 views
0 votes
1 answer

Run macro when on Worksheet change (i.e. changing sheets, not data within sheet)

Try this: 'put this sub in ThisWorkbook module ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
693 views
0 votes
1 answer

Power Query - Search an element of column A in entire column B

The delta column in PowerQuery is calculated ...READ MORE

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

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
• 38,000 points
376 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

Apr 6, 2023 in Others by narikkadan
• 63,600 points
413 views
0 votes
1 answer

How to do Rounded Corners Image in Flutter?

To make the image in your Flutter ...READ MORE

Mar 1, 2023 in Android by vishalini
1,944 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Qualify the sheets with a workbook reference ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
662 views
0 votes
1 answer

Why am I not being able to read the Excel sheet in my Jupyter Notebook

Verify that it is actually in your ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,000 points
788 views
0 votes
1 answer

Get column names of Excel worksheet with OpenPyXL in readonly mode

This will print every thing from row ...READ MORE

Oct 22, 2022 in Others by narikkadan
• 63,600 points
7,571 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
525 views
0 votes
1 answer

Type the max number title in Excel

If you have duplicates and want to ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,000 points
560 views
0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Pivot Tables are mainly designed to create aggregated data from ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,000 points
467 views
0 votes
2 answers

How to use basic authorization in PHP curl?

If you are saying Basic authentication, then ...READ MORE

Jan 3, 2021 in PHP by Manas
• 140 points
37,067 views
0 votes
1 answer

How to transpose data in an other tab in excel

If you're using a previous version of ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
632 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Use the openpyxl module in Python to do that, ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
• 38,000 points
834 views
0 votes
1 answer

Add a correct format date in Excel file with Python openpyxl

Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,600 points
2,773 views
0 votes
1 answer

Validation of postcodes in several countries

When a value is made up entirely ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
• 38,000 points
434 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

The original macro was created in an ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
591 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

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

Conversion failed when converting date and/or time from character string while inserting datetime

The SQL server supports many formats. Most ...READ MORE

Apr 30, 2022 in Other DevOps Questions by narikkadan
• 63,600 points
15,073 views
0 votes
1 answer

An error occurred (InvalidClientTokenId) when calling the GetCallerIdentity operation: The security token included in the request is invalid.

Hi@akhtar, I think there is a problem with ...READ MORE

Sep 23, 2020 in AWS by MD
• 95,460 points
40,271 views
0 votes
1 answer

How to change date format from 201904 to Apr-19 in excel

This 201904 is recognised as a number ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,000 points
573 views
0 votes
1 answer

User form to print an array of sheets

It appears that when a UserForm is ...READ MORE

Apr 3, 2023 in Others by narikkadan
• 63,600 points
438 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Try this: let columnNames= {"E ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
2,117 views
0 votes
1 answer

How to find all internal ranges in a specified range

It is simple to compare once you ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,600 points
731 views