HI,
I've been playing with the autofilter function with no luck, maybe there is a formula that can help me do this -> I am trying to sort a table (there are about 240 rows and many more columns) such that any row that has a value > .615 in it, anywhere in that row, can be identified, so that I can bring those to the top... again, i tried using the autofilter function but couldnt figure it out, then i thought maybe writing some formula saying "if any of the cells in this row are > .615 then say yes" and i could sort by the yes's....would appreciate some help with this please
![]()
Bookmarks