Most viewed questions in Others

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 • 327 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 • 327 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 • 326 views
0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

That's because you formatted the output using ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,010 points • 326 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 • 326 views
0 votes
1 answer

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

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

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,700 points • 326 views
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 • 326 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 • 326 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 • 326 views
0 votes
1 answer

Export Attachment from outlook to excel cells

You will need to save the attachment ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 63,700 points • 325 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 • 325 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 • 325 views
0 votes
1 answer

Excel Date separate with =DAY(), =MONTH() and =YEAR()

If it must be done inside of ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 63,700 points • 324 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 • 324 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 • 324 views
0 votes
0 answers

I am getting this data from my server

May 29, 2019 in Others by anonymous
 • 324 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 • 323 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 • 323 views
0 votes
1 answer

Index and Match multiple matches

You can try the following (formula 1) ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,700 points • 322 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 • 322 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

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

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

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

what is socket.io?

Jul 17, 2019 in Others by shubham
 • 7,340 points • 322 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 • 321 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 • 321 views
0 votes
0 answers

explain what access modifier can be used for method

Sep 10, 2019 in Others by anonymous
 • 321 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 • 320 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 • 320 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 • 320 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 • 320 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 • 320 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 • 320 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 • 319 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 • 319 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 • 319 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 • 319 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 • 318 views
0 votes
1 answer

Excel Formula - Calculating Total Percentage

You just need the AVERAGE of all ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,700 points • 318 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 • 318 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 • 317 views
0 votes
1 answer

Does AMP validation error affect SEO result?

if there is not a valid amp ...READ MORE

Feb 14, 2022 in Others by narikkadan
 • 63,700 points • 317 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 • 316 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 • 316 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 • 315 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 • 315 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
 • 63,700 points • 315 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 • 314 views
0 votes
1 answer

Excel sum formula without table - Equivalent to the Math Sum Symbol

You can use SUMPRODUCT for this. Assuming X is in cell B1, ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 63,700 points • 314 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.