Array Formulas

Discussion in 'Software' started by hcrawfor, Sep 11, 2009.

  1. hcrawfor

    hcrawfor Corporal

    Within a spreadsheet, does anyone know how to accomplish the following task?


    I have 6 numerical values in 6 adjacent cells.... let's say cells D10 – I10. Do you know the Array Formula to use to eliminate the highest and lowest number in that string of 6 numbers, and place the results (4 numbers) in 4 adjacent cells.... lets say cells D9 – G9?


    Thank You, hcrawfor
     
    hcrawfor, Sep 11, 2009
    #1

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds