Extract information from a table - trimmean based on the user input

[subodhs]

I have got a list of pay items - which are combination of letters and numbers always starting with letter preceded by letters. Like G7P9.1 But the users will only enter the value for G7

So, there can be several entries starting with G7 so, the user should be able to see the values starting from G7* or R44* or G38* and so on as shown in the attached table.

And, if there are lets say several values with same item code Say G36P1, then on the resultant table should show average (possibly trimmean average as some values can be reasonably high or low)

I have shown in example what end results is needed for a case (cell D332)

Merge_All.xlsx

drive.google.com

Thanks in advance for your help

 

[Fluff]

Cross posted Extract information from a table - trimmean based on the user input

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.