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.