# Search:

Type: Posts; User: Marcelo Branco; Keyword(s):

Page 1 of 6 1

1. ## Thread: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

by Marcelo Branco
Replies
10
Views
117

### Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

Maybe something like this...

A
B
C
D
E
F
2. ## Thread: Defining an Array Within a Formula

by Marcelo Branco
Replies
3
Views
76

### Re: Defining an Array Within a Formula

You are welcome. Glad to help.

M.
3. ## Thread: Defining an Array Within a Formula

by Marcelo Branco
Replies
3
Views
76

### Re: Defining an Array Within a Formula

To create a vertical array with 5 single results you can try something like

CHOOSE({1;2;3;4;5},result1,result2,result3,result4,result5)

M.
4. ## Thread: If, and, or

by Marcelo Branco
Replies
4
Views
71

### Re: If, and, or

Maybe this array formula...

=AND(B3="V",SUM(IF(MOD(COLUMN(AF3:AX3)-COLUMN(AF3)+1,2)=1,IF(AF3:AX3="B",IF(ABS(Q3-AQ3:BI3)<=2.25,1))))>0)
confirmed with Ctrl+Shift+Enter, not just Enter

M.
5. ## Thread: Sum numbers in cell seperated by a comma

by Marcelo Branco
Replies
8
Views
162

### Re: Sum numbers in cell seperated by a comma

You are welcome. Thanks for the feedback.

M.
6. ## Thread: Sum numbers in cell seperated by a comma

by Marcelo Branco
Replies
8
Views
162

### Re: Sum numbers in cell seperated by a comma

Maybe this...

A
B

1
Text
Sum
7. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
390

### Re: Issue with rank formula

If the cities are grouped and there are no blank rows in the middle, maybe this simpler array formula

A
B
C
D
E
8. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
390

### Re: Issue with rank formula

This scenario - multiple cities with the same value and different ranks - and adding the possibility of blank cells, requires a complex array formula. Would this be convenient for you? Or would it...
9. ## Thread: Skills Matrix equation help

by Marcelo Branco
Replies
2
Views
61

### Re: Skills Matrix equation help

Maybe i'm not understanding what you need but it seems to me you can simply use
=(U8-14)*0.11

M.
10. ## Thread: Formulas to count including Unique Numbers

by Marcelo Branco
Replies
42
Views
2,325

### Re: Formulas to count including Unique Numbers

To use an OR condition in an array formula you should add the conditions, for example
...
11. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
390

### Re: Issue with rank formula

Result #N/A???? Don't understand how a formula using SUMPRODUCT can generate such result :confused:, unless there are errors or blank rows in your data. Check.

Worked perfectly for me...

...
12. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
390

### Re: Issue with rank formula

Maybe...

E2 copied down...

by Marcelo Branco
Replies
2
Views
86

### Re: YTD Sum

Maybe

Project 7 Actual YTD
=SUMIFS(INDEX(\$C\$4:\$O\$11,MATCH(B14,B\$4:B\$11,0),0),C\$3:O\$3,"<="&B\$3)
where B14 = Project 7

Project 3 Budget YTD...
14. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
143

### Re: Moving Match formula

You are welcome. Thanks for the feedback.

By the way, a more robust formula (it handles non-existent items)

C9 copied down...
15. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
143

### Re: Moving Match formula

This is a different requirement :confused:
What really do you want? Item A Band 2 or Band 3?

M.
16. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
143

### Re: Moving Match formula

Maybe something like this...

<tbody>

A
17. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
212

### Re: MIN & MAX Formula with Multiple Variables

Maybe something like this

Sheet1

<tbody>

A
18. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
212

### Re: MIN & MAX Formula with Multiple Variables

Are the dates m/d/yy or d/m/yy?

M.
19. ## Thread: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

by Marcelo Branco
Replies
10
Views
133

### Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

Then you should use the solution suggested above by Fluff or VBA. Unfortunately, as far as I know, a formula can't identify a colored cell.

M.
20. ## Thread: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

by Marcelo Branco
Replies
10
Views
133

### Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

What is the criterion (logic) that is used to manually color cells green? Greater than a certain value? Does it contain some keyword? Or any other criteria (?)
I believe they are not randomly...
21. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
212

### Re: MIN & MAX Formula with Multiple Variables

Could you provide the expected results and how do you want them displayed in Sheet3?

M.
22. ## Thread: Ranking with SUMPRODUCT to ignore blanks

by Marcelo Branco
Replies
33
Views
9,189

### Re: Ranking with SUMPRODUCT to ignore blanks

You are welcome. Glad to help.

M.
23. ## Thread: Ranking with SUMPRODUCT to ignore blanks

by Marcelo Branco
Replies
33
Views
9,189

### Re: Ranking with SUMPRODUCT to ignore blanks

Something like this

A
B
C
D
E
F
24. ## Thread: Ranking with SUMPRODUCT to ignore blanks

by Marcelo Branco
Replies
33
Views
9,189

### Re: Ranking with SUMPRODUCT to ignore blanks

I'm not seeing your data...Try posting some rows with the relevant columns of the table along with expected results

M.
25. ## Thread: Countif but filter the number of customers...

by Marcelo Branco
Replies
2
Views
73

### Re: Countif but filter the number of customers...

Maybe something like this

D
E
F
G

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