Trending questions in Others

0 votes
1 answer

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

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

Adding column to Excel using Apache POI

The quickest way to add a column ...READ MORE

Nov 19, 2022 in Others by narikkadan
 • 86,360 points • 3,192 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,705 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,102 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

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

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

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

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

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

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

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

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

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

Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 3,969 views
0 votes
1 answer

ASP.NET generated excel file has different format than extension

You must include the xlsx file extension. The ...READ MORE

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

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

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

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

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

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

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

How do I merge multiple excel files to a single excel file

You copy a worksheet from before each ...READ MORE

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

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

In Excel 2013 this formula can be ...READ MORE

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

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

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

Insert picture into Excel cell

You can add the image into a ...READ MORE

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

Excel Formula: Count cells where value is date

Dates in Excel are just formatted numbers, ...READ MORE

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

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

If not already done, save and close ...READ MORE

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

Get random value in the range of plus/minus 10% of a cell value in Excel

Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE

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

A value which should be judged by a scale gets bad judgement sometimes

Only the period (.) is accepted by ...READ MORE

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

Highlight active row/column in Excel without using VBA?

Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE

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

Weird Date change when copying a Worksheet into a new workbook

Try  this: Dim wb ...READ MORE

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

Excel plot time series frequency with continuous xaxis

Excel has a few oddities that must ...READ MORE

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

ExcelJS wrapText in Table columns

I implemented a workaround by detecting what ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 5,245 views
0 votes
1 answer

MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 3,533 views
0 votes
0 answers

Public variable for captura path in vba excel

I need to record the path of ...READ MORE

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points
edited Mar 4, 2025 • 322 views
0 votes
1 answer

Excel countif entire row in a table

Try this: =COUNTIF(B:B,"my citeria") so if your Column ...READ MORE

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

How can find location of value in a square using excel

For the cell address: =LET(ζ,B4:F11,BASE(MIN(IF(ζ=M ...READ MORE

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

Excel to CSV with UTF8 encoding

Use of Google Spreadsheet is a straightforward ...READ MORE

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

DYNAMIC EXCEL REPORT - Make Excel Formula automatically add itself when new rows added

This is your formula: =COUNTIF(Sheet1!$A$2:$B$15,Sheet2!B1) Chan ...READ MORE

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

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

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

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

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

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

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

Excel - Find the Max for Total revenue just for year 1

In Office365 and LibreOffice Calc, there is ...READ MORE

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

Make certain characters in an Excel cell subscript Python

With Xlwings, you may accomplish this by ...READ MORE

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

SQL query to select dates between two dates

you should put those two dates between ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,580 points • 3,562 views
0 votes
1 answer

Excel Consolidate Data not working - Data does not merge

This is so that letters cannot be ...READ MORE

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

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML():   Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

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

VBA Excel Adding pictures to a worksheet

It should work as: ActiveSheet.Pictures.Insert("C:\Work\test_Project\myjpgfile.jpg").Select As that's all the ...READ MORE

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

How to return a result from a VBA function

You must associate the value with the ...READ MORE

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

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

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

Excel Formula Help Conditional Formatting - If A2 =TODAY and B2=Y turn A2 Green. If B2 = N turn A2 RED

Create a conditional format rule on A2 ...READ MORE

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

Imitate Excel style gradient color effect (red, yellow, green) in gt::data_color()

The similar color palette: c("#63be7b", "#ffeb84", "#f8696b") df %>% ...READ MORE

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

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

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

Excel formula to convert EST date time into IST date time?

The code: =IF(A1-TIME(10,30,0)<0,ABS(1+A1-TIME(10,30,0)),A1-TIME(10,30,0))  It works if your cell ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,293 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.