Hi,
I have my original data that looks like this.
1.png
As you can see, it shows the Id, Surname, First Name, Job and Rate.
I also have the rate cut off values. This arbitrary values I assign say 0-30 for Job 1 or 0-20 for Job 2 etc.
I want to use the cut off values and my raw data to identify only the individuals that fall between the cut off values.
For example the last entry Jeff Bezoos Job 2 Rate was 29 so he falls between the cut off values for Job 2 0-30.
Thank you for your help/guidance.
One way:
Please try in L17:Formula:
Please Login or Register to view this content.
This works great!
However, I feel as those the formula hard codes the titles eg Job 1,2,3 etc.. What if I were to change the headers to something? It doesn't seem to work for example 123JOB.1
Thanks
Last edited by bob112233; 12-22-2022 at 03:40 AM.
Thanks for the fast feeback and rep. Glad to have helped.
Hi,
I just noticed that the formula hard codes the JOB X. Is there a way to modify it so that it is more flexible with change of headers and values other than JOB 1,2 for example 11.JOB.1
No the code does not.I just noticed that the formula hard codes the JOB
Job is the name of the column of the filtered table f:Formula:Please Login or Register to view this content.
You are correct, my mistake. I misread it. Thank you once again
You are welcome!
If you change ALL instances of Job 2 to job_whatever_you_want it works.
If any job is listed in col D, but not in Col G, it fails. That situation can not occur in the real world, I'd assume.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks