Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.