Hi,
When a fraction is multilpied to an array of numbers, i want the results of the whole numbers only. Please see example below. Is there a way of doing this in a simple manner (macro/function)
Thank you
When a fraction is multilpied to an array of numbers, i want the results of the whole numbers only. Please see example below. Is there a way of doing this in a simple manner (macro/function)
Thank you
Excel Workbook | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
2 | Data Set 1 | 2 | 11 | 29 | 9 | 7 | 29 | * | ||
3 | Data Set 2 | 25 | 17 | 21 | 19 | 14 | 28 | * | ||
4 | * | * | * | * | * | * | * | * | ||
5 | Fractions | * | * | * | * | * | * | * | ||
6 | *1/2 | * | * | * | * | * | * | * | ||
7 | *2/3 | * | * | * | * | * | * | * | ||
8 | *1/7 | * | * | * | * | * | * | * | ||
9 | *6/7 | * | * | * | * | * | * | * | ||
10 | 13/21 | * | * | * | * | * | * | * | ||
11 | * | * | * | * | * | * | * | * | ||
12 | Example | * | * | * | * | * | * | * | ||
13 | Using 1/2 | * | 1 * * * | 5 *1/2 | 14 *1/2 | 4 *1/2 | 3 *1/2 | 14 *1/2 | ||
14 | * | * | 12 *1/2 | 8 *1/2 | 10 *1/2 | 9 *1/2 | 7 * * * | 14 * * * | ||
15 | * | * | * | * | * | * | * | * | ||
16 | * | * | * | * | * | * | * | * | ||
17 | * | * | 1 | * | * | * | * | * | ||
18 | * | * | * | * | * | * | 7 | 14 | ||
19 | * | * | * | * | * | * | * | * | ||
20 | * | * | * | * | * | * | * | * | ||
21 | * | * | Result is 1, 7, 14 | * | * | * | * | * | ||
Sheet1 |