Trending questions in Others

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
• 86,360 points
2,115 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
• 86,360 points
1,567 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
• 86,360 points
1,847 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
• 86,360 points
1,552 views
0 votes
1 answer

Embedding an excel document into an application with excel online

You have to do the heavy lifting ...READ MORE

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

Excel Tax Calculator

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

Oct 15, 2022 in Others by narikkadan
• 86,360 points
1,282 views
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
• 24,280 points

edited Mar 4, 2025 427 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Looks like you could use: The formula in D2: =SUBSTITUTE(F ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
2,145 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
• 86,360 points
1,042 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
• 86,360 points
1,867 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
• 86,360 points
1,191 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

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

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

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

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 86,360 points
1,939 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
• 24,280 points
2,152 views
0 votes
1 answer

Opening Selected Hyperlink DISPLAYING TEXT in Default Browser in MS Excel

Try this code: Sub Open_SelectedTextlinks() If Not ...READ MORE

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

How to link two min max sliders with swiftui iOS15

I see you asked it a long ...READ MORE

Sep 22, 2022 in Others by rajatha
• 7,680 points
2,151 views
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

Try this: =INDIRECT("Sheet1!C"&ROW()) READ MORE

Oct 10, 2022 in Others by narikkadan
• 86,360 points
1,356 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, 2025 437 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
• 86,360 points
1,423 views
0 votes
1 answer

ios: localize emoji name (kCFStringTransformToUnicodeName)

There is no api for this job. Unicode ...READ MORE

Sep 21, 2022 in Others by rajatha
• 7,680 points
2,126 views
0 votes
1 answer

Split text cells in 70 character chunks in Excel

You can do this using Power Query Data ...READ MORE

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

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

Sep 27, 2022 in Others by narikkadan
• 86,360 points
1,901 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, 2025 447 views
0 votes
1 answer

Excel vba domdocument parsing xml from TNT tracking system: in some pcs object load return no document

This error is related to something in ...READ MORE

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

How to compress Excel buffer into ZIP buffer?

The problem is that something you're using ...READ MORE

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

Unhide rows in Excel with VBA

Paste this code into a module of ...READ MORE

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

Navigate Excel Drop-Down List via Keyboard

You are aware of the auto-complete feature ...READ MORE

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

How can I open a URL in Android's web browser from my application?

ry this: Intent browserIntent = new Intent(Intent.ACTION_VIEW, Uri ...READ MORE

Jun 14, 2022 in Others by polo
• 1,480 points
6,363 views
0 votes
1 answer

lookup Data in Excel

Without VBA, it can be done in ...READ MORE

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

Calculate age in excel

Write =Today-C3 and then press Ctrl+1 and select Number for the format.  Or try ...READ MORE

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

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

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

Goal Seek in Excel

The pmt function we are using, which ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
1,717 views
0 votes
0 answers

Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

from instabot import Bot import openpyxl import smtplib bot = ...READ MORE

Sep 26, 2022 in Others by Kithuzzz
• 38,000 points
1,862 views
0 votes
1 answer

Creating a chart in VBA with 2 different Types

Can you carry this out by hand ...READ MORE

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

Excel - add all X in column and then multiply

Use countif for the count then multiply ...READ MORE

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

what is microsoft azure used for?

Microsoft Azure is used as a cloud ...READ MORE

Jun 21, 2023 in Others by Khan Sarfaraz
• 700 points
1,417 views
0 votes
1 answer

Convert PDF into excel data

To convert data from an image in ...READ MORE

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

Export csv separated by columns

Define FileFormat as xlText and the file will be TAB delimited, ...READ MORE

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

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

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

Excel 2013 - using Boolean logical functions

If p is stored in A1 and ...READ MORE

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

Chart Name in Excel 2016

When you select the chart, it's now ...READ MORE

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

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

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

iOS Keyboard Extension: Memoji like paste

All the mentioned apps use UITextView, upon ...READ MORE

Sep 21, 2022 in Others by rajatha
• 7,680 points
1,959 views
0 votes
1 answer

Trouble with excel macros (possibly encoding?)

To solve your issue: Replace your macro names ...READ MORE

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

MS Excel - Concat with a delimiter

Use TEXTJOIN() instead: =TEXTJOIN(";",TRUE,A1:A2000) I hope this ...READ MORE

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

Batch generate merged .jpg from excel data sheet

Refer to this blog and follow the ...READ MORE

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

Can I use VBA in Excel 2010 Starter Edition?

No, unfortunately you can't use VBA in ...READ MORE

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

How to select random value from iOS picker wheel using Selenium

Two ways to do this : Randomise the UIAPickerWheel[1] index ...READ MORE

Sep 21, 2022 in Others by rajatha
• 7,680 points
1,935 views
0 votes
1 answer

Creating macro in excel

The Macro Recorder is used to record ...READ MORE

Oct 11, 2022 in Others by narikkadan
• 86,360 points
1,084 views