View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ExcelQuestion ExcelQuestion is offline
external usenet poster
 
Posts: 1
Default Ignoring Blank value in a drop down list


Hi Leo,
That was an excellent post. This know-how is going to help many,
certainly you have me helped greatly. Good work.

Thanks again,
Ricky


Leo Heuser Wrote:
"shail" skrev i en meddelelse
oups.com...
Hi Leo,

Thanks again for the fantastic post. I was thinking of this but I
didn't asked as I thought sorting couldn't be possible using a
formulae.

thanks

Shail


Hi Shail

Again you're welcome, and thank you for your feedback :-)

Actually, I also thought, it wasn't possible to do a sort with
formulae only, but then I suddenly saw the light ;-)

Regards
Leo Heuser



--
ExcelQuestion
------------------------------------------------------------------------
ExcelQuestion's Profile: http://www.excelforum.com/member.php...o&userid=34059
View this thread: http://www.excelforum.com/showthread...hreadid=564718