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,260 points
edited Mar 4 • 52 views
0 votes
1 answer

Excel VBA - Trouble importing WhatsApp chat history files into an Excel sheet

Since the OpenText method isn't working for ...READ MORE

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

Repeated Multiplication formula for Excel

Fun little problem using some basic maths: =A1*3^ROW(A1) READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,197 views
0 votes
0 answers

mysql said: Cannot connect: invalid settings. xampp

I changed the root password to test ...READ MORE

May 23, 2022 in Others by Kichu
 • 19,040 points • 7,179 views
0 votes
1 answer

VBA to unhide a column when opening a workbook

Use the workbook_open even within ThisWorkbook. READ MORE

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

Excel VBA Worksheet Range storage location best practices

Solution Changing Worksheets' Code Name Why dim srcSheet as myWorksheet when ...READ MORE

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

How to open an Excel Online document as a PDF

In light of your comment above, I ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 710 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
 • 63,600 points • 1,495 views
0 votes
1 answer

Counting distinct values in excel - frequency function

You can use COUNTIF to count the ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 606 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
 • 63,600 points • 1,745 views
0 votes
0 answers

What is the difference between iostream , stdio.h and conio.h header files in c++?

I am confused between all these three ...READ MORE

Sep 23, 2022 in Others by gaurav
 • 23,260 points • 1,782 views
0 votes
1 answer

React Native and iOS share button

In this article, we will be learning ...READ MORE

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

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

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

Is there a way to generate high resolution PNGs of iOS emoji?

Step 1: Visit Google Play Store on ...READ MORE

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

VBA, Query Vertica database and populate to excel

You can query Vertica directly from excel. I ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,669 views
0 votes
1 answer

Excel use SUMIF but with a multiplier before summation: x2, x3, x4, etc

The product of the sum and the ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,450 views
0 votes
1 answer

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 694 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
 • 63,600 points • 1,657 views
0 votes
1 answer

I have a problem with counta function in VBA

When the worksheet name has a space, ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 1,307 views
0 votes
2 answers

Excel VBA App stops spontaneously with message "Code execution has been halted"

Solution Press the "Debug" button in the popup. Press Ctrl+Pause|Break twice. Hit ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 1,455 views
0 votes
0 answers

how can i check the existance of new file in a ftp server every given period ?

I have to download a file from ...READ MORE

Oct 31, 2022 in Others by Imene
edited Mar 4 • 58 views
0 votes
1 answer

Excel Tax Calculator

You can replace it with a set ...READ MORE

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

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 906 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
 • 63,600 points • 10,636 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

select A1:J1 in worksheet B and enter: =TRANSPOSE('worksheet ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,605 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
 • 63,600 points • 1,561 views
0 votes
0 answers

How to configure Nginx with tomcat docker container

Hi all, how can I configure nginx proxy ...READ MORE

Oct 30, 2022 in Others by Erica
edited Mar 4 • 65 views
0 votes
0 answers

why is react native video not working on android, but working on ios?

installed react video v. 5.2.0 but an error ...READ MORE

Sep 23, 2022 in Others by gaurav
 • 23,260 points • 1,675 views
0 votes
1 answer

Excel - IFERROR Function

Use: =IF(ISNUMBER(FIND("Bob",A2)),"Other",A2) Remember FIND is an exact match while SEARCH does not care ...READ MORE

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

Show tick symbol on label

Try this code: LblTick.Text = ((char)0x221A).ToString(); Easier method: lblTick.Text ...READ MORE

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

In Excel, how to find a average from selected cells

If one has the dynamic array formula ...READ MORE

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

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,663 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

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

How to define excel SUMIFS criteria considering any text and numbers?

It essentially ignores column C's missing entry ...READ MORE

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

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

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

aws s3 replace file atomically

Simply upload your new file on top ...READ MORE

Mar 24, 2022 in Others by gaurav
 • 23,260 points • 9,564 views
0 votes
1 answer

Authenticate to Google Drive and download spreadsheet with Python urllib2/requests

Your goal may be feasible, but the ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 1,464 views
0 votes
1 answer

Is there a way to SUMIFS with multiple criteria + true or false?

You can add this as the  last criteria: =SUMIFS(STORE!$C$6:$C$1000;STORE!$A$6:$A$1000;""&SUMMARY!$D$5&"";STORE!$D$6:$D$1000;""&SUMMARY!$C$9&"";STORE!$E$6:$E$1000;""&SUMMARY!D8&"";STORE!$AA$6:$AA$1000;TRUE) STORE!$AA$6:$AA$1000: ...READ MORE

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

Excel - compound interest with continuing contribution

The FV() formula would be what you're looking for. =FV(10%,35,-10000) There ...READ MORE

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

VBA Code to Populate Balance Sheet from Trial Balance Data

It appears that what you need to ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,600 points • 1,566 views
0 votes
1 answer

Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,603 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

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

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

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

Convert csv- or Excel-file (xlsx) to kml with custom markers

With some help from the community, I ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,466 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,453 views
0 votes
1 answer

How to convert PDF to Excel in C#?

Solutions a) xodo makes a free online conversion from PDF ...READ MORE

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

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,277 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 63,600 points • 1,641 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,477 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.