D
DW
I have a list of names and times and a value (number). In another sheet, I
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the name.
sheet 1
col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20
Sheet 2
col A col B
Joe if sheet 1 col C >2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John
Hope someone can help.
DW
have the same list of names, but here, I'm trying to match up with that
first list and either display the number or the time value next to the name.
sheet 1
col A col B col C
Joe 34 0:50 (formatted as h:mm)
Fred 42 0:20
John 60 2:20
Sheet 2
col A col B
Joe if sheet 1 col C >2 hours then display sheet 1 col C else
display sheet 1 col B
Fred
John
Hope someone can help.
DW