# Search:

Type: Posts; User: Andrew Poulsom; Keyword(s):

Page 1 of 6 1

1. ## Thread: Help needed!!! Index or vlookup

by Andrew Poulsom
Replies
27
Views
1,081

### Re: Help needed!!! Index or vlookup

Just select your data and insert a Column Chart.
2. ## Thread: Hijra Date into Gregorian

by Andrew Poulsom
Replies
32
Views
51,328

### Re: Hijra Date into Gregorian

There is no built-in function to convert a Hijri date to Gregorian if that's what you mean. How did you enter the dates in column A? You can enter Hijri dates if the cell is formatted appropriately...
3. ## Thread: SUMIFS with IF function on sum_range

by Andrew Poulsom
Replies
29
Views
934

### Re: SUMIFS with IF function on sum_range

Check that column W doesn't contain any #N/A errors.

by Andrew Poulsom
Replies
16
Views
29,222

### Re: Putting an active link in HTMLBody in CDO

Welcome to MrExcel.

Have you tried using %20 instead of a space character?
5. ## Thread: SUMIFS with IF function on sum_range

by Andrew Poulsom
Replies
29
Views
934

### Re: SUMIFS with IF function on sum_range

SUMIFS will return #N/A the column to be summed contains one or more cells with that error.
6. ## Thread: Filter Pivot table based upon list using VBA

by Andrew Poulsom
Replies
18
Views
23,821

### Re: Filter Pivot table based upon list using VBA

I meant switch calculation to manual at the beginning of your code and back to automatic at the end.
7. ## Thread: Filter Pivot table based upon list using VBA

by Andrew Poulsom
Replies
18
Views
23,821

### Re: Filter Pivot table based upon list using VBA

I'm not sure what you mean by "this does not apply to me" but your VBA code looks fine.
8. ## Thread: Filter Pivot table based upon list using VBA

by Andrew Poulsom
Replies
18
Views
23,821

### Re: Filter Pivot table based upon list using VBA

Speed will depend on the number of Pivot Items in the Pivot Field. Have you set Calculation to manual?
9. ## Thread: Formula to return unique values in a range in alphabetical order?

by Andrew Poulsom
Replies
14
Views
25,543

### Re: Formula to return unique values in a range in alphabetical order?

The Evaluate Formula tool will show you how the formula works.
10. ## Thread: Sumif using 2D lookup?

by Andrew Poulsom
Replies
14
Views
4,625

### Re: Sumif using 2D lookup?

Example:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
11. ## Thread: SUMIFS with IF function on sum_range

by Andrew Poulsom
Replies
29
Views
934

### Re: SUMIFS with IF function on sum_range

Your formula sums column W if Cost!H3 is less than 5. I just tested it. What do you mean by 'shows error'?
12. ## Thread: Filter with cell value using VBA

by Andrew Poulsom
Replies
3
Views
174

### Re: Filter with cell value using VBA

If Target.Address <> "\$B\$4" Then Exit Sub
13. ## Thread: vba to get name of series collection point on chart

by Andrew Poulsom
Replies
12
Views
11,469

### Re: vba to get name of series collection point on chart

When I plot that data the SERIES formula looks like this:

=SERIES(,{"At Risk","Open","Complete"},{5,6,2},1)

and running the macro results in three message boxes containing "At Risk","Open" and...
14. ## Thread: Formatting a number in millions to show thousands

by Andrew Poulsom
Replies
8
Views
94,232

### Re: Formatting a number in millions to show thousands

The trailing comma scales by 1000. It's explained here:
...
15. ## Thread: vba to get name of series collection point on chart

by Andrew Poulsom
Replies
12
Views
11,469

### Re: vba to get name of series collection point on chart

You still haven't told me what actual data you are charting. Without knowing that it's impossible to say why "the 1st value returns a 1 and the subsequent values return the xvalue value".
16. ## Thread: vba to get name of series collection point on chart

by Andrew Poulsom
Replies
12
Views
11,469

### Re: vba to get name of series collection point on chart

That doesn't answer my question. What data is in the recordset and what is your VBA code?
17. ## Thread: vba to get name of series collection point on chart

by Andrew Poulsom
Replies
12
Views
11,469

### Re: vba to get name of series collection point on chart

Welcome to MrExcel.

What data are you charting?
18. ## Thread: Sum result of Index and Match with multiple criterias

by Andrew Poulsom
Replies
9
Views
232

### Re: Sum result of Index and Match with multiple criterias

What I posted wasn't an array formula.
19. ## Thread: Sum result of Index and Match with multiple criterias

by Andrew Poulsom
Replies
9
Views
232

### Re: Sum result of Index and Match with multiple criterias

=INDEX(Food!\$B\$2:\$S\$110,MATCH(\$B\$2,Food!\$A\$2:\$A\$110,0),MATCH(N\$1,Food!\$B\$1:\$S\$1,0))+INDEX(Food!\$B\$2:\$S\$110,MATCH(\$C\$2,Food!\$A\$2:\$A\$110,0),MATCH(N\$1,Food!\$B\$1:\$S\$1,0))
...
20. ## Thread: Out of Memory

by Andrew Poulsom
Replies
25
Views
809

### Re: Out of Memory

Not only that, but it uses ActiveCell rather than rCell. :eeek:
21. ## Thread: Save File As Same base name, but add the date to the beginning

by Andrew Poulsom
Replies
3
Views
657

### Re: Save File As Same base name, but add the date to the beginning

Welcome to MrExcel.

Try:

ActiveWorkbook.SaveAs Filename:= _
"H:\My Documents\kevin" & Format(Date, "yyyymmdd") & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
22. ## Thread: SUMIFS with IF function on sum_range

by Andrew Poulsom
Replies
29
Views
934

### Re: SUMIFS with IF function on sum_range

What did you try? Column W is used if none of the other criteria is met.
23. ## Thread: Attach into email with specific filename

by Andrew Poulsom
Replies
2
Views
158

### Re: Attach into email with specific filename

Because you have declared strfolder within the procedure SendEmail it is visible only to that procedure, and can't be accessed by procedure Test. Either declare the function at the top of the module...
24. ## Thread: Count where the sequence goes from 5.9 to 5.10 to 5.11 etc

by Andrew Poulsom
Replies
8
Views
250

### Re: Count where the sequence goes from 5.9 to 5.10 to 5.11 etc

Try:

=IF(M9>0,L9&"."&"01",TEXT(O8+0.01,"0.00"))

That way 5.1 isn't the same as 5.10 and your data will sort correctly if you ever need to do it.
25. ## Thread: Problem saving in Tab-delimited format in Excel 2010

by Andrew Poulsom
Replies
1
Views
174

### Re: Problem saving in Tab-delimited format in Excel 2010

Excel will save the data exactly how you see it. You can verify this by opening the file in Notepad. When you open the text file in Excel you need to choose the Date format DMY at Step 3 of the...
Results 1 to 25 of 150
Page 1 of 6 1