Question description:
This user has given permission to use the problem statement for this
blog.
I'm trying to write a formula that would find the percentage of Customer Invoices that have stayed in the same Row rank (Column J) for 2 consistent months. The rankings are segmented based on the criteria in Column P.
The sheet I'm working on is labeled Top X and the formula should be inputted in Q200:AZ212. The Row rank is found in column J, the Account ID is column B, and the Date range is in C (note the date range is Text, but the corresponding Dates needed for segmenting the data are located in Q2:AZ2. Please let me know if you have any questions!
Solved by Z. Y. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/08/2018 - 05:39
Greetings! Thank you for choosing Got It Pro!
Excelchat Expert
14/08/2018 - 05:39
Would you share your sheets please?
User
14/08/2018 - 05:39
Hello! Here is the workbook
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 05:40
Alright, give me a moment.
Excelchat Expert
14/08/2018 - 05:42
Hi, so what sheet should we be working on again?
User
14/08/2018 - 05:42
Top X
User
14/08/2018 - 05:43
And Q185 is similar logic for reviewing 1 month
Excelchat Expert
14/08/2018 - 05:45
Okay hold on a moment please
User
14/08/2018 - 05:46
No problem, I really appreciate the help! Let me know if you have any questions
Excelchat Expert
14/08/2018 - 05:48
So column Q should be blank right? I'm thinking that the 2 months you want to identify is the current month and the month before.
Excelchat Expert
14/08/2018 - 05:49
So 201601 needs a 201512 as well.
User
14/08/2018 - 05:50
It's fine if we don't get the first month. We don't have the data
Excelchat Expert
14/08/2018 - 05:50
Okay.
Excelchat Expert
14/08/2018 - 06:13
Here you go.
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 06:15
So the formula is checking how many customers are between a certain range, 1-10 to 11-20 for example, for two consecutive months, the current month and the previous one.
Excelchat Expert
14/08/2018 - 06:15
The formula is in R200:AZ212
Excelchat Expert
14/08/2018 - 06:16
I will mark this as answered no. Would you please consider leaving a feedback once the chat session is up? That will help us know how we did today!
Excelchat Expert
14/08/2018 - 06:17
Thank you for choosing Got It Pro! Looking forward to helping you again!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.