I'm trying to concatenate movie data from a list like this (see attachment) into a format like this:
[Name of the movie][rating][showtimes in order, special glyph like "*" for Sunday showtimes]
I'm trying to concatenate movie data from a list like this (see attachment) into a format like this:
[Name of the movie][rating][showtimes in order, special glyph like "*" for Sunday showtimes]
The formula to give that format is (example is for row 4)
=C4&" "&D4&" "&IF(E4="","",E4&IF(COUNTA(F4:$J4)=0,"",", "))&IF(F4="","",F4&IF(COUNTA(G4:$J4)=0,"",", "))&IF(G4="","",G4&IF(COUNTA(H4:$J4)=0,"",", "))&IF(H4="","",H4&IF(COUNTA(I4:$J4)=0,"",", "))&IF(I4="","",I4&IF(J4="","",", "))&IF(J4="","",J4)
but adding the * for Sunday is problematic due to the way you have organized your data.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks