Welcome Guest
Log In | Register )
You last visited December 7, 2016, 10:55 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Formula

Topic closed. 2 replies. Last post 4 years ago by SergeM.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
Ontario
Canada
Member #134426
October 28, 2012
1 Posts
Offline
Posted: October 29, 2012, 12:12 pm - IP Logged

I need help with an Excel formula to sort through data to find sequencial numbers e.g. 1-2 or 3-4 etc. I tried using a FREQUENCY formula but only got results for the 2 individual numbers where I need results where both numbers are included in a row.

    Avatar

    United States
    Member #41846
    June 23, 2006
    459 Posts
    Offline
    Posted: October 29, 2012, 12:54 pm - IP Logged

    I need help with an Excel formula to sort through data to find sequencial numbers e.g. 1-2 or 3-4 etc. I tried using a FREQUENCY formula but only got results for the 2 individual numbers where I need results where both numbers are included in a row.

    first welcome to LP

    With so little info its difficult to give much help.  if the data is such that you  can, you might use a countif to find the first value then combine it with an "and " command and another countif for the second value.

    More specifics on the data structure will get you a better answer.

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: October 29, 2012, 8:33 pm - IP Logged

      Function + Filter

      Nothing more