filtering rows across several columns
Hi,
I assume A, B & C are column headings and not the actual columns A,B & C. Put this in a helper column and drag down =COUNTIF(C2:E2,3)0 It will return TRUE if there is a 3 in any of the columns. Filter for TRUE on this column -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "MadProphet" wrote: I have a spreadsheet that looks something like this: Edit # Edit Descr A B C 0001 Missing Phone 1 2 2 0002 Missing Name 2 3 1 0003 Missing Zip 3 3 1 I want to create a filter that will display all rows that have a value of 3 in the A, B, or C columns. Any ideas on how to proceed? |
All times are GMT +1. The time now is 07:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com