I have an excel worksheet that I use at work. Currently I use it mainly to help with changes with receive throughout the day. The main formula is in column D and looks like this.
{=IFERROR(SMALL(IF(COUNTIF($O$2:$O$30,'Open Order Report'!G2:G30)>0,ROW('Open Order Report'!G2:G30)-ROW($I$2)+1),ROWS(D$3:D3)),"")}
I paste changes into the search column "C" and column "O" breaks it down to the first word. This formula then searches Sheet 1 "Open Order Report" to find items that match, and gives it a unique number, and then returns the info into column E:L. Currently the data is sorted in order of how it appears on Sheet 1 "Open Order Report". I would like the data to sort by item in alphabetical/numerical value instead. Is this possible? I cannot find a solution to this.
The example in my attachment returns
Market Store CD203
Market Store CD117x
Boardwalk Arcade CD203
Boardwalk Arcade CD117x
Boardwalk Arcade HS63
Daisy Diner HS63
Daisy Diner 289
Hamilton Mall CD203
Hamilton Mall CD117x
Hamilton Mall HS63
Ronnies CD203
Ronnies CD117x
Normans Auto CD203
Normans Auto CD117x
I would like it to return
Daisy Diner 289
Market Store CD117x
Hamilton Mall CD117x
Ronnies CD117x
Normans Auto CD117x
Boardwalk Arcade CD117x
Market Store CD203
Hamilton Mall CD203
Ronnies CD203
Normans Auto CD203
Boardwalk Arcade CD203
Daisy Diner HS63
Hamilton Mall HS63
Boardwalk Arcade HS63
Example EOOR.xlsx
Bookmarks