Trending questions in Edureka Community

0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,010 points • 344 views
0 votes
1 answer

Excel Desktop - Office.context.document.settings.get() didn't working

You need to call the saveAsync method of the Office.Settings interface ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 63,620 points • 300 views
–1 vote
1 answer

How can i make money from ChatGPT?

As an individual user, you cannot directly ...READ MORE

Feb 15, 2023 in ChatGPT by anonymous
 • 712 views
0 votes
1 answer

VLOOKUP to find weeknumber

Use  ISOWEEKNUM with the dates of the ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,010 points • 597 views
0 votes
1 answer

Excel Count unique values beetween 2 columns

Try this : • Formula used in cell D3 =LET(x,UNIQUE( ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,010 points • 329 views
0 votes
1 answer

Delivering live streaming video with CloudFront and AWS Media Services

To connect your MediaPackage channel to CloudFront, ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 590 views
0 votes
1 answer

Excel VBA: how to find a description from an AD-group

First add the 'description' property to your ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,010 points • 587 views
0 votes
1 answer

Openpyxl password protect excel file python

Please refer to the documentation here. Workbooks can be ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,620 points • 6,882 views
0 votes
1 answer

Finding the minimum values from different columns according to the criteria and multiplying by another column

We must use SUBTOTAL and OFFSET in ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,010 points • 288 views
0 votes
1 answer

After exporting ssrs report excel name should have todays date

If you use URL Access to generate the report, ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,620 points • 885 views
0 votes
1 answer

how to fix ChatGPT is at capacity right now on ChatGPT?

The message "ChatGPT is at capacity right ...READ MORE

Feb 9, 2023 in ChatGPT by Elton
 • 855 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

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

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,620 points • 2,214 views
0 votes
1 answer

Function to filter excel table data in to a new dataset based on value defined in another table

If you just want to add up ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,010 points • 539 views
0 votes
1 answer

EXCEL Userform - Creating multiple Labels and Textboxes with specific names

Please, test the next scenario: Insert a class ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 63,620 points • 860 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
 • 63,620 points • 339 views
0 votes
1 answer

To automatically print in excel but nothing happens

This is a revised version of your ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,620 points • 334 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,010 points • 375 views
0 votes
0 answers

Using SQL Stored Procedure vs Databricks in Azure Data Factory

ADF pipeline must be used to write ...READ MORE

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

Export a simple Dictionary into Excel file in python

You can use pandas. import pandas as pd dict1 ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,620 points • 5,557 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,620 points • 2,010 views
0 votes
1 answer

Excel VBA creating a new Outlook appointment results in a cancelled appointment

Because an inappropriate sender will be used, ...READ MORE

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

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

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

Xcode not found in the PATH and expo cannot run iOS simulator

It sounds like you've encountered a few ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 491 views
0 votes
1 answer

Tableau For Loop a String

In the case of [ { ...READ MORE

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

VBA: My Email .body doesn't concatenate with itself: application-defined or object-defined error

Try this: 'Somewehere declare this string variable Dim incomingHTMLBody ...READ MORE

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

How to reference an excel sheet by variable

Identify Worksheet By Partial Name Sub SelectByMonth() ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
 • 38,010 points • 487 views
0 votes
1 answer

DMZ kind of network design in the AKS

It sounds like you want to implement ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 484 views
0 votes
1 answer

Problem with connecting frontend and backend services through internal load balancer

It sounds like the communication between the ...READ MORE

Feb 17, 2023 in AWS by sarit
 • 1,830 points • 480 views
0 votes
1 answer

Excel Get different permutation combination of the values

This work can be completed utilising dynamic ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,620 points • 647 views
0 votes
1 answer

Excel VBA function that cross references two data sets to come up with one solution

Solution using dictionary to count Public Sub citizens() ...READ MORE

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

Why my new server shows numbers in the URL address?

It looks like the URLs for your ...READ MORE

Feb 17, 2023 in AWS by anonymous
 • 470 views
0 votes
1 answer

How to scrape the specific text from kworb and extract it as an excel file?

The best practice to scrape tables is ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,620 points • 420 views
0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,620 points • 933 views
0 votes
1 answer

Power Query M Lookup on Same table with Filtering

In power query, merge the table on ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,620 points • 1,091 views
0 votes
1 answer

How to split column into two

Using WRAPSROWS() • Formula used in cell C2 --> Exclusively Applicable To ...READ MORE

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

How do I get text in a pivot table in excel or google sheets?

Try: =QUERY(QUERY({Data!A:A, Data!Q:S}, "select Col4,max(Col1) ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,620 points • 916 views
0 votes
1 answer

Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

Use the REPT function: =REPT("ABC",4) => ABCABCABCABC ...READ MORE

Feb 18, 2023 in Others by narikkadan
 • 63,620 points • 398 views
0 votes
1 answer

Excel - count if multiple words are in a cell

Try this using wildcards * with TEXTBEFORE()&nb ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,010 points • 309 views
0 votes
0 answers

Function for factorial in Python

How can I compute an integer's factorial ...READ MORE

Feb 15, 2023 in Python by Arya
 • 990 points • 540 views
0 votes
1 answer

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

By making a new measure that didn't ...READ MORE

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

Prevent a user from adding or removing row(s) of a Range, but allow him to do so on another Range on the same sheet

The only thing I can offer is ...READ MORE

Feb 21, 2023 in Others by narikkadan
 • 63,620 points • 240 views
0 votes
0 answers

phpmyadmin Failed to set session cookie. Maybe you are using HTTP instead of HTTPS

I successfully installed PHP, Apache, and MySQL. ...READ MORE

Jul 28, 2022 in PHP by Kithuzzz
 • 38,010 points • 9,259 views
0 votes
1 answer

Name not recognized error in List.Generate

Try this: let Source = < >, columnsToExpand ...READ MORE

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

How to establish a connection to a remote Redash database using R?

To connect to a Redash database using ...READ MORE

Feb 17, 2023 in Data Science by anonymous
 • 407 views
0 votes
0 answers

Using XML with REST API through Azure Datafactory V2

I need to use a REST API ...READ MORE

Feb 15, 2023 in Azure by Damonlang
 • 1,230 points • 500 views
0 votes
1 answer

How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 63,620 points • 571 views
0 votes
1 answer

Trigger a lambda function after a rest api is accessed

To trigger a Lambda function after a ...READ MORE

Feb 16, 2023 in AWS by anonymous
 • 465 views
0 votes
1 answer

VBA Project creating a subroutine for activcell

You have to increase ActiveCell's value by ...READ MORE

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