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 F. F. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/08/2018 - 05:20
Hi
Excelchat Expert 14/08/2018 - 05:21
Welcome to Got it Pro
Excelchat Expert 14/08/2018 - 05:21
Can you please share your excel sheet?
User 14/08/2018 - 05:21
Hey, here's the workbook
[Uploaded an Excel file]
Excelchat Expert 14/08/2018 - 05:21
Ok one minute
Excelchat Expert 14/08/2018 - 05:22
not able to open
User 14/08/2018 - 05:22
One moment, I'll drop it in a Google Doc
Excelchat Expert 14/08/2018 - 05:24
Ok
Excelchat Expert 14/08/2018 - 05:24
not able to view anything
User 14/08/2018 - 05:25
https://drive.google.com/open?id=1e3gudic-mHBceVMhYTCDLQmT762Tn1up
Excelchat Expert 14/08/2018 - 05:25
Please send the excel sheet again
Excelchat Expert 14/08/2018 - 05:26
I think sheet is the problem
User 14/08/2018 - 05:26
[Uploaded an Excel file]
Excelchat Expert 14/08/2018 - 05:26
file its too large
Excelchat Expert 14/08/2018 - 05:26
what is the file size?
Excelchat Expert 14/08/2018 - 05:27
send sample data to work with your requirement
User 14/08/2018 - 05:27
k, seperating the sheet
Excelchat Expert 14/08/2018 - 05:29
please copy paste the information in the sheet
Excelchat Expert 14/08/2018 - 05:30
Are you there?
User 14/08/2018 - 05:34
PC crashed... you can end the session
Excelchat Expert 14/08/2018 - 05:35
oops.
Excelchat Expert 14/08/2018 - 05:35
Really sorry for the inconvenience caused
Excelchat Expert 14/08/2018 - 05:35
Kindly connect with us again for your queries once your system is up..
Excelchat Expert 14/08/2018 - 05:35
Thank you

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.