Welcome to the MrExcel board!
If that is so then perhaps some shorter alternatives can be used.
- if the value to the right of "Rate Structure" is known to be numeric then you could try the formula in A26
- otherwise try A27
@AhoyNC
Are you aware that there have been several new versions of XL2BB that have addressed quite a few bugs as well as enhancements?
20 11 26.xlsm |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | | | | | | | | | | | | | | | Y | Z | AA |
---|
1 | 148 | 595 | 735 | 637 | 842 | 835 | 620 | 580 | 348 | 169 | | | | | | | | | | | | | | | 781 | 390 | 443 |
---|
2 | 828 | 278 | 886 | 302 | 331 | 792 | 869 | 693 | 913 | 524 | | | | | | | | | | | | | | | 875 | 982 | 184 |
---|
3 | 796 | 718 | 429 | 640 | 711 | 301 | 939 | 307 | 503 | 560 | | | | | | | | | | | | | | | 495 | 455 | 485 |
---|
4 | 375 | 369 | 505 | 715 | 483 | 204 | 379 | 570 | 246 | 701 | | | | | | | | | | | | | | | 874 | 862 | 982 |
---|
5 | 884 | 956 | Test01 | 556 | 209 | 789 | 294 | 446 | 697 | 577 | | | | | | | | | | | | | | | 709 | 446 | 854 |
---|
6 | 665 | 789 | 762 | 139 | 988 | 627 | 718 | 580 | 395 | 769 | | | | | | | | | | | | | | | 258 | 346 | 978 |
---|
7 | 628 | 522 | 313 | 746 | 317 | 713 | 664 | 357 | Test22 | 928 | | | | | | | | | | | | | | | 757 | 507 | 298 |
---|
8 | 533 | 253 | 654 | 763 | 143 | 627 | 253 | 259 | 679 | 217 | | | | | | | | | | | | | | | 471 | 666 | 787 |
---|
9 | 538 | 828 | 917 | 277 | 316 | 767 | 949 | 662 | 842 | 847 | | | | | | | | | | | | | | | 786 | 151 | 542 |
---|
10 | 859 | 738 | 475 | 220 | 291 | 595 | 399 | 149 | 816 | 944 | | | | | | | | | | | | | | | 414 | 808 | 589 |
---|
11 | 969 | 635 | 917 | 212 | 509 | 573 | 497 | 533 | 797 | 240 | | | | | | | | | | | | | | | 423 | 357 | 619 |
---|
12 | 225 | 331 | 802 | 520 | Test02 | 596 | 578 | 854 | 961 | 163 | | | | | | | | | | | | | | | 414 | 895 | 338 |
---|
13 | 217 | 103 | 242 | 729 | 150 | 618 | 433 | 806 | 641 | 211 | | | | | | | | | | | | | | | 226 | 587 | 707 |
---|
14 | 255 | 871 | 709 | 827 | 847 | 208 | 700 | 372 | 553 | 186 | | | | | | | | | | | | | | | 453 | 485 | 438 |
---|
15 | 495 | 621 | 753 | 362 | 294 | 341 | Rate Structure | 352 | 541 | 501 | | | | | | | | | | | | | | | 372 | 549 | 145 |
---|
16 | 156 | 913 | 873 | 391 | 765 | 255 | 991 | 602 | 679 | 849 | | | | | | | | | | | | | | | 271 | 488 | 577 |
---|
17 | 164 | 911 | 207 | 745 | 158 | 803 | 767 | 795 | 242 | 209 | | | | | | | | | | | | | | | 300 | 325 | 451 |
---|
18 | 440 | 302 | 891 | 885 | 968 | 665 | 247 | 229 | 449 | 222 | | | | | | | | | | | | | | | 331 | 909 | 331 |
---|
19 | 138 | 397 | 585 | 836 | 259 | 471 | 922 | 161 | 966 | 196 | | | | | | | | | | | | | | | 236 | 814 | 859 |
---|
20 | 880 | 873 | 334 | 256 | 619 | 238 | 324 | 695 | 743 | 674 | | | | | | | | | | | | | | | 761 | 654 | 181 |
---|
21 | 600 | 193 | 816 | 840 | 965 | 717 | 633 | 224 | 616 | 103 | | | | | | | | | | | | | | | 468 | 637 | 651 |
---|
22 | 496 | 512 | 103 | 756 | 713 | 802 | 574 | 869 | 601 | 818 | | | | | | | | | | | | | | | 726 | 961 | 153 |
---|
23 | 588 | 595 | 142 | 440 | 114 | 322 | 649 | 919 | 798 | 546 | | | | | | | | | | | | | | | 262 | 556 | 884 |
---|
24 | 645 | 438 | 608 | 524 | 734 | 727 | 411 | 929 | 887 | 764 | | | | | | | | | | | | | | | 320 | 775 | 230 |
---|
25 | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
26 | 352 | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
27 | 352 | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
|
---|