gordonfitch
New Member
- Joined
- Sep 17, 2006
- Messages
- 5
Can anyone assist? I would like to know how to write a formula that can search a selected column for a number that is divisable by another number found in a specified cell.
I have a table with 300 rows, each numbered 1:300, I have another cell with a specific number.
I need to be able to identify each number in a specified column which is exactly divisable by the specific number.
For example: If the sum of any cell in column A, containing a number which is exactly divisable by cell (eg F6 which might contain number 11), then another action is to be applied.
My problem is that I do not know how to write a formulae that is able to compare one cells contents with a column of other cells 1:300 in an attempt to identify each number in that column which is exactly divisable by the specified number.
Thanks - Gordon Fitch
I have a table with 300 rows, each numbered 1:300, I have another cell with a specific number.
I need to be able to identify each number in a specified column which is exactly divisable by the specific number.
For example: If the sum of any cell in column A, containing a number which is exactly divisable by cell (eg F6 which might contain number 11), then another action is to be applied.
My problem is that I do not know how to write a formulae that is able to compare one cells contents with a column of other cells 1:300 in an attempt to identify each number in that column which is exactly divisable by the specified number.
Thanks - Gordon Fitch