Trending questions in Others

0 votes
0 answers

SQL Query with NOT LIKE IN

Please help me to write a sql ...READ MORE

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

Get last modified object from S3 using AWS CLI

Try this command $ aws s3api list-objects --bucket ...READ MORE

Sep 20, 2022 in Others by anonymous
edited Mar 5, 2025 • 6,843 views
0 votes
1 answer

Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 2,799 views
0 votes
1 answer

Excel custom format: What does [$€-2] mean?

The 2 in [$€-2] is a "Numeral ...READ MORE

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

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

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

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

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

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

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

Ignore text values in subtotal function

Use 7 as the second criterion in AGGREGATE instead ...READ MORE

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

Excel to PDF C# library

These articles will be help for you ...READ MORE

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

Export HTML Table to Excel- Doesn't Open in Office 2010

We had the same issue too many ...READ MORE

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

Provide an image for WhatsApp link sharing

the problem is with the size of ...READ MORE

Feb 28, 2022 in Others by narikkadan
 • 86,360 points • 11,743 views
0 votes
1 answer

Detect whether Excel workbook is already open

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

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

How can I copy from specific sheet in excel

You should use wb.Sheets("Name of sheet").Copy - ...READ MORE

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

Convert Excel sheet having shivaji fonts to csv having google unicode utf-8 encoding

I take it that you mean "Shivaji ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 2,689 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 86,360 points • 1,528 views
0 votes
0 answers

EXCEL - SUMIF for multiple sheets

If another range of cells in each ...READ MORE

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

Xls to csv converter

Use xlrd - it's faster, cross-platform, and ...READ MORE

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

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

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

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

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

Insert pie chart in Excel macro function

Think about arranging your data in a ...READ MORE

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

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

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

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

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

Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

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

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

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

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

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

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 86,360 points • 1,779 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 965 views
+1 vote
0 answers

Delete eureka account

Hi friends. I want to delete my account. ...READ MORE

Sep 30, 2020 in Others by anonymous
 • 130 points • 4,135 views
0 votes
1 answer

Excel viewer lib

You will need to save your excel ...READ MORE

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

Amortization schedule for many rows using Excel Macro

Try this: Sub one() Dim intRate, loanLife, initLoan, payment ...READ MORE

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

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

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

How to create DropDown which have dynamic Validation List

In my data table, the columns "Category" ...READ MORE

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

Git error: "Please make sure you have the correct access rights and the repository exists"

Your git URL might have changed. Change ...READ MORE

Feb 17, 2022 in Others by Aditya
 • 7,680 points • 12,068 views
0 votes
1 answer

Speed up Excel vba program

Not at all. I used it. You ...READ MORE

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

How to manually piece together a fraction on excel

Instead of controlling formatting in your calculations, ...READ MORE

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

Excel Arrow Key is Creating a Formula?

Your scroll lock is on. This is ...READ MORE

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

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

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

Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 86,360 points • 2,526 views
0 votes
1 answer

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

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

Data entry into web page from excel

Reading the File in PHP Example 1 How to ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 86,360 points • 1,887 views
0 votes
0 answers

locked textbox property set to true at worksheet

Hello, I have textboxes (activeX controls) on ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 943 views
0 votes
0 answers

xcel VBA Chart counting and formatting

I want to develop a macro that ...READ MORE

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

Too Many Different Cell Formats

Cell formats are challenging. There isn't actually ...READ MORE

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

Excel formula converting tan to angle

I have an excel spreadsheet that computes ...READ MORE

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

Convert Excel and Word files to PDF Using ruby

 You can combine some: For excel files - ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 86,360 points • 2,495 views
0 votes
1 answer

How to recover corrupted excel file

If it were just corrupted then you ...READ MORE

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

Online MYSQL editor as an Excel-like spreadsheet

That depends on who are those users, ...READ MORE

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

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 2,576 views
0 votes
1 answer

If Statement Not Working When Including Cells That Have Formulas

Try:  =IF(VALUE(A1)>10;1;0) I hope this helps you. READ MORE

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

SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

Here is the Microsoft article regarding co-authoring https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US When ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 2,122 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.