| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help - Logic Dependent on Other Columns
Been struggling getting this formula to work. Though I would create a
sample and see if anyone could help. Take a look at.... http://franz.org/formula.xls Has to do with using column counts and putting the value in the proper column dependent on the value of another column. Hard to explain, if you want to help out, take a look. Kindly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula Help - Logic Dependent on Other Columns
Try putting this formula in G2:
=IF($F2=G$1,$E2/COUNTIF($B2:$D2,"X"),"") Then copy it throughout the yellow range (G2:J10) Does that do what you want? -- Regards, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependent list in data validation - more than 2 columns | Excel Worksheet Functions | |||
| how do I use logic to gray or color other columns? | Excel Discussion (Misc queries) | |||
| Countif dependent on two columns | Excel Discussion (Misc queries) | |||
| countif dependent on two columns? | Excel Discussion (Misc queries) | |||
| How do I sum a column dependent on another columns text value? | Excel Worksheet Functions | |||
Linear Mode
