Trending questions in Others

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
 • 86,360 points • 1,833 views
0 votes
1 answer

Vlookup error when lookup value cell has been populated with formula

Your formula returns 4 characters. =LEFT(M8,FIND(" ",M8)-1) will return ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,228 views
0 votes
1 answer

iOS: Random black screen when loading the app

force restarting your iPhone You can always start ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 6,519 views
0 votes
1 answer

How can a column be set to display multiple spaces and tabs (white space) in a cell?

By entering your "code" in Word and ...READ MORE

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

INDEX MATCH formula in Excel returning incorrect results in some cells and correct results in others

Step through the formula that produces the ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 1,912 views
0 votes
1 answer

Dynamic Subtraction formula in excel sheet

Excel is capable of using both a ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 1,910 views
0 votes
1 answer

Copy formula from Excel to Notepad++

If you go to Formulas card, inside Formulas Auditing section there ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 2,943 views
0 votes
1 answer

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 866 views
0 votes
1 answer

Given a column of int64, make a REST call for each value, return results to a single table

Create a query like this in PowerQuery ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 1,253 views
0 votes
0 answers

VBA Excel MID Function Array

In order to calculate a UPC Check ...READ MORE

Jan 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,117 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 86,360 points • 2,631 views
0 votes
1 answer

Comparing data in Excel

A quick and mildly dirty VBA approach. ...READ MORE

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

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

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

VBA Help on Splitting Worksheet

In this bit of code: ws1.Range("a:a").Copy Range("a:a") Intersect(.UsedRange, .Columns(i)).Copy ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,322 views
0 votes
1 answer

How to make a auto counter to print pages

This will loop through all of those ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,318 views
0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Try this: Sub IFSomething() With ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,145 views
0 votes
1 answer

How to Clear Table Style in Office Scripts?

Excel tables on the web are constantly ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 86,360 points • 2,388 views
0 votes
1 answer

Excel, AVERAGEIFS, Date discrepancy

When defining a range, you are unable ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,167 views
0 votes
1 answer

Calculate the rank based on the two or Three criteria

=LET(d, A4:C18, ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,115 views
0 votes
1 answer

Excel COUNTIFS with merged cell

Although it is strongly advised to stay ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 2,284 views
0 votes
0 answers

May I know who is my trainer for the upcoming batch?

Request you to let me know who ...READ MORE

Feb 9, 2023 in Others by Priyanka
edited Mar 4, 2025 • 380 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
 • 86,360 points • 1,659 views
0 votes
1 answer

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

First, look up all ABC_* values in ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,138 views
0 votes
1 answer

Is it possible to see more than 65536 rows in Excel 2007?

Here is an interesting blog entry about the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,014 views
0 votes
1 answer

Excel If duplicate agree paste the value

With Office 365: =LET( nm,A2:A5, ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,252 views
0 votes
1 answer

Use python to remove blank cells from column and shift populated cells up

Use pandas to import and modify your excel. import pandas ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 3,205 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 86,360 points • 2,667 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

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

Underlining Headers from WPF Datagrid when printing using Excel print function

Try this: worksheet.Cells[1, i] = dgCountyEOY.Columns[i - 1].Header; ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 86,360 points • 1,234 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 86,360 points • 2,658 views
0 votes
0 answers

Gulp using browsersync with a given filename

Hello, Is it possible to create a gulp ...READ MORE

Feb 7, 2023 in Others by Michel
edited Mar 4, 2025 • 419 views
0 votes
1 answer

How to add if this cell = 0 skip and go next

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

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

Horizontal Loop

There is no need to use Range if you ...READ MORE

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

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE

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

Ms-access vba - read from excel and also update that excel

Here is the code that works without ...READ MORE

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

Paste a value from a drop-down list

Check if there is an existing sheet ...READ MORE

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

Conditions in Excel: skip cells with dates without a year

Both Google Sheets and Excel save dates ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,285 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
 • 86,360 points • 1,663 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
 • 86,360 points • 1,572 views
0 votes
1 answer

Why is a Variant parameter changing its type on function call

Remove parentheses If SaveSettings Then SaveFormSettings FormReferen This will ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,053 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
 • 86,360 points • 1,478 views
0 votes
1 answer

Count the sum of difference between two cells

Use a for loop: Sub AbsoluteDifference() ...READ MORE

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

Calculate 3 days back but skipping weekends

For Office 365, assuming the Date and Project A ranges are A2:A12 and C2:C12 respectively: =LET( ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 1,001 views
0 votes
1 answer

Find and adjacent cell with criteria

Using FILTER() & MAXIFS() • Formula used in cell F2 =FILTER($A$2:$D$12,(MAXIFS(D2:D12,B2:B12,2,C2:C12,4)=D2:D12)*(B2:B12=2)*(C2:C12=4)) Another alternative is ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,261 views
0 votes
1 answer

How many sheets are there in Excel Workbook by default?

It is 3. As stated officially by ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 86,360 points • 1,676 views
0 votes
1 answer

Multiple Select Case Statements in a Single Procedure

Here's a slightly different structuring that will ...READ MORE

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

Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 5,957 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.