I have a list of airport codes that appear in two different formats within a specific Google Sheet. One format is a list of one or more airport codes separated by commas, within a singe cell… The other is a list of one or more airport codes, with each one appearing alone in a cell that is, itself, within a range of cells. I want a TRUE / FALSE statement as to whether there is any overlap between the two lists.

I have a list of airport codes that appear in two different formats within a specific Google Sheet. One format is a list of one or more airport codes separated by commas, within a singe cell… The other is a list of one or more airport codes, with each one appearing alone in a cell that is, itself, within a range of cells. I want a TRUE / FALSE statement as to whether there is any overlap between the two lists.

Both lookup cells formatted at plain text, I don’t think that’s the issue. Searching for C186 returns 2 results proving they’re correct. please see images.

Both lookup cells formatted at plain text, I don’t think that’s the issue. Searching for C186 returns 2 results proving they’re correct. please see images.

Both lookup cells formatted at plain text, I don’t think that’s the issue. Searching for C186 returns 2 results proving they’re correct. please see images.

So, I have something like this in the table.
I need MIN value from Column A, but exclude values lower then B1 cell. So 5, 13, 14 are lower then 16, and result of the formula should be 34, the lowest value of the remaining values

Closed 4 hours ago.

I have data and I want to combine it with IMPORTRANGE. For each IMPORTRANGE, I would like to add a column with specific data afterwards.

I have data and I want to combine it with IMPORTRANGE. For each IMPORTRANGE, I would like to add a column with specific data afterwards.

I have data and I want to combine it with IMPORTRANGE. For each IMPORTRANGE, I would like to add a column with specific data afterwards.