Trending questions in Others

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
 • 63,600 points • 731 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
 • 63,600 points • 998 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 • 719 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 • 719 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
 • 63,600 points • 1,506 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 • 522 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 • 552 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 • 401 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 • 558 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,264 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 • 589 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,076 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,502 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 • 577 views
0 votes
1 answer

Transposing columns to rows in Excel

Due to the amount of your data, ...READ MORE

Oct 1, 2022 in Others by narikkadan
 • 63,600 points • 1,157 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 • 697 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 • 864 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,386 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 • 753 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,334 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,069 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,176 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 • 6,773 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 • 777 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,354 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,129 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,258 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,080 views
0 votes
0 answers

Unable to add window -- token null is not valid; is your activity running?

I am trying to put a feature ...READ MORE

May 18, 2022 in Others by Kichu
 • 19,040 points • 6,941 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,418 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 • 707 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
 • 63,600 points • 706 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 • 700 views
0 votes
1 answer

iOS Post to Facebook shows m.facebook.com

From your Feed, tap Search Facebook at ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,260 points • 473 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,349 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
 • 63,600 points • 409 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 • 947 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,287 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,276 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,228 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
 • 63,600 points • 724 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,001 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 902 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,326 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
 • 63,600 points • 572 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
 • 63,600 points • 390 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 • 960 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
 • 63,600 points • 543 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 • 1,405 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
 • 63,600 points • 989 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.