Drrellik
Well-known Member
- Joined
- Apr 29, 2013
- Messages
- 834
- Office Version
- 365
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
I am creating a small one page data table and dont mind rearranging it to fit the formula(s) or formats
On the sheet I will only change the value in D1 from A to B,C or D
based on one of four inputs have the table on the left range A1:C12 highlighted based on the data in the corresponding column to my selection
for this one I chose A for Column E2:E10
I would actually like some suggestions or how you would create something like this, just a nudge in the right direction and not so much a shove...
thanks in advance for your thoughts or hints.
~DR
On the sheet I will only change the value in D1 from A to B,C or D
based on one of four inputs have the table on the left range A1:C12 highlighted based on the data in the corresponding column to my selection
for this one I chose A for Column E2:E10
I would actually like some suggestions or how you would create something like this, just a nudge in the right direction and not so much a shove...
thanks in advance for your thoughts or hints.
~DR
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 1 | 2 | 3 | A | A | B | C | D | ||
2 | 4 | 5 | 6 | 1 | 2 | 7 | 8 | |||
3 | 7 | 8 | 9 | 3 | 4 | 9 | 10 | |||
4 | 10 | 11 | 12 | 5 | 6 | 11 | 12 | |||
5 | 13 | 14 | 15 | 13 | 14 | 17 | 18 | |||
6 | 16 | 17 | 18 | 15 | 16 | 20 | 19 | |||
7 | 19 | 20 | 21 | 22 | 21 | 26 | 25 | |||
8 | 22 | 23 | 24 | 24 | 23 | 28 | 27 | |||
9 | 25 | 26 | 27 | 34 | 33 | 30 | 29 | |||
10 | 28 | 29 | 30 | 36 | 35 | 32 | 31 | |||
11 | 31 | 32 | 33 | |||||||
12 | 34 | 35 | 36 | |||||||
Sheet1 |