Trending questions in Others

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 • 1,709 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,407 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 • 1,875 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,076 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,576 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,015 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 • 2,535 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,326 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,446 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,007 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,422 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 • 936 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
 • 86,360 points • 2,958 views
0 votes
0 answers

Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V

While initializing derby with bin/schematool -initSchema -dbType derby it ...READ MORE

Mar 14, 2023 in Others by Prashant
edited Mar 5 • 170 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 • 965 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

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

Color specific cell in an xlsx with python

Column B's cells must be iterated through ...READ MORE

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

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 3,394 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,231 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

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

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 7,625 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 • 1,818 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 • 993 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,293 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,287 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,195 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 • 894 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 • 829 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,074 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,000 points • 1,120 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 • 1,627 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 • 1,407 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 705 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,138 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 • 2,257 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 • 831 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
 • 86,360 points • 1,258 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
 • 86,360 points • 910 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 • 1,676 views
0 votes
1 answer

How to clear TextField Entered Text automatically in Flutter?

Hi@akhtar, You can control the TextField in your ...READ MORE

Sep 10, 2020 in Others by MD
 • 95,460 points • 39,475 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,307 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
 • 86,360 points • 871 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,148 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,000 points • 887 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 • 3,219 views
0 votes
1 answer

Tableau For Loop a String

In the case of [ { ...READ MORE

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

Automatically fill cell with a set value on specific calendar day and time

 Use this formula: =IF(NOW()>DATE(2023,3,1)+TIME(8,0, ...READ MORE

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

VBA Excel: Write timestamp to cell on change of another cell

Your request is a little vague, and ...READ MORE

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