Results 1 to 13 of 13

MAXIF and MINIF functions with wildcards

Threaded View

JOOJOHN MAXIF and MINIF functions... 07-16-2009, 01:10 PM
squiggler47 Re: MAXIF and MINIF functions... 07-16-2009, 01:20 PM
JOOJOHN Re: MAXIF and MINIF functions... 07-16-2009, 01:44 PM
squiggler47 Re: MAXIF and MINIF functions... 07-16-2009, 01:50 PM
DonkeyOte Re: MAXIF and MINIF functions... 07-16-2009, 01:51 PM
JOOJOHN Re: MAXIF and MINIF functions... 07-16-2009, 02:08 PM
DonkeyOte Re: MAXIF and MINIF functions... 07-16-2009, 02:15 PM
JOOJOHN Re: MAXIF and MINIF functions... 07-16-2009, 02:30 PM
DonkeyOte Re: MAXIF and MINIF functions... 07-16-2009, 02:34 PM
JOOJOHN Re: MAXIF and MINIF functions... 07-16-2009, 02:43 PM
JOOJOHN Re: MAXIF and MINIF functions... 07-19-2009, 08:18 AM
martindwilson Re: MAXIF and MINIF functions... 07-19-2009, 11:20 AM
daddylonglegs Re: MAXIF and MINIF functions... 07-19-2009, 11:32 AM
  1. #1
    Registered User
    Join Date
    01-26-2009
    Location
    NORWICH , ENGLAND
    MS-Off Ver
    Excel 2007
    Posts
    16

    MAXIF and MINIF functions with wildcards

    Hi
    I have a list of bank transactions in a spreadsheet
    for example....

    1/7/09 Sainsburys Petrol 34856385
    4/7/09 Paypal 92017465
    6/7/09 Sainsburys S/Market 38264059
    8/7/09 Halfords 93862830
    11/7/09 Sainsburys S/Market 34957372
    13/7/09 Paypal 92037454
    14/7/09 Barclays BCC 173256

    and wish to use formulae similar to MAXIF and MINIF to find the last date and the first date of Paypal transactions (for example) if I have just the word "Paypal" in cell D1

    I've tried
    =SUMPRODUCT(MAX(($B$1:$B$7=$D$1)*$A$1:$A$7))

    but obviously this is looking for exact match of "Paypal"

    I have successfully used a wildcard in SUMIF functions elsewhere...

    eg, $D$1 & "*"

    but for some reason
    =SUMPRODUCT(MAX(($B$1:$B$7=$D$1 & "*")*$A$1:$A$7))
    does not work

    Does anyone have any suggestions?
    TIA
    Joojohn
    Last edited by JOOJOHN; 07-16-2009 at 02:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1