Please see the attached spreadsheet, as I have presented my problem there, for better clarity.
mgs
Please see the attached spreadsheet, as I have presented my problem there, for better clarity.
mgs
Slight change to take care of the auto increment based on the data.
=SUMPRODUCT((COUNTIF(OFFSET(A1,,,LOOKUP(2,1/(A:A<>""),ROW(A:A))),OFFSET(A1,,,LOOKUP(2,1/(A:A<>""),ROW(A:A))))>1)*(1/COUNTIF(OFFSET(A1,,,LOOKUP(2,1/(A:A<>""),ROW(A:A))),OFFSET(A1,,,LOOKUP(2,1/(A:A<>""),ROW(A:A))))))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks