+ Reply to Thread
Results 1 to 8 of 8

I need to create a formula

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    I need to create a formula

    I have a spreadsheet that does various things i.e. calculating and moving calculations from 1 page to another. I am quite new to Excel and am unsure about the last formula I wish to enter.
    I have a column in which various amounts appear example (f19-f52) has amounts ranging from 18 to 46 for example. I wish to have in column (h19-h52) any number that is greater than 28 as shown in columns (f19-f52) is this possible and how do I do it. Thanks. i.e in column h I want the formula to copy any number in the above mentioned f19-f52 if it is greater than 28, also I would like the blank cells in column "h" to remain blank and not appear as zero's
    Last edited by GeoffTT; 02-11-2013 at 07:13 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: I need to create a formula

    Use this Array formula in column H

    =IFERROR(INDEX($F$19:$F$52,SMALL(IF($F$19:$F$52>28,ROW($F$19:$F$52)-18),ROW(F1))),"")

    If you really use Excel 2003 replace the iferror formula with if(iserror.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: I need to create a formula

    Post this in column H, starting at 19, then drag down as far as desired.

    =if(F19 > 28, F19, "")

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need to create a formula

    GeoffTT,

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    02-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Talking Re: I need to create a formula

    Quote Originally Posted by Tekkie2412 View Post
    Post this in column H, starting at 19, then drag down as far as desired.

    =if(F19 > 28, F19, "")
    Thank you for this, I have entered it and it works like clockwork, again thank you

  6. #6
    Registered User
    Join Date
    02-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: I need to create a formula

    I am not going to take the trouble of reading to suit you, I have had a difinitive answer without any pedantic comments.

  7. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need to create a formula

    GeoffTT,

    The forum rules are in place for every user. How would you feel if you searched for a particular question in the forum and found the thread "Need to create a formula"? Would it give you the slightest hint about what the thread is about? Think about other users who are facing the similar situation as yours. Wouldnt you want to help them out?

  8. #8
    Registered User
    Join Date
    02-01-2013
    Location
    Albany, NY
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: I need to create a formula

    Thank you for emphasizing this point. We're here to help one another, not just satisfy our own needs.

+ 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