Trending questions in Others

0 votes
1 answer

Calculating a Rolling IRR in Excel

I'm assuming a little bit here, but ...READ MORE

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

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

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

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

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

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
• 86,360 points
1,886 views
0 votes
1 answer

Bloomberg excel add-in BDH

Change an override Fill=P to, for instance, ...READ MORE

Oct 11, 2022 in Others by narikkadan
• 86,360 points
5,282 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
915 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
945 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,154 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,238 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 86,360 points
1,536 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
928 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
922 views
0 votes
0 answers

I have a problem hosting a project made in Next.js

I have Next.js project. When I connect ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 5,380 points
598 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

Oct 28, 2022 in Others by narikkadan
• 86,360 points
4,505 views
0 votes
0 answers

Hi All, I am HR but I would like to switchover to IT. Let me know your thoughts.

Hi Guys, I have 9+ years of experience ...READ MORE

Feb 4, 2023 in Others by Ganesan

edited Mar 4 240 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,161 views
0 votes
0 answers

When will I get my Certificate?

Today I have completed my "FREE AWS ...READ MORE

Feb 2, 2023 in Others by Sakib

edited Mar 4 295 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,321 views
0 votes
1 answer

Adding formulas to excel spreadsheet using python

You can create any formula that Excel ...READ MORE

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

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

Oct 24, 2022 in Others by narikkadan
• 86,360 points
4,646 views
0 votes
1 answer

Unprotect an Excel file programmatically

Try this. It worked for me.  def Remove_password_xlsx(filename, ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 86,360 points
2,569 views
0 votes
0 answers
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,345 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,156 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,419 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,235 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
997 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,035 views
0 votes
0 answers

Hi, I really need some help using Django on Pycharm.

Hi, I am a student and my ...READ MORE

Feb 1, 2023 in Others by Pahone

edited Mar 4 256 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
1,810 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,237 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,109 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

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

Reading Excel file using node.js

Several distinct libraries perform Excel file parsing ...READ MORE

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

Consolidate orders to single row counting number of orders and averaging the result

Try this: Sub aveCount() Dim rng As Range Dim cl ...READ MORE

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

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 86,360 points
3,209 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,386 views
0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

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

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

Feb 18, 2022 in Others by Aditya
• 7,680 points
15,225 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
943 views
0 votes
0 answers

i want to use one formula which can fill the row table as per same cell but from different worksheets?

same cell in excel from different worksheets ...READ MORE

Jan 31, 2023 in Others by pramod

edited Mar 4 255 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
855 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,193 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
• 86,360 points
1,191 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
2,722 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
2,503 views