Trending questions in Others

0 votes
0 answers

runs on f8 but not on f5

Sub copypartdatatest()     Dim ctr, tdt, lr, lr1, lr2, ...READ MORE

Mar 25, 2023 in Others by Madhusudan
edited Mar 5, 2025 • 386 views
0 votes
1 answer

Is there a faster way to delete table rows so my script doesn't take hours to run?

This is for your rowAddressToRemove variable. So instead of ...READ MORE

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

Camel case converter in an excel

Try this: =LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_","") ...READ MORE

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

Iterator should return strings, not bytes (the file should be opened in text mode)

You can read the data of the ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 3,065 views
0 votes
1 answer

How to read excel file column by column

Rows will provide you the rows, as ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 1,039 views
0 votes
1 answer

How to calculate current streak of conditional number, and excluding blanks?

To solve this  use xmatch if it's ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,078 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
 • 86,360 points • 2,219 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 3,110 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
 • 86,360 points • 2,203 views
0 votes
1 answer

Get column index from table header in excel

Try it. The StaffDetailsTbl table's headers are ...READ MORE

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

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 4,032 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,000 points • 1,808 views
0 votes
0 answers

How to delete my edureka account?

I no longer want use edureka. So, ...READ MORE

Mar 21, 2023 in Others by Edureka
edited Mar 5, 2025 • 415 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

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

How to copy entire data using row by row and paste to another sheet

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

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 2,293 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,000 points • 1,907 views
0 votes
1 answer

Confused on VBA copy destination

Try this: Sub so75496418AddChart() Dim rng As Range Dim strTypeName ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,639 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
 • 86,360 points • 1,806 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
 • 86,360 points • 1,800 views
0 votes
1 answer

outputting a coloured excel file, python

If you already have an Excel workbook, ...READ MORE

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

Python erroring

Amend the spreadsheet file path from: 'C:\Technical\AutomationScri ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 2,041 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,000 points • 1,860 views
0 votes
1 answer

Releasing COM-Object not necessary?

This place has infamously poor Office COM ...READ MORE

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

Moving oldest files first from source to destination

You have to change the following line: If ...READ MORE

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

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 3,141 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 2,231 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,000 points • 1,974 views
0 votes
1 answer

Ignore empty filter criteria in SUMPRODUCT formula

=SUMPRODUCT(($C$2:$C$7)*(IF(E1="",1,($A$2:$A$7=E1))*(IF(E2="",1,$B$2:$B$7=E2)))) Replaces the condition with 1 (all values) in case E1 and/or E2 is ...READ MORE

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

Excel VBA Scheduled message pop up box reminder

What exactly does W11 contain? In Excel, ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 2,306 views
0 votes
1 answer

Excel VBA select range

Please test the following event with adapted ...READ MORE

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

Creating sheets with names in column B and assigning data to each sheet for particular name

after the first occurrence of Set sht = ...READ MORE

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

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 86,360 points • 3,545 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
 • 86,360 points • 1,512 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
 • 86,360 points • 2,320 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
 • 86,360 points • 1,841 views
0 votes
1 answer

How to concatenate elements of a single-dimensional array using VBA?

Using Microsoft 365's UNIQUE and SORT in VBA ' This is a ...READ MORE

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

Looping through a folder with Excel files and scraping date from selected cells usin VBA

You record the outcome of your comparison ...READ MORE

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,702 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,000 points • 1,379 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,661 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,000 points • 1,365 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Object Variables in Loops The main issue was ...READ MORE

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

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

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

Conditional format based on external cell value

Use a rule with the formula =$Q6="Yes" and apply ...READ MORE

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

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 1,348 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,000 points • 1,727 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
 • 86,360 points • 1,555 views
0 votes
1 answer

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

You may try: The formula in B1: =MAP(A1:A12,LAMBDA(x,SUM(- ...READ MORE

Feb 24, 2023 in Others by narikkadan
 • 86,360 points • 1,286 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.