| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value - 15 Dec?
Does anyone have any suggestions on how to determine the value within matrix?
There is a list of characters under following tables This table is starting at cell B2 to N11 0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L 1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F 2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D 3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B 5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G 6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K 7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L 8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C 9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I There is another list for value from B12 to N12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by inserting a number in cell A1, and character in cell B1 and return the result in cell C1. For example, 5 in cell A1 and F in cell B1, it should return 2 in cell C1 7 in cell A1 and A in cell B1, it should return 12 in cell C1 1 in cell A1 and H in cell B1, it should return 11 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value - 15 Dec?
If I am not mistaken, I think you can delete that chart and use this formula
in its place... =MOD(CHOOSE(A1+1,1,7,5,11,3,8,12,1,4,10)-(CODE(B1)-64)-1,12)+1 By the way, unless you left some data out, your columns go from B to M, not B to N. -- Rick (MVP - Excel) "Eric" wrote in message ... Does anyone have any suggestions on how to determine the value within matrix? There is a list of characters under following tables This table is starting at cell B2 to N11 0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L 1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F 2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D 3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B 5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G 6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K 7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L 8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C 9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I There is another list for value from B12 to N12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by inserting a number in cell A1, and character in cell B1 and return the result in cell C1. For example, 5 in cell A1 and F in cell B1, it should return 2 in cell C1 7 in cell A1 and A in cell B1, it should return 12 in cell C1 1 in cell A1 and H in cell B1, it should return 11 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value - 15 Dec?
Thank everyone very much for suggestions
I try to re-word my description. There is a list of characters under following tables This table is starting at cell B2 to M11 AA AB AC AD AE AF AG AH AI AJ AK AL BG BH BI BJ BK BL BA BB BC BD BE BF CE CF CG CH CI CJ CK CL CA CB CC CD DK DL DA DB DC DD DE DF DG DH DI DJ EC ED EE EF EG EH EI EJ EK EL EA EB FH FI FJ FK FL FA FB FC FD FE FF FG GL GA GB GC GD GE GF GG GH GI GJ GK HA HB HC HD HE HF HG HH HI HJ HK HL ID IE IF IG IH II IJ IK IL IA IB IC JJ JK JL JA JB JC JD JE JF JG JH JI There is another list for value from B12 to M12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by matching a character in cell A1, and character in cell B1 and return the result in cell C1 under row 12 For example, B in cell A1 and F in cell B1, it should return 1 in cell C1 H in cell A1 and A in cell B1, it should return 12 in cell C1 E in cell A1 and H in cell B1, it should return 7 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric "Rick Rothstein" wrote: If I am not mistaken, I think you can delete that chart and use this formula in its place... =MOD(CHOOSE(A1+1,1,7,5,11,3,8,12,1,4,10)-(CODE(B1)-64)-1,12)+1 By the way, unless you left some data out, your columns go from B to M, not B to N. -- Rick (MVP - Excel) "Eric" wrote in message ... Does anyone have any suggestions on how to determine the value within matrix? There is a list of characters under following tables This table is starting at cell B2 to N11 0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L 1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F 2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D 3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B 5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G 6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K 7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L 8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C 9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I There is another list for value from B12 to N12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by inserting a number in cell A1, and character in cell B1 and return the result in cell C1. For example, 5 in cell A1 and F in cell B1, it should return 2 in cell C1 7 in cell A1 and A in cell B1, it should return 12 in cell C1 1 in cell A1 and H in cell B1, it should return 11 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value - 15 Dec?
Try this:
=SUMPRODUCT((B2:M11=A1&B1)*B12:M12) -- Biff Microsoft Excel MVP "Eric" wrote in message ... Thank everyone very much for suggestions I try to re-word my description. There is a list of characters under following tables This table is starting at cell B2 to M11 AA AB AC AD AE AF AG AH AI AJ AK AL BG BH BI BJ BK BL BA BB BC BD BE BF CE CF CG CH CI CJ CK CL CA CB CC CD DK DL DA DB DC DD DE DF DG DH DI DJ EC ED EE EF EG EH EI EJ EK EL EA EB FH FI FJ FK FL FA FB FC FD FE FF FG GL GA GB GC GD GE GF GG GH GI GJ GK HA HB HC HD HE HF HG HH HI HJ HK HL ID IE IF IG IH II IJ IK IL IA IB IC JJ JK JL JA JB JC JD JE JF JG JH JI There is another list for value from B12 to M12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by matching a character in cell A1, and character in cell B1 and return the result in cell C1 under row 12 For example, B in cell A1 and F in cell B1, it should return 1 in cell C1 H in cell A1 and A in cell B1, it should return 12 in cell C1 E in cell A1 and H in cell B1, it should return 7 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric "Rick Rothstein" wrote: If I am not mistaken, I think you can delete that chart and use this formula in its place... =MOD(CHOOSE(A1+1,1,7,5,11,3,8,12,1,4,10)-(CODE(B1)-64)-1,12)+1 By the way, unless you left some data out, your columns go from B to M, not B to N. -- Rick (MVP - Excel) "Eric" wrote in message ... Does anyone have any suggestions on how to determine the value within matrix? There is a list of characters under following tables This table is starting at cell B2 to N11 0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L 1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F 2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D 3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B 5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G 6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K 7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L 8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C 9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I There is another list for value from B12 to N12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by inserting a number in cell A1, and character in cell B1 and return the result in cell C1. For example, 5 in cell A1 and F in cell B1, it should return 2 in cell C1 7 in cell A1 and A in cell B1, it should return 12 in cell C1 1 in cell A1 and H in cell B1, it should return 11 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the value - 15 Dec?
Try this array-entered** formula...
=14-MAX((A1&B1=$B$2:$M$11)*COLUMN($B$2:$M$11)) **Commit formula with Ctrl+Shift+Enter, not just Enter by itself. -- Rick (MVP - Excel) "Eric" wrote in message ... Thank everyone very much for suggestions I try to re-word my description. There is a list of characters under following tables This table is starting at cell B2 to M11 AA AB AC AD AE AF AG AH AI AJ AK AL BG BH BI BJ BK BL BA BB BC BD BE BF CE CF CG CH CI CJ CK CL CA CB CC CD DK DL DA DB DC DD DE DF DG DH DI DJ EC ED EE EF EG EH EI EJ EK EL EA EB FH FI FJ FK FL FA FB FC FD FE FF FG GL GA GB GC GD GE GF GG GH GI GJ GK HA HB HC HD HE HF HG HH HI HJ HK HL ID IE IF IG IH II IJ IK IL IA IB IC JJ JK JL JA JB JC JD JE JF JG JH JI There is another list for value from B12 to M12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by matching a character in cell A1, and character in cell B1 and return the result in cell C1 under row 12 For example, B in cell A1 and F in cell B1, it should return 1 in cell C1 H in cell A1 and A in cell B1, it should return 12 in cell C1 E in cell A1 and H in cell B1, it should return 7 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric "Rick Rothstein" wrote: If I am not mistaken, I think you can delete that chart and use this formula in its place... =MOD(CHOOSE(A1+1,1,7,5,11,3,8,12,1,4,10)-(CODE(B1)-64)-1,12)+1 By the way, unless you left some data out, your columns go from B to M, not B to N. -- Rick (MVP - Excel) "Eric" wrote in message ... Does anyone have any suggestions on how to determine the value within matrix? There is a list of characters under following tables This table is starting at cell B2 to N11 0A 0B 0C 0D 0E 0F 0G 0H 0I 0J 0K 0L 1G 1H 1I 1J 1K 1L 1A 1B 1C 1D 1E 1F 2E 2F 2G 2H 2I 2J 2K 2L 2A 2B 2C 2D 3K 3L 3A 3B 3C 3D 3E 3F 3G 3H 3I 3J 4C 4D 4E 4F 4G 4H 4I 4J 4K 4L 4A 4B 5H 5I 5J 5K 5L 5A 5B 5C 5D 5E 5F 5G 6L 6A 6B 6C 6D 6E 6F 6G 6H 6I 6J 6K 7A 7B 7C 7D 7E 7F 7G 7H 7I 7J 7K 7L 8D 8E 8F 8G 8H 8I 8J 8K 8L 8A 8B 8C 9J 9K 9L 9A 9B 9C 9D 9E 9F 9G 9H 9I There is another list for value from B12 to N12 12 11 10 09 08 07 06 05 04 03 02 01 I would like to determine the value by inserting a number in cell A1, and character in cell B1 and return the result in cell C1. For example, 5 in cell A1 and F in cell B1, it should return 2 in cell C1 7 in cell A1 and A in cell B1, it should return 12 in cell C1 1 in cell A1 and H in cell B1, it should return 11 in cell C1 Does anyone have any suggestions on how to do it in excel? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the value? | Excel Worksheet Functions | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Worksheet Functions | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) | |||
Hybrid Mode
