Trending questions in Others

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
• 63,600 points
472 views
0 votes
1 answer

How to use count and group by at the same select statement

This will do what you want (list of ...READ MORE

Nov 7, 2022 in Others by gaurav
• 23,260 points
976 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
• 63,600 points
975 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
• 63,600 points
675 views
0 votes
1 answer

Excel VLOOKUP where the key is not in the first column

INDEX/MATCH will do it in any direction of ...READ MORE

Oct 20, 2022 in Others by narikkadan
• 63,600 points
1,703 views
0 votes
1 answer

.doc to pdf using python

A simple example using comtypes, converting a single ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 63,600 points
2,799 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
• 63,600 points
776 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
• 63,600 points
1,291 views
0 votes
1 answer

artificial intelligence is associated with which generation

Artificial Intelligence is associated with fifth-generation computer ...READ MORE

Feb 7, 2022 in Others by Edureka
• 12,690 points
12,665 views
0 votes
1 answer
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,260 points
845 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
• 63,600 points
1,665 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
• 63,600 points
1,188 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
• 63,600 points
625 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

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

Oct 3, 2022 in Others by narikkadan
• 63,600 points
2,354 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,260 points
823 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
• 63,600 points
865 views
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
• 63,600 points
2,074 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
• 63,600 points
1,469 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
• 63,600 points
641 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,260 points
809 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
• 63,600 points
678 views
0 votes
1 answer

Excel chart a line per category

Pivot charts, in my opinion, are the ...READ MORE

Nov 15, 2022 in Others by narikkadan
• 63,600 points
500 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
• 63,600 points
1,277 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
• 63,600 points
966 views
0 votes
0 answers

can u help me to check this code, maybe something is missing or something

//Sensor Ultrasonic #include <NewPing.h> #define TRIGGER_PIN  4  // Arduino ...READ MORE

Nov 26, 2022 in Others by Riki

edited Mar 4 24 views
0 votes
1 answer

How to convert Ods file to Data Set C#

You can see the answer here: READ MORE

Oct 8, 2022 in Others by narikkadan
• 63,600 points
2,122 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
• 63,600 points
1,204 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
• 63,600 points
645 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

Nov 12, 2022 in Others by narikkadan
• 63,600 points
600 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
• 63,600 points
643 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
• 63,600 points
555 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
• 63,600 points
2,776 views
0 votes
1 answer

Obtaining Excel worksheet reference by worksheet name via C#

Instead of using Excel.Workbook.Sheets collection, it's easier to access Excel.Workbook.Worksheet collection, ...READ MORE

Nov 10, 2022 in Others by narikkadan
• 63,600 points
679 views
0 votes
0 answers

Format an Excel column (or cell) as Text in C#?

When I copy values from a data ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
1,113 views
0 votes
1 answer

Adjust cell width in Excel

Use set_column as follows: worksheet1.set_column(1, 1, 25) This is defined as ...READ MORE

Oct 10, 2022 in Others by narikkadan
• 63,600 points
2,006 views
0 votes
2 answers

Attempted import error: 'Switch' is not exported from 'react-router-dom'

import it from material UI there will ...READ MORE

Sep 1, 2022 in Others by anonymous
5,986 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
• 63,600 points
1,995 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
• 63,600 points
1,736 views
0 votes
1 answer

Excel formula: Correct syntax of SUM with ROW?

A few explanations of why your formula ...READ MORE

Nov 10, 2022 in Others by narikkadan
• 63,600 points
656 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
• 63,600 points
824 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
• 63,600 points
1,775 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
• 63,600 points
2,253 views
0 votes
1 answer

Copy the Excel RANK formula without changing the end reference

Placing $ before the cell references makes ...READ MORE

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

Excel remaining days count from today until due date minus weekends?

The problem is that you are not ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 63,600 points
472 views
0 votes
1 answer

What is the application name of Microsoft Excel?

The name and path of Excel can ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 63,600 points
846 views
0 votes
1 answer

How to programmatically distinguish Excel 2019 from 2016?

Using the output of the MS Office ...READ MORE

Nov 11, 2022 in Others by narikkadan
• 63,600 points
588 views
0 votes
1 answer

Excel issue "excel 4.0 function stored in defined names"

I don't want to revive an old ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 63,600 points
835 views
0 votes
1 answer

Avoiding index & match #N/A value

Use IFERROR to set an alternative value if the ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 63,600 points
436 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

Oct 2, 2022 in Others by narikkadan
• 63,600 points
2,312 views