# Search:

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

Page 1 of 6 1

## Search: Search took 0.42 seconds.

by Marcelo Branco
Replies
9
Views
220

### Re: Vlookup not working and it's driving me MAD!!!

See if this helps
https://www.contextures.com/xlFunctions02.html#trouble

M.
2. ## Thread: inventory values to update

by Marcelo Branco
Replies
3
Views
46

### Re: inventory values to update

You are welcome. Thanks for the feedback.

M.
3. ## Thread: inventory values to update

by Marcelo Branco
Replies
3
Views
46

Maybe...

A
B
C
D
E
F
4. ## Thread: SUMIFS Across Rows with Multiple Criteria

by Marcelo Branco
Replies
2
Views
39

### Re: SUMIFS Across Rows with Multiple Criteria

Welcome to Mr Excel Forum

Dates as mm/dd/yyyy

A
B
C
D
E
5. ## Thread: Formulas to count including Unique Numbers

by Marcelo Branco
Replies
45
Views
2,382

### Re: Formulas to count including Unique Numbers

Graham,

This thread is getting too long...
New data? I suggest you create a new thread - new data sample along with expected results.

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

by Marcelo Branco
Replies
11
Views
195

### 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
7. ## Thread: Defining an Array Within a Formula

by Marcelo Branco
Replies
3
Views
86

### Re: Defining an Array Within a Formula

You are welcome. Glad to help.

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

by Marcelo Branco
Replies
3
Views
86

### 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.
9. ## Thread: If, and, or

by Marcelo Branco
Replies
4
Views
81

### 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.
10. ## Thread: Sum numbers in cell seperated by a comma

by Marcelo Branco
Replies
8
Views
170

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

You are welcome. Thanks for the feedback.

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

by Marcelo Branco
Replies
8
Views
170

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

Maybe this...

A
B

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

by Marcelo Branco
Replies
11
Views
407

### 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
13. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
407

### 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...
14. ## Thread: Skills Matrix equation help

by Marcelo Branco
Replies
2
Views
64

### 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.
15. ## Thread: Formulas to count including Unique Numbers

by Marcelo Branco
Replies
45
Views
2,382

### Re: Formulas to count including Unique Numbers

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

by Marcelo Branco
Replies
11
Views
407

### 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...

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

by Marcelo Branco
Replies
11
Views
407

### Re: Issue with rank formula

Maybe...

E2 copied down...

by Marcelo Branco
Replies
2
Views
100

### 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...
19. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
154

### 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...
20. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
154

### Re: Moving Match formula

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

M.
21. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
154

### Re: Moving Match formula

Maybe something like this...

<tbody>

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

by Marcelo Branco
Replies
10
Views
220

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

Maybe something like this

Sheet1

<tbody>

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

by Marcelo Branco
Replies
10
Views
220

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

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

M.
24. ## 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
137

### 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.
25. ## 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
137

### 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...
Results 1 to 25 of 150
Page 1 of 6 1