Thread: Sorting Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harley Harley is offline
external usenet poster
 
Posts: 16
Default Sorting Data

My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to
longest number of days, I lose the formula results due to a Ref error. How
can I correct this problem?

thanks,
harley