Search results

If you don't mind having helper columns or the order of the results, here's an "automated" solution: https://skydrive.live.com/redir.aspx?cid=88e8d8d4c7be2057&resid=88E8D8D4C7BE2057!103 How it works: - Column I is a helper column for the passing grades. for each entry in passing grades, it...

Another question :) Is this really something that needs to be automated? If not, the following works: 1) Turn on an auto-filter 2) Filter on column B <> blank 3) Highlight the names in column A; copy & paste 4) Remove filter on column B 5) Filter on column C <> blank...

Whoops - finally got a look at your sheet (firewall at work blocked it). I'll get back to you with an answer soon

Hi ahhhmed, Do you care if the data is sorted or do you need to maintain the order in which the data is presented in each column. As an example, if the values in Column B are: 100 80 <blank> 90 90 Would it be acceptable for column D to show? 100 90 90 80 Also, what about...

As an alternative to checking the length of the string, you can also use the ISNUMBER formula: =IF(AND(C1>=0,C1<5,ISNUMBER(C1)),A1,"") Based on your most recent response, it looks like you do not want C1<5 to be a condition? Based on your original post, that's included, which is...