Most viewed questions in Others

0 votes
1 answer

Count cells in excel with populated values

Use: =SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<> ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,700 points • 338 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
 • 63,700 points • 338 views
0 votes
0 answers

what is socket.io?

Jul 17, 2019 in Others by shubham
 • 7,340 points • 338 views
0 votes
1 answer

Loop through files using "" instead of Dir

Upon reading the documentation @Dir function (Visual ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,700 points • 337 views
0 votes
1 answer

Excel formula to average selected cells based on certain criteria

Try: =AVERAGE(IF(X:X=A1,Z:Z)) With Ctrl+Shift+Enter. READ MORE

Nov 13, 2022 in Others by narikkadan
 • 63,700 points • 337 views
0 votes
1 answer

Formula in criteria range in SUMIFS

No, that kind of manipulation doesn't work ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,700 points • 337 views
0 votes
0 answers

EC2 Ubuntu hangs on go install

I am running the golang rest API ...READ MORE

Apr 4, 2022 in Others by Kichu
 • 19,050 points • 337 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,010 points • 336 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,700 points • 336 views
0 votes
1 answer

Standard deviation only for data that meets two conditions in Excel

I would say: =STDEV.S(IF((A2:A11="A")*(B2:B11="Z1"),C2:C11,"")) ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,700 points • 336 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,700 points • 336 views
0 votes
0 answers

Date time convert in Replace activity in word document scope

we have input in excel  New date/Header 31/12/2020 31/12/2019 We  want ...READ MORE

Jun 22, 2020 in Others by Sapna
 • 120 points
recategorized Jun 22, 2020 by Gitika • 336 views
0 votes
1 answer

Count Function for identifying the Unique values in Excel

If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 63,700 points • 335 views
0 votes
1 answer

VBA to create a dynamic rolling list of names

If I understand you correctly, a case. ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 63,700 points • 335 views
0 votes
1 answer

array of LocalBusinessJsonLd Schema using next-seo

" If your page requires multiple instances of ...READ MORE

Feb 24, 2022 in Others by narikkadan
 • 63,700 points • 335 views
0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Try this: Sub IFSomething() With ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,700 points • 334 views
0 votes
1 answer

Excel Lookup function for text

Use a simple VLOOKUP() function like: =VLOOKUP(E2,$A$2:$B$6,2,FALSE) You can also use ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 63,700 points • 334 views
0 votes
0 answers

How to build a font generator in iOS Swift and allowing pasting to clipboard

I'm now building a listview to display ...READ MORE

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

Arrange charts position in 3x5 order

Your code was nearly complete. I believed ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 63,700 points • 333 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

For Excel 2019 and above use TEXTJOIN ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 63,700 points • 333 views
0 votes
1 answer

Is there a way to transfer MSWord numbering bullets to MSExcel column?

Your numbered bullets can be copied from ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 63,700 points • 333 views
0 votes
1 answer

How to calculate percentage of an autosum field in excel

The fact that I was using the ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 63,700 points • 333 views
0 votes
1 answer

Nokia Lumia 920 Excel not open

The issue is with your code, not ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,700 points • 333 views
0 votes
0 answers

jQuery disable/enable submit button

I want to do something like this: When ...READ MORE

May 2, 2022 in Others by Kichu
 • 19,050 points • 333 views
0 votes
1 answer

Why is just an ID in the URL path a bad idea for SEO?

yes it affects the click through rates ...READ MORE

Feb 20, 2022 in Others by narikkadan
 • 63,700 points • 332 views
0 votes
1 answer

What are the important meta tags I must put in my website? [closed]

Regular meta info <title>{{pageTitle}}</title> <meta charset="utf-8"><!-- html5 version ...READ MORE

Feb 11, 2022 in Others by narikkadan
 • 63,700 points • 332 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

All you have to do is copy ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,700 points • 331 views
0 votes
1 answer

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,700 points • 331 views
0 votes
1 answer

Program that works in all version of excel

Knowing that all of your users will ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 63,700 points • 331 views
0 votes
0 answers

Android app icon not showing in samsung galaxy gear s3 frontier notification

I created an android application and it ...READ MORE

Apr 11, 2022 in Others by Kichu
 • 19,050 points • 331 views
0 votes
1 answer

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 63,700 points • 330 views
0 votes
1 answer

VBA Comment Format

Let's say you're having trouble referencing every ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 63,700 points • 330 views
0 votes
1 answer

How to sum the value of 2 rows with vlookup by only using 1 formula?

 Try in Excel Online: • Formula used in cell C3 =SUM(SCAN(0,M3:N3,LAMBDA(x,y,VLOOKUP(y,P3:Q12,2,0)))) Works ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 63,700 points • 330 views
0 votes
1 answer

1-step shortcut to delete entire row in excel 2016

Highlight the whole row by clicking on ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,700 points • 330 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 • 330 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,700 points • 329 views
0 votes
1 answer

How many sheets are there in Excel Workbook by default?

It is 3. As stated officially by ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,700 points • 329 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
 • 23,260 points • 329 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
 • 63,700 points • 329 views
0 votes
1 answer

Trying to redo my Export Button Function on my document

You could directly publish the data to ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 63,700 points • 328 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 328 views
0 votes
0 answers

explain what access modifier can be used for method

Sep 10, 2019 in Others by anonymous
 • 328 views
0 votes
1 answer

Excel - count if multiple words are in a cell

Try this using wildcards * with TEXTBEFORE()&nb ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
 • 38,010 points • 327 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 63,700 points • 327 views
0 votes
0 answers

Why AWS recommends to avoid the use of public/internet gateways in favor of AWS PrivateLink and VPC endpoints?

A VPC endpoint enables connections between a ...READ MORE

Mar 1, 2022 in Others by Edureka
 • 13,670 points • 327 views
0 votes
1 answer

What are canonical URLs and how do they affect your SEO?

canonical URLs are distinct URL used to ...READ MORE

Feb 11, 2022 in Others by narikkadan
 • 63,700 points • 327 views
0 votes
0 answers

Write a DAX query to obtain the bottom 5 customers based on the order price

Jan 22, 2020 in Others by anonymous
 • 170 points • 327 views
0 votes
0 answers

I am getting this data from my server

May 29, 2019 in Others by anonymous
 • 327 views
0 votes
1 answer

How to transpose data in an other tab in excel

If you're using a previous version of ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,010 points • 326 views
0 votes
1 answer

How can a column be set to display multiple spaces and tabs (white space) in a cell?

By entering your "code" in Word and ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 63,700 points • 326 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.