VBA/Formula to find (#3 and #4 digit) MOST match key (defined key)

**aan.isnaini** · 12-30-2021, 09:38 AM

Dear All,
as per subject, I'M looking forward to have your help to make VBA or Formula to to find (#3 and #4 digit) MOST match key (defined key).

Attached the file and example the goal (just write one alphabet where is the most matched key).

Thank you

**JohnTopley** · 12-30-2021, 11:49 AM

Can you explain what exactly is required as you have numerous key values but no explanation as how they are derived.

in CQ5

=INDEX(CS2:CY199,MID(A$2,ROWS($1:3),1),MID($A$2,ROWS($1:4),1))

is a match with A2 But what about all other columns?

**aan.isnaini** · 12-30-2021, 12:33 PM

Dear John,
I apologize not clear/delete my try and error to make a formula.

- the goal is explained at second yellow highlighted, looking for the most key matched with each column number (just find #3 and #4digit).
example: in cell A2 (1221), looking for 21 match with what a KEYS?. if match with more than one key, then calculate which one the most (large/top) one.
- there is row with describe:
1. All Data key: index and match all data(number-just find #3 and #4digit) from A2 to Today
2. 1 month Key: index and match data(number-just find #3 and #4digit) from Today - one month (past)
3. 2 week key: index and match data(number-just find #3 and #4digit) from Today - 2 week (past)
4. 3 week key: index and match data(number-just find #3 and #4digit) from Today - 3 week (past)
5. 10 days key: index and match data(number-just find #3 and #4digit) from Today - 10 days (past)
6. 7 days key: index and match data(number-just find #3 and #4digit) from Today - 7 days (past)

that's why in A1..CQ1 value is date
Attachment 761412

Thank you

**AliGW** · 12-30-2021, 03:32 PM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)