Forum Discussion
Filter Function or any Logic
No OliverScheurich , the data also we need to calculate, attached is the sheet again, Worksheet home is the actual data,
1st Col-K we need to calculate for each rnti:-
As an example, I just created a sheet for rnti==9400, and created the data for it(Col-K and M)
then output like below can be easily be populated
which , I need for all rnti's in the home tab.
I've found your sample file in an earlier thread. However there is only one rnti in your sample file that is 384. I've attached your sample file "Filter_Function.xlsx" with suggested code.
For my sample data there are now 2 queries as shown in the screenshot. One query returns the final output and the other query shows the intermediary step that includes the "spdu-" column. My sample file is "Filter Function or any Logic.xlsx".