Hi Chris,
If you could paste some example code it would make it easier to
provide a good answer.
Perhaps I misunderstand the problem, but I'm not sure what you can do
to fix the blank cells if criteria haven't been selected. Do you mean
you'd prefer some sort of error message to come up?
Cheers,
Nick
Nicholas Perkins
http://www.nicholasperkins.com/blog/
On Nov 9, 8:43*pm, Chris Hough wrote:
Hey,
Im sure there is an easy answer to this but i cant come up with it.
I have a long list of possible criteria's i want the user to pick ten out of the list by selecting yes from a drop down list next to the criteria.
Once they have ticked yes i want it to appear in a second sheet with a table.
When i have tried i am unable to do it without getting false or blank cells where the criteria hasnt been ticked
Can anyone help with this? i need a formula that will aviod these false returns and just finds the next citeria that has been ticked yes.
Thanks
Chris
EggHeadCafe - Software Developer Portal of Choice
Run an ASP Page with parameters from SQL Serverhttp://www.eggheadcafe.com/tutorials/aspnet/1c387dc4-875b-4392-80b5-6...