+ Reply to Thread
Results 1 to 7 of 7

I have

  1. #1
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    I have

    Hi,

    I have

    File is attached for further help
    Last edited by aslam5420; 07-10-2022 at 10:01 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    d12 =IF(D10=0,"",IF(OR(AND(C12>C11,C11<C10),AND(C12<C11,C11>C10)),"yes",""))

    e3 =Countif$D$3:$D3,"yes")

    after that a pivot table.

    Notice: I think your expected answers did not met your criteria.

    See the attached file.
    Last edited by oeldere; 07-03-2022 at 04:58 AM. Reason: formula d12 changed
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    Hi Sir, oeldere

    Thank you so much it worked.

    Sir, is it possible to get the same these results without using Pivot table. I want a Formula that could find same these values.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    You did not replied if the calculated values in my sheet are correct.

    H3=ROW()-2

    I3=INDEX($A$2:$E$206,MATCH(H3,$E$2:$E$206,0),3)

    See the attached file.
    Last edited by oeldere; 07-03-2022 at 05:20 AM.

  5. #5
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    Hi Sir, oeldere

    You have calculated these values exactly like hat i want. It was a mistake from my side at cell G46. But you done it in right way.

    But i want to find all these values using a Formula

  6. #6
    Registered User
    Join Date
    06-29-2022
    Location
    Canada
    MS-Off Ver
    2021
    Posts
    38

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    Hi Sir, oeldere

    It worked perfectly. I wanted this type of result.

    Thank you so much.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to find numbers which change Trend of ascending or descending numbers in a co

    Thanks for the rep.

    Glad I could help.

    Thanks for marking the question solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for making numbers in random order change to ascending order
    By bansche123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2021, 09:18 AM
  2. [SOLVED] Find highest number before numbers start descending
    By Lancasterbe in forum Office 365
    Replies: 8
    Last Post: 05-12-2019, 03:57 AM
  3. Find closest value in range with ascending then descending data
    By NatalieEC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-22-2018, 07:17 PM
  4. Replies: 16
    Last Post: 07-17-2015, 04:16 PM
  5. [SOLVED] Find Match or Next Lowest Number In Descending Column of Numbers
    By skywriter in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2015, 11:24 PM
  6. Populate column cells with descending numbers
    By djarcadian in forum Excel General
    Replies: 1
    Last Post: 07-23-2007, 01:42 PM
  7. Sorting Numbers in Ascending or Descending Order
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:25 AM

Tags for this Thread

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