Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if multiple values same/others different, return true
A challenge:
I have a list that has 48 columns in each row. Each cell has a score of 1-4. I would like a "true" return if specifically and only these cells have a 1 and others do not have a 1. For example: A1, b1, c1, e1, g1, h1, i1, (etc.) have to be a 1 for the line to be true D1, f1, j1, k1, (etc.) if any or all of these are not a 1, the line is true Basically I have 40 cells that need to be a 1 and 8 cells that at least one has a different number. I could write if a1=b1=c1=e1=g1 etc., but that is a very long equation. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return all matching values | Excel Worksheet Functions | |||
Looking up multiple values for a single name | Excel Worksheet Functions | |||
find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
return multiple corresponding values in excel | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions |