+ Reply to Thread
Results 1 to 4 of 4

Question about Replace,If, Substitute, Min,Max Small,Large function

Hybrid View

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2010 MAC
    Posts
    1

    Question Question about Replace,If, Substitute, Min,Max Small,Large function

    Workbook1.xlsx

    I'm new to Excel .

    I have my question in the attachment

    I'm trying to format the data so that the smallest number of one row would be replaced by the second small number in the original data table.

    I tried using the combination of Replace , If, Substitute, Min Max, Small, Large functions. It's very easy for only 2 columns data. But I don't know how to do that with more than 2 columns

    Are there any new functions that could be easier for this question? Or should I use VBA?

    Thank you very much guys!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Question about Replace,If, Substitute, Min,Max Small,Large function

    Unable to understand the logic. Could you please explain it a bit more...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Question about Replace,If, Substitute, Min,Max Small,Large function

    isn't that

    =MAX(A6:B6) fill down ????
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Question about Replace,If, Substitute, Min,Max Small,Large function

    =MEDIAN(B33:D33)

    copy down

+ Reply to Thread

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