I need to create a formula

**GeoffTT** · 02-11-2013, 07:07 AM

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

**Fotis1991** · 02-11-2013, 07:25 AM

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.

**Tekkie2412** · 02-11-2013, 07:26 AM

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

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

**arlu1201** · 02-11-2013, 07:28 AM

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.

**GeoffTT** · 02-11-2013, 08:35 AM

Originally Posted by Tekkie2412

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

**GeoffTT** · 02-11-2013, 08:37 AM

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

**arlu1201** · 02-11-2013, 09:03 AM

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?