Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.35 seconds.

  1. Replies
    27
    Views
    1,081

    Re: Help needed!!! Index or vlookup

    Just select your data and insert a Column Chart.
  2. 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. Re: SUMIFS with IF function on sum_range

    Check that column W doesn't contain any #N/A errors.
  4. Re: Putting an active link in HTMLBody in CDO

    Welcome to MrExcel.

    Have you tried using %20 instead of a space character?
  5. 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. 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. 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. 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. Re: Formula to return unique values in a range in alphabetical order?

    The Evaluate Formula tool will show you how the formula works.
  10. 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. 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. Replies
    3
    Views
    174

    Re: Filter with cell value using VBA

    Try adding this at the beginning of your Worksheet_Change event procedure:

    If Target.Address <> "$B$4" Then Exit Sub
  13. 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. Re: Formatting a number in millions to show thousands

    The trailing comma scales by 1000. It's explained here:
    ...
  15. 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. 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. Re: vba to get name of series collection point on chart

    Welcome to MrExcel.

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

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

    Your formula works for me:

    =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. Replies
    25
    Views
    809

    Re: Out of Memory

    Not only that, but it uses ActiveCell rather than rCell. :eeek:
  21. 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. 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. 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. 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. 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 2 3 4