Trending questions in Others

0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

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

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

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

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,317 views
0 votes
1 answer

Using c# to select a worksheet in excel

Try this: Excel.Worksheet xlWorkSheetFocus = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2); xlWorkSheetFocus.Activate(); I hope this ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 969 views
0 votes
1 answer

How to insert info into online excel spreadsheet with python selenium

I recently discovered one of my options, ...READ MORE

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

Count cells in excel with populated values

Use: =SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<> ...READ MORE

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

'npm' is not recognized as internal or external command, operable program or batch file

To your existing lines of code, include ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,690 points • 12,904 views
0 votes
1 answer

Export many small DataFrames to a single Excel worksheet

Try  this: from pandas import ExcelWriter def dfs2xlsx(list_dfs,xls_path = ...READ MORE

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

Excel Ribbon Macro not enabled

If you place a breakpoint in one ...READ MORE

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

Excel How to programmatically hide columns while keeping navigation buttons in view at top

Obviously, this does not help with the ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 1,204 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,186 views
0 votes
1 answer

Showing percentages above bars on Excel column graph

Solution  Use a line series to show the ...READ MORE

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

Reversing Text to Columns in Excel/Calc

There are built-in functions that will allow ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 871 views
0 votes
1 answer

Excel dashboard using slicers when cell contains multiple values

All values in the column are displayed ...READ MORE

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

Alternatives to Subtotal function in excel

In an unused column to the right ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 1,081 views
0 votes
1 answer

Find function to locate result of a formula, in a cell

There are several attributes to the Find ...READ MORE

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

Large excel file, I'm trying to find duplicates and copy the rest of the cells across the duplicate to the duplicate it finds

Copy the column from the other sheet ...READ MORE

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

Is there a way to transfer MSWord numbering bullets to MSExcel column?

Your numbered bullets can be copied from ...READ MORE

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

Wrap text of Table cell in exported Excel in BIRT

Export as XLS in 4.4.2 (not xlsx). ...READ MORE

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

Converting Feet-Inches to Inches Excel

We must parse the data because these ...READ MORE

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

Rename Excel worksheets from range

Rename Worksheets Using a List There are a ...READ MORE

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

Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF($A$1:$A$8,"A"),COUNTIF($A$1:$A$8,"HA")/2) - total count ...READ MORE

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

Excel calculating drop rates

Each column's "total" row is just the ...READ MORE

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

"The underlying connection was closed: An unexpected error occurred on a send." With SSL Certificate

The solution for this for me was ...READ MORE

Feb 18, 2022 in Others by Rahul
 • 9,690 points • 12,467 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

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

Excel get percentage of difference between numbers?

Find the percentage of change between two ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,120 views
+5 votes
0 answers

How to delete my edureka account permanently?

Sep 6, 2020 in Others by Webinar
 • 180 points • 4,391 views
0 votes
1 answer

What is this value means 1.845E-07 in excel?

The precise value, expressed in scientific notation, ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,191 views
0 votes
1 answer

Convert a single png file to jpg in vba

Try this code: Sub ConveretPNGToJpg() ...READ MORE

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

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 86,360 points • 3,112 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 86,360 points • 1,925 views
0 votes
1 answer

Find the differences between 2 Excel worksheets?

Place your column in column A of ...READ MORE

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

Using a UDF in Excel to update the worksheet

The MSDN KB is incorrect. It says A user-defined function called ...READ MORE

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

Logical calculation in Excel

Excel logical functions - overview. Microsoft Excel ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,079 views
0 votes
1 answer

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

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

=CONCATENATE() function giving a #VALUE! error (EXCEL 2013)

You can use the following: =A1&","&B1 TEXTJOIN would also ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 891 views
0 votes
1 answer

Excels INDEX with MATCH for multiple criteria

How to Use INDEX MATCH With Multiple Criteria ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,058 views
0 votes
1 answer

Add some word to all or some rows in Excel?

Solution: Select All cells that want to change. Right ...READ MORE

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

Excel Issue- custom format for Turkish currency

What about: #.##0,00 [$₺-tr-TR] Where #.##0,00 € would do for ...READ MORE

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

How do I create a hyperlink from Word to Excel specific cell, without macros/vba?

All you have to do is copy ...READ MORE

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

Xamarin iOS app displaying white blank screen on iPad after update to Xcode 11

Assuming you have your iPad Pro connected ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 2,130 views
0 votes
1 answer

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 86,360 points • 1,566 views
+1 vote
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 2,382 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

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

How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK($C:$C,$C2,4),0)) To divide into whichever many ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 86,360 points • 1,988 views
0 votes
1 answer

How to calculate percentage of an autosum field in excel

The fact that I was using the ...READ MORE

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

Find duplicates in a column

If any cells in column "F" contain ...READ MORE

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

Excel sumif function with conditions

Try SUMIFS. =sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time ...READ MORE

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

Excel formula to average selected cells based on certain criteria

Try: =AVERAGE(IF(X:X=A1,Z:Z)) With Ctrl+Shift+Enter. READ MORE

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

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 86,360 points • 1,412 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.