#1
|
|||
|
|||
Comparison Analysis
Hello Mentors
While working on one of my project I face some challenges where I need your guidance. I have two customer data. 1 one 471 unique customers ( list from April'21 t- Nov'21) another has 315 unique customers list ( from jan'22 - 20th Mar'22. ) They sent us a request for return. What I am trying to find is who all are repeated customers who have sent req again and who have not at all sent any request from this list of customers. Please guide me how to do it. |
#2
|
||||
|
||||
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I have reviewed your file and proposed this template:
Comparison Analysis (2).xlsx |
#4
|
|||
|
|||
thank you , really workable for me.. thanks for support
|
#5
|
|||
|
|||
hello sir,
what s the formula if I want to how much the number has increased. |
#6
|
|||
|
|||
In absolute value, it's the difference between column D and B.
In relative value, you have it in column E |
#7
|
|||
|
|||
I got that sir. but wasnt that for if number has been decreased (to what %).
for an eg sir , if my May 2021 % is 115 and May 2022 is 118, how much it has incresed. whats the formula for that. |
#8
|
|||
|
|||
adding a sheet for reference sir
|
#9
|
||||
|
||||
Duplicate post https://www.msofficeforums.com/excel...-decrease.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#10
|
||||
|
||||
maddy29: Kindly don't post questions about the same topic in multiple threads.
As for your cross-posting on different boards, please read Excelguru Help Site - A message to forum cross posters regarding the expected cross-posting etiquette.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using textframe value in comparison | Scaffold | Word VBA | 12 | 03-15-2022 12:16 AM |
Document Comparison | Thefirstfish` | Word VBA | 0 | 04-10-2017 01:07 PM |
Attendance Analysis | LarryLee87 | Excel Programming | 4 | 11-23-2016 05:14 PM |
What if Analysis | fm2406 | Excel | 0 | 10-20-2015 09:47 AM |
Comparison jumps to end | MarshallAbrams | Word | 2 | 03-21-2012 04:04 AM |