# Search:

Type: Posts; User: Aladin Akyurek; Keyword(s):

1. ## Thread: Formula for multiple conditon

Replies
1
Views
118

### Re: Formula for multiple conditon

Would you post 5 rows from that separate table?
2. ## Thread: Excel formula if number between two values return different values

Replies
4
Views
145

### Re: Excel formula if number between two values return different values

Something like:

=LOOKUP(D3,{0,3.6,7.5,11.01},{1,0.6,0.4,"?"})
3. ## Thread: Display a list only with the values by country

Replies
9
Views
235

### Re: Display a list only with the values by country

In C18 control+shift+enter, not just enter, and copy down:
...

Replies
4
Views
194

### Re: Modifying a (sum, indirect, substitute, address, column), formula?

In S1 enter and copy across:

=LOOKUP(9.99999999999999E+307,\$A\$1:A1)

which is faster.

Replies
4
Views
252

### Re: Is there a SUM-minus formula instead of SUMPRODUCT?

Control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(A2:A5*B2:B5),B2:B5-A2:A5))
6. ## Thread: sumif or sumproduct based on current month and year

Replies
14
Views
725

### Re: sumif or sumproduct based on current month and year

You are welcome.

Could you custom format the result cell (the formula cell) for example as:

#,##0.00_);(#,##0.00)
7. ## Thread: sumif or sumproduct based on current month and year

Replies
14
Views
725

### Re: sumif or sumproduct based on current month and year

Control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(V:V),IF((MONTH(V:V)=8)*(YEAR(V:V)=2019)*ISNUMBER(SEARCH("paypal credit",P:P)),AI:AI)))
8. ## Thread: sumif or sumproduct based on current month and year

Replies
14
Views
725

### Re: sumif or sumproduct based on current month and year

Which column is it and what is the text you are looking for?
9. ## Thread: Excel Multiple Search and return Non Array formula

Replies
17
Views
493

### Re: Excel Multiple Search and return Non Array formula

That's right. Sort D:E together, ascending on D.
10. ## Thread: Return column of far most right value in a row

Replies
9
Views
392

### Re: Return column of far most right value in a row

If A1:Z1 is numeric:

=LOOKUP(9.99999999999999E+307,A1:Z1)

If A1:Z1 is text:

=LOOKUP(REPT("z",255),A1:Z1)

If A1:Z1 may house any value including blanks:
11. ## Thread: Excel Multiple Search and return Non Array formula

Replies
17
Views
493

### Re: Excel Multiple Search and return Non Array formula

Sort D:E in ascending order on column E...

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
12. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
22
Views
42,458

### Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Either: Control+shift+enter, not just enter...

=TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH(List,\$A2)),List,""),"")

Or, if you don't have TEXTJOIN on your Excel version, let's try the following:

...

Replies
27
Views
938

### Re: AverageIfs Complexity

You need to apply control+shift+enter at the same time.

Replies
27
Views
938

### Re: AverageIfs Complexity

Control+shift+enter, not just enter:

=AVERAGE(IF(LEFT(\$B\$2:\$B\$150,1)+0=3,\$G\$2:\$G\$150))
15. ## Thread: Help unstanding this formula?

Replies
1
Views
217

### Re: Help unstanding this formula?

Try to test with a smaller data area, say, A1:D5, on Sheet1. Enter some data in A1:D5 and also some small numbers in F. Enter the adjusted formula in G1 as:
...
16. ## Thread: sumif or sumproduct based on current month and year

Replies
14
Views
725

### Re: sumif or sumproduct based on current month and year

1. Control+shift+enter is an Excel requirement for signaling Excel that the formula in question is an array-processing formula. Excel's calculation treats such formulas differently (qua algorithms it...
17. ## Thread: How to always Reference Cell even if deleted?

Replies
12
Views
3,834

### Re: How to always Reference Cell even if deleted?

Try:

=IF(ISNUMBER(INDIRECT("C14")),EOMONTH(INDIRECT("C14"),0),"no date")
18. ## Thread: Vlookup on multiple matches

Replies
2
Views
210

### Re: Vlookup on multiple matches

The desired output does not seem to show any structure. If thi observation is correct, any random output should be acceptable for a given look up value!
19. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
22
Views
42,458

### Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Please try to continue this one in https://www.mrexcel.com/forum/excel-questions/893600-extract-multiple-keywords-text-string-3.html. Thank you.
20. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
22
Views
42,458

### Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

You are welcome.
21. ## Thread: sumif or sumproduct based on current month and year

Replies
14
Views
725

### Re: sumif or sumproduct based on current month and year

Control+shift+enter, not just enter:

=
SUM(IF(ISNUMBER(V:\$V),IF((MONTH(V:\$V)=8)*(YEAR(V:\$V)=2019),AI:\$AI)))
22. ## Thread: Array Formula to Remove Zero Value Rows

Replies
14
Views
16,662

### Re: Array Formula to Remove Zero Value Rows

Try to provide a small input sample along with the output which must obtain from that sample.
23. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
22
Views
42,458

### Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
24. ## Thread: Formula to Create a List from and Existing List ignoring zero values

Replies
9
Views
5,928

### Re: Formula to Create a List from and Existing List ignoring zero values

You are welcome.

Replies
5
Views
454

### Re: Return Multiple Column headings in a single Cell

Excel 2013 does not have the TEXTJPOIN function, hence the #NAME ? error. Try the following instead...

Add the following VBA code to your workbook as a module, using Alt+F11...

Function...
Results 1 to 25 of 150
Page 1 of 6 1