Latest questions in Edureka Community

0 votes
1 answer

How to export print result to excel using python (for loop)

 Use the pandas library import pandas as pd a ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,700 points • 4,927 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,700 points • 262 views
0 votes
1 answer

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,700 points • 258 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,700 points • 2,040 views
0 votes
1 answer

Using createobject("Excel.application") to create excel 2007 application

Try the next adapted way. No need ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,700 points • 642 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 63,700 points • 790 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 580 views
0 votes
1 answer

VBA Loop To Import Changing File Names

You can use a FOR loop and ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 600 views
0 votes
1 answer

Delimiters in Excel VBA Regex Patterns, filter something but not others

Change your code to this: Function RemoveTags(ByVal Value ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 493 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
 • 63,700 points • 1,083 views
0 votes
1 answer

Crawling through multiple excel files, match and copy data to master file

One application only. It would be quicker ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 379 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 242 views
0 votes
1 answer

Look up value in dictionary and put the value in cell - Excel

 Use VLOOKUP, to make sure that your "Another ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 376 views
0 votes
1 answer

Excel Power Query Group by

Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 290 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 329 views
0 votes
1 answer

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 208 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 278 views
0 votes
1 answer

Weird Date change when copying a Worksheet into a new workbook

Try  this: Dim wb ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 267 views
0 votes
1 answer

Find the serial number with criteria

Use the filter function: =FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4)) Maybe you have to ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 569 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 282 views
0 votes
1 answer

How to improve VBA Code for Monte Carlo Simulation?

Try this: Option Explicit Sub MC_Sim() ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 460 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 303 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 235 views
0 votes
1 answer

Excel Conditional Formating to find numbers a cell with text

Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 313 views
0 votes
1 answer

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 242 views
0 votes
1 answer

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,700 points • 395 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 323 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,700 points • 2,238 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 427 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 199 views
0 votes
1 answer

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 1,068 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,700 points • 455 views
0 votes
1 answer

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 323 views
0 votes
1 answer

Excel pace formula gives incorrect answers

6.3 is correct answer just not in ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 6,090 views
0 votes
1 answer

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

In Excel 2013 this formula can be ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 192 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Use a flag to omit first row Sub ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 1,586 views
0 votes
1 answer

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

The filtering criteria applied to a column ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 586 views
0 votes
1 answer

How to hide rows based on dropdownlist?

No need of any variable (besides Target). Please, ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 560 views
0 votes
1 answer

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Excel will automatically make assumptions about the ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 328 views
0 votes
1 answer

A value which should be judged by a scale gets bad judgement sometimes

Only the period (.) is accepted by ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 258 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 1,928 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 218 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 304 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 246 views
0 votes
1 answer

Excel - Find the Max for Total revenue just for year 1

In Office365 and LibreOffice Calc, there is ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,700 points • 162 views
0 votes
1 answer

Trying to make my VBA run a little bit faster

Using Variables In regards to efficiency, that's about ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 396 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 302 views
0 votes
1 answer

How can find location of value in a square using excel

For the cell address: =LET(ζ,B4:F11,BASE(MIN(IF(ζ=M ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 251 views
0 votes
1 answer

Opening large Workbooks in excel

Here is a code I tried to ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 367 views
0 votes
1 answer

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 825 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.