Trending questions in Others

0 votes
2 answers

Code for download video from Youtube on Java, Android

Check the source code (HTML) of YouTube, ...READ MORE

Jun 9, 2022 in Others by nisha
• 2,210 points
• 7,876 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,694 views
0 votes
1 answer

How to export data with functions to another workbook in excel

The issue appears to be that once ...READ MORE

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

Excel TRIM Function Bug

Line feed (ascii 10), it appears, is ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 86,360 points
• 1,472 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
• 2,154 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,950 views
0 votes
0 answers

How to use Excel VLOOKUP function with words that begin with the letters AB

For title naming, I have a list ...READ MORE

Nov 24, 2022 in Others by Kithuzzz
• 38,000 points

edited Mar 4, 2025 • 674 views
0 votes
1 answer

Understanding How Excel Processes Array Functions

An array formula is a formula that can ...READ MORE

Nov 8, 2022 in Others by gaurav
• 25,250 points
• 1,318 views
0 votes
1 answer

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

Oct 14, 2022 in Others by narikkadan
• 86,360 points
• 2,398 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
• 2,079 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, 2025 • 553 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
• 86,360 points
• 3,192 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
• 3,274 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
• 2,373 views
0 votes
1 answer

Excel - Unable to open https// <<PATH>> Cannot download the information you requested ---- How to disable

You can find the answer to your ...READ MORE

Oct 30, 2022 in Others by narikkadan
• 86,360 points
• 1,684 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
• 2,074 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
• 2,242 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,627 views
0 votes
1 answer

Many cells to a single reference in excel

Use conditional formatting to hide the A's ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 86,360 points
• 1,409 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
• 2,343 views
0 votes
1 answer

Excel VBA Rnd Not Actually Random

 Initialize the random number function. Sub test() Dim number ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 86,360 points
• 1,784 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,643 views
0 votes
1 answer

iPhone system font

The iPhone system interface uses Helvetica or ...READ MORE

Sep 20, 2022 in Others by Aditya
• 7,680 points
• 3,362 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,895 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
• 2,009 views
0 votes
1 answer

Auto fill in the blanks in Excel

Considering the information below: Step 1: Choose ...READ MORE

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

Print Excel Worksheet/Workbook

I'm attempting to make a C# Winform ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
• 1,578 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,739 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
• 2,129 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,922 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,646 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
• 3,084 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,536 views
0 votes
0 answers

I am doing the monataring tools setup using ansible

ERROR! the role 'prometheus' was not found ...READ MORE

Nov 23, 2022 in Others by ramanji

edited Mar 4, 2025 • 556 views
0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

Do columns C and D contain your ...READ MORE

Oct 18, 2022 in Others by narikkadan
• 86,360 points
• 2,081 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
• 2,412 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
• 25,250 points
• 1,340 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,792 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
• 12,223 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
• 2,096 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
• 1,404 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
• 2,839 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
• 3,008 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,560 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
• 2,465 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,540 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,408 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,775 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,553 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,589 views