Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write formulas
I am new to computing and would like to know if someone can help me write a
formula in excel for a worksheet. I have quite a significant amount of rows of 6 columns each. I want to be able to highlight the rows that have 3 or 4 specific numbers that I ask for, can this be done? -- John Roberts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write formulas
Assume your source table is in cols A to F, data from row2 down
Assume your criteria is to check each source data row for any of 3 specific numbers, say: 3 or 5 or 8 Create/Use an adjacent helper col, say col G to flag it In G2: =SUMPRODUCT(--ISNUMBER(MATCH({3;5;8},A2:F2,0)))0 Copy G2 down to the last row of source data. Col G will return TRUE for rows satisfying the criteria. You could then apply autofilter on col G, choose: TRUE to isolate these rows for whatever ensuing action. Or, if you just want to color/highlight these rows for quick visuals, you could select the entire sheet, then apply CF using Formula Is: =$G1, and format to taste. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "John Roberts" wrote: I am new to computing and would like to know if someone can help me write a formula in excel for a worksheet. I have quite a significant amount of rows of 6 columns each. I want to be able to highlight the rows that have 3 or 4 specific numbers that I ask for, can this be done? -- John Roberts |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
write graph series using formulas | Charts and Charting in Excel | |||
Using checkboxes, can I write formulas based on what is checked? | Excel Worksheet Functions | |||
How can I write multidimensional arrays in Excel Formulas? | Excel Worksheet Functions | |||
how to write formulas in excel for money to days | New Users to Excel | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions |