Hi there,
I'm having trouble trying to figure out how I count data in a column(3) that matches a text string in another column(1).
Tube Line, Station Name, Refurbishment, Modernisation,
Central Line, Queensway, TRUE, FALSE,
Central Line, Algate East, TRUE FALSE,
Central Line, Bank, FALSE, TRUE,
Central Line, Bank, FALSE, TRUE,
District Line, Richmond, TRUE, FALSE,
for example I need to know how many times CENTRAL LINE (c1) along with TRUE for refurbishment (c3) is display.
Thanks in advance for any help received.
jrncrank
I'm having trouble trying to figure out how I count data in a column(3) that matches a text string in another column(1).
Tube Line, Station Name, Refurbishment, Modernisation,
Central Line, Queensway, TRUE, FALSE,
Central Line, Algate East, TRUE FALSE,
Central Line, Bank, FALSE, TRUE,
Central Line, Bank, FALSE, TRUE,
District Line, Richmond, TRUE, FALSE,
for example I need to know how many times CENTRAL LINE (c1) along with TRUE for refurbishment (c3) is display.
Thanks in advance for any help received.
jrncrank