Sorting data

[AndyE]

Can anyone suggest an amended formula that will produce the result I need in earlier versions of excel i.e. '97 & '03.

In the attached version the "Print Version" tab sorts the values entered into the "Log Entries" tab. When entries are deleted from the "Log Entries" tab they are converted into 'blank' entries and moved to the end in the "Print Version" tab.

However, in earlier versions the "IFERROR" does not appear to work, therefore any blank entries are shown as "#NUM!", which is kind of annoying.

If there any way around this? The forumla is shown below.

=IFERROR(SMALL('Log Entries'!$A$1:$E$47,ROW('Log Entries'!A1)+COLUMNS('Log Entries'!$A$1:A1)*46-46),"")

[shg]

IFERROR was introduced in 2007.

If a UDF work-around is acceptable, use this:

Please Login or Register  to view this content.

[AndyE]

Thank you...

Apologies though, I'm not a programmer...UDF?

And where would I insert the code?

[martindwilson]

Pre 2007
=if(iserror(small('log entries'!$a$1:$e$47,row('log entries'!a1)+columns('log entries'!$a$1:a1)*46-46)),"",small('log entries'!$a$1:$e$47,row('log entries'!a1)+columns('log entries'!$a$1:a1)*46-46))

[AndyE]

Excellent. Thank you both...Yet again the forum comes up trumps...