Do you mean that, calculate number of days of username & product number. And calculate number of days for all customer but with product number.
If this is correct then, try :
In column "F" mentioned username
In column "G" Select product number with data validation.
Column "I" & "J" calculate number of days with criteria column Min function in "F" & Max function in "G"
"I2"
Formula:
=MIN(IF($B$2:$B$16=F2,IF($D$2:$D$16=G2,$C$2:$C$16)))
"J2"
Formula:
=MAX(IF($B$2:$B$16=F2,IF($D$2:$D$16=G2,$C$2:$C$16)))
By pressing ctrl+shift+enter
In column "H2"
Formula:
=INT(J2-I2)
For calculation for all username & product number
Column "L" & "M" calculate number of days with criteria column in "G"
In "L2"
Formula:
=MIN(IF($D$2:$D$16=G2,$C$2:$C$16))
In "M2"
Formula:
=MAX(IF($D$2:$D$16=G2,$C$2:$C$16))
By pressing ctrl+shift+enter
In "K2"
Formula:
=INT(M2-L2)
For details refer attach file.
Bookmarks