Hello Sir/Madam,
In sheet1 I have a Column A contains systems such as 0-20-A0-P01, 0-20-A0-P02, P03,P04 and so on.
In other sheets2 in column A have same like with many duplicates. In same sheet 2 somewhere column D or column E have values like "A","B","C" with duplicates.
I need to do in sheet 1 vlookup formula and findout how many "A" available in respective of 0-20-A0-P01, And how many "B" with respective of 0-20-A0-P01 and so on.
same like other system 0-20-A0-P02 contains how many A, B, C and so on
I tried with help of vlookup and countif i couldnt . I need suggestion please
In sheet1 I have a Column A contains systems such as 0-20-A0-P01, 0-20-A0-P02, P03,P04 and so on.
In other sheets2 in column A have same like with many duplicates. In same sheet 2 somewhere column D or column E have values like "A","B","C" with duplicates.
I need to do in sheet 1 vlookup formula and findout how many "A" available in respective of 0-20-A0-P01, And how many "B" with respective of 0-20-A0-P01 and so on.
same like other system 0-20-A0-P02 contains how many A, B, C and so on
I tried with help of vlookup and countif i couldnt . I need suggestion please