why give me error #VALUE ... i need to give me the numbers from small to big

hi
why give me error #value
when i press f9 on formula there are #values and numbers 100 ,99,89
i need to bring numbers from small to big 89 99 100
but there is error >>> it gives me #value

i have condition in the formula
with function small i need to sort numbers from small to big



in any formula when we use small function .... it gives us the number of the rows from small to big
i need to bring data from small to big not the rows from small to big
therefore i used address and indirect To get the data After i got the data i used small to sort them from small to big

I hope the explanation is clear because my English not well
forgive me
thanx

You need the Small on the inside to remove the falses and keep the row numbers.

Try this array copied down

=INDIRECT(ADDRESS(SMALL(IF($A$4:$A$13>88,ROW($A$4:$A$13)),ROW(A1)),1))

thanks
but i need to give me 89 the first then 99 then 1oo ..... from small to big

not 100 99 89

from small to large

Then use this non-arrayed formula In B4 copied down

=IF(LARGE($A$4:$A$13,ROWS($A$1:$A1))<=88,"",LARGE($A$4:$A$13,ROWS($A$1:$A1)))

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

thank u JohnTopley

where is the condition >88

i must use condition in the formula

mena,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

Please change your title to comply with the rule.

Okay, try this arrayed formula in B4 copied down

=IFERROR(SMALL(IF($A$4:$A$13>88, $A$4:$A$13), ROWS($A$1:$A1)),"")