Forum Discussion
Excel help needed in comparing Data
Hi All I need some help with excel formula. Here is my problem statement. Any help/pointers on how to solve this is really helpful I have 2 documents - Doc1 and Doc2. Below is sample forma...
Can you copy past the content from the attached xls in this reply here ? Also a correction - Instead of having 2 documents Doc1 and Doc2, I actually can put all the content in 1 sheet of a xls.
So consider this as 1 single sheet of a xls with Part 1, Part 2 and then finally the Results
So consider this as 1 single sheet of a xls with Part 1, Part 2 and then finally the Results
Jack67 Isn't that in the file I uploaded earlier?
>@Ri Isn't that in the file I uploaded earlier?
Riny_van_Eekelen Dito. And You also took height for allowing different months in the three ranges which I did not.
I like using formats to visualize the result as you did and at the same time keep the possibility to easily sum, eg to make a KPI showing equality (by dividing with count).
Preferred using N() (as it is a documented function and there is also a T() to get as Text) but it seems not upgraded to be dynamic array compatible and thus, it has to be the more secret --().
- I am facing issues in downloading files. Hence was requesting for details in the chat..
In C17 here
enter
=IF( ISNA( MATCH($B17, $B$5:$B$7, 0)), "Missing in Section 1", IF( ISNA( MATCH( $B17, $B$11:$B$13, 0)), "Missing in Section 2", IF( INDEX($C$5:$F$7, MATCH($B17, $B$5:$B$7, 0), MATCH(C$16, $C$4:$F$4, 0) ) = INDEX($C$11:$F$13, MATCH($B17, $B$11:$B$13, 0), MATCH(C$16, $C$4:$F$4, 0) ), "Yes", "No") ))and drag it to the right and down
- Thank you for sharing your response here. These pointers were very helpful for me.
Appreciate your time to support me here..
Jack67 Like this then?
- Thank you - This was super helpful to me.
Appreciate your pointers to resolve this question.
