Trending questions in Others

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,497 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
• 23,580 points

edited Mar 4, 2025 381 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,486 views
0 votes
2 answers

How do you close/hide the Android soft keyboard programmatically?

The solution that I can think of ...READ MORE

Feb 23, 2022 in Others by Soham
• 9,730 points
11,269 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,224 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,806 views
0 votes
0 answers

What is the relationship between iostream and namespace std?

I am currently using Teach Yourself C++ in ...READ MORE

Sep 22, 2022 in Others by gaurav
• 23,580 points
2,171 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
976 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,068 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,131 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,799 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,198 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,618 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,580 points
2,096 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,086 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,844 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,444 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 387 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,370 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,273 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,635 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 393 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,054 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
1,998 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,821 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,645 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,232 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,276 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,058 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,528 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,565 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,647 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,143 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,258 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,781 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
934 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,355 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,457 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,529 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
935 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,230 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,620 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,723 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,462 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,088 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,177 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,034 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,866 views
0 votes
1 answer

Change the size of one cell in excel 2016

I'm sorry, but it's not feasible. A ...READ MORE

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

How to trigger Excel AutoFill using power Automate?

In PAD you may want copy the ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 86,360 points
1,548 views