Trending questions in Others

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,328 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, 2025 • 343 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,272 views
0 votes
0 answers

Why is my console.log(persons.includes(newNameObject)) returning as false, when newNameObject already exists in the array?

I am working on a simple react ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 5,380 points • 680 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,433 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,517 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, 2025 • 394 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

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

Is there a hierarchy inferring algorithm available in python?

Convert the list of values to the ...READ MORE

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

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

Create a table (insert > table) from ...READ MORE

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

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

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

Convert Excel to PDF using JavaScript

You're clobbering objExcel on line 15: var objExcel ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 86,360 points • 5,364 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
 • 86,360 points • 1,472 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
 • 86,360 points • 1,340 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, 2025 • 391 views
0 votes
1 answer

Excel formula to convert number to both feet and inches

If you want the answer to be ...READ MORE

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

Excel - Stack Data based in Condition

Try this : =TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss") It appears you tried Filter ...READ MORE

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

How to subtract dates in Excel with different date formats?

You can use dates in any computation ...READ MORE

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

Insert formula in multiple excel sheets

To fill across the sheets, you can ...READ MORE

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

Create Drop-Down List Using a Formula (Without Data Validation)

As far as I am aware, it ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 4,030 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
 • 86,360 points • 1,213 views
0 votes
1 answer

Name for excel graph problem with the vba generator

Change the name of the workbook : Sub Macro_name_graph2() ...READ MORE

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

PHPExcel freeze row and columns

You must be attempting to Freeze both ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 3,577 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, 2025 • 363 views
0 votes
1 answer

Excel - External link to multiple workbooks

Try the INDIRECT() function. But this won't automatically update ...READ MORE

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

Excel VBA: Open Hyperlinks in a loop and copy paste download link in a sheet

I want to click on a number ...READ MORE

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,992 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
 • 86,360 points • 1,375 views
0 votes
1 answer

Rails - Export records to downloadable excel file using axlsx gem (Keep MVC)

Use  axlsx_rails Gem with the template. In my case, ...READ MORE

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

Excel Count if with index match

Try this: Countif(Index(rangeoflookupvalues,,match(Columnvaluetobe ...READ MORE

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

How to convert excel to PDF using Python

Specify your whole output path instead of ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 3,864 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
 • 86,360 points • 1,127 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
 • 86,360 points • 1,212 views
0 votes
0 answers

Merge rows based on value (pandas to excel - xlsxwriter)

I'm attempting to use xlsxwriter to output ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 4,195 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 1,903 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,627 views
0 votes
1 answer

Excel how to find the default file extension

Make a dict of xlfileformats:extensions and use ...READ MORE

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

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

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

Excel Online Script for Message Boxes

Use "throw" followed by your text to ...READ MORE

Nov 7, 2022 in Others by narikkadan
 • 86,360 points • 3,945 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 3,686 views
0 votes
0 answers

Object cannot be cast from DBNull to other types

I am getting this error and I am ...READ MORE

May 14, 2022 in Others by Kichu
 • 19,040 points • 3,193 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
 • 86,360 points • 1,289 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
 • 86,360 points • 1,068 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
 • 86,360 points • 1,145 views
0 votes
1 answer

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

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

Is there a way to search the iOS app store online?

Apple finally made it possible to just use ...READ MORE

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

How do I transpose a column to a matrix in Excel?

With data in column A, pick some cells ...READ MORE

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

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

Feb 16, 2022 in Others by Edureka
 • 13,690 points • 15,274 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.