# Search:

Type: Posts; User: AhoyNC; Keyword(s):

Page 1 of 6 1

1. ## Thread: IF statement to check for value in range and if true include adjacent value in SUM

by AhoyNC
Replies
1
Views
104

### Re: IF statement to check for value in range and if true include adjacent value in SUM

See if this works for you.
Copy formula down and across.

<b>List and Totals</b><br /><br /><table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
2. ## Thread: Reverse VLOOKUP? INDEX - MATCH?

by AhoyNC
Replies
3
Views
144

### Re: Reverse VLOOKUP? INDEX - MATCH?

You're welcome. Thanks for the feedback and welcome to the forum.
3. ## Thread: Reverse VLOOKUP? INDEX - MATCH?

by AhoyNC
Replies
3
Views
144

### Re: Reverse VLOOKUP? INDEX - MATCH?

Maybe something like this. Copy formulas down as needed.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
4. ## Thread: working with times and dates

by AhoyNC
Replies
3
Views
101

### Re: working with times and dates

Something like this?

5. ## Thread: sum ifs + index match

by AhoyNC
Replies
1
Views
74

### Re: sum ifs + index match

Here is one way with SUMPRODUCT. Copy formula down and across as needed.
You may also want to look at a pivot table.

6. ## Thread: Index and match with large function

by AhoyNC
Replies
6
Views
179

### Re: Index and match with large function

You're welcome. Thanks for the feedback.
7. ## Thread: Index and match with large function

by AhoyNC
Replies
6
Views
179

### Re: Index and match with large function

See if this works for you.

<colgroup><col style="width:30px; "><col style="width:133px;"><col style="width:107px;"><col style="width:64px;"><col style="width:64px;"><col...
8. ## Thread: SUMIF - dates, ignore times?

by AhoyNC
Replies
4
Views
91

### Re: SUMIF - dates, ignore times?

Maybe another option to use SUMPRODUCT:

9. ## Thread: Why this Match is not working, FILE ATTACHED

by AhoyNC
Replies
4
Views
78

### Re: Why this Match is not working, FILE ATTACHED

Another option if you have Excel 2010 or later:
This does not require CSE just ENTER.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt;...
10. ## Thread: Max If formula - where am I going wrong

by AhoyNC
Replies
3
Views
157

### Re: Max If formula - where am I going wrong

Probably need to clarify what you mean by gone wrong.
Are you getting an error msg., wrong answer?
11. ## Thread: Average Array Formula Help

by AhoyNC
Replies
2
Views
153

### Re: Average Array Formula Help

Try:

=IFERROR(ArrayFormula(AVERAGE(IF((Orders!\$F:\$F>=C\$1)*(Orders!\$F:\$F<=(D\$1-(1/86400))),Orders!\$F:\$F-Orders!\$E:\$E))),"")
12. ## Thread: Number vs text format using MATCH function

by AhoyNC
Replies
2
Views
160

### Re: Number vs text format using MATCH function

Maybe something like this.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
13. ## Thread: Help with Nested IF function

by AhoyNC
Replies
3
Views
103

### Re: Help with Nested IF function

You're welcome. Thanks for the feedback.
14. ## Thread: Help with Nested IF function

by AhoyNC
Replies
3
Views
103

### Re: Help with Nested IF function

Try using VLOOKUP

15. ## Thread: Values only once when multiple values

by AhoyNC
Replies
7
Views
138

### Re: Values only once when multiple values

Here is another link using a formula.
16. ## Thread: Excel stats verses Matlab, R and Python

by AhoyNC
Replies
1
Views
557

### Re: Excel stats verses Matlab, R and Python

Here are some links explaining the difference between R and Excel.
I personally prefer R over Excel for statistical work. As stated in the links below R does have a steep learning curve.

...

by AhoyNC
Replies
10
Views
343

Try:

18. ## Thread: Index Match Formula

by AhoyNC
Replies
8
Views
275

### Re: Index Match Formula

You could put a boarder around a small part of your file and use copy/paste to paste it to the forum. Are the examples I gave above close to what you have?
19. ## Thread: Index Match Formula

by AhoyNC
Replies
8
Views
275

### Re: Index Match Formula

Maybe like this.
If your dates in LXD are actual Excel dates (numeric) then you could use the SUMPRODUCT formula.
Formula in O82 will work if dates are text or numeric.

<b>Sheet1</b><br /><br...
20. ## Thread: Index Match Formula

by AhoyNC
Replies
8
Views
275

### Re: Index Match Formula

You mean something like this?
This assumes there is only one unique match.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
21. ## Thread: Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

by AhoyNC
Replies
4
Views
171

### Re: Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

Maybe something like this.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
22. ## Thread: Math + excel formula

by AhoyNC
Replies
5
Views
199

### Re: Math + excel formula

You're welcome. This link should help explain the formula (starting at about the 4:40 mark).

23. ## Thread: Math + excel formula

by AhoyNC
Replies
5
Views
199

### Re: Math + excel formula

Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER.

<table border="0" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
24. ## Thread: Stuck: Compare worksheet value and output to new file with unchanged AND changed values

by AhoyNC
Replies
1
Views
59

### Re: Stuck: Compare worksheet value and output to new file with unchanged AND changed values

This link will show how to merge the lists without duplicates.
https://www.get-digital-help.com/2009/06/16/extract-an-unique-distinct-list-from-two-columns-using-excel-2007-array-formula/

Another...
25. ## Thread: return text after 2nd occurrence of an equal sign (=)

by AhoyNC
Replies
7
Views
195

### Re: return text after 2nd occurrence of an equal sign (=)

With a formula.