Close

Results 1 to 6 of 6
  1. #1
    DF Super Moderator DJ Overdose's Avatar
    Join Date
    Jul 2001
    Location
    On da decks.
    Posts
    10,383
    Thanks
    1,077
    Thanked:        2,465
    Karma Level
    1203

    Dumbass Excel help required please!

    I've got an excel problem that is doing my head in. I would normally with the help of google, be able to sort this kinda thing, but it's really pissing me off now.

    Basically I want to have the black box filled with entries from the table up to but not over the number in cell E5.

    E5 can then be changed for other numbers and the contents of the box update accordingly. It needs to start populating with the highest number, then work down the next highest until it goes over cell E5. Then populate no more.

    I think this is gonna be an array formula, but can't work it out for some reason.

    Thanks in advance.


    DJ OD
    Attached Files Attached Files
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  2. #2
    DF Jedi wijit's Avatar
    Join Date
    Jul 2004
    Location
    UK
    Posts
    1,090
    Thanks
    91
    Thanked:        105
    Karma Level
    299

    Default Re: Excel help required please!

    I can't open it just now, but is this not possible with conditional formatting (number not above/equal to/lower than)?

    Thanks to wijit

    DJ Overdose (24th March 2015) 


  3. #3
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,019
    Thanks
    1,152
    Thanked:        836
    Karma Level
    336

    Default Re: Excel help required please!

    I have done this, pretty simple with a RANK and a Vlookup (you will need to hide some columns but I have left them visible so you can work out how I have done it

    Cant upload back on here as no space but you can download the zip from [Only registered and activated users can see links. ]

    Thanks to akimba

    DJ Overdose (24th March 2015) 


  4. #4
    DF Jedi blacksheep's Avatar
    Join Date
    Jun 2006
    Location
    Manchester
    Posts
    3,877
    Thanks
    87
    Thanked:        265
    Karma Level
    513

    Default Re: Excel help required please!

    If(<=E5) set to E5 or something like that. Sorry didn't download sheet as on ipad.

    Thanks to blacksheep

    DJ Overdose (24th March 2015) 


  5. #5
    DF Super Moderator DJ Overdose's Avatar
    Join Date
    Jul 2001
    Location
    On da decks.
    Posts
    10,383
    Thanks
    1,077
    Thanked:        2,465
    Karma Level
    1203

    Default Re: Excel help required please!

    Quote Originally Posted by akimba View Post
    I have done this, pretty simple with a RANK and a Vlookup (you will need to hide some columns but I have left them visible so you can work out how I have done it

    Cant upload back on here as no space but you can download the zip from [Only registered and activated users can see links. ]
    Aha! Wasn't quite what I required, but I was easily able to tweek it so

    Nice one Akimba.


    DJ OD
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  6. #6
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,019
    Thanks
    1,152
    Thanked:        836
    Karma Level
    336

    Default Re: Excel help required please!

    Glad to be of assistance, wasn't the hardest problem I have seen but sometimes you just need the nudge/inspiration to find the solution ;-)

Similar Threads

  1. [HELP] Excel Guru required
    By DejaVu in forum PC Software
    Replies: 10
    Last Post: 27th April 2011, 01:17 AM
  2. Excel Help - (Formula required)
    By Karoline in forum PC Software
    Replies: 4
    Last Post: 28th July 2008, 04:53 PM
  3. Excel Help required
    By snorty1uk in forum Programming
    Replies: 4
    Last Post: 16th July 2008, 09:53 AM
  4. Name that PLayer (Excel required) Quiz
    By GETanner in forum Football
    Replies: 9
    Last Post: 29th June 2004, 11:19 AM
  5. MS Excel Help Required
    By Speedlock in forum PC Problems
    Replies: 8
    Last Post: 10th August 2003, 08:23 PM

Social Networking 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
  •