sea

I need help with VBA code that will complete the following tasks: 1. On my “Leases” worksheet find all rows with the word “Yes” in the IN_DEFAULT column (column F) and copy those rows A through J. example "leases" worksheet <tbody> FILE_TYPE FILE_NUMBER CASE_TYPE SUB_TYPE OPR IN_DEFAULT STATUS...

Hi guys and girls and please help. I am trying to make an "active excel sheet". To be specific, imagine there is a boat travelling by a schedule and I want to show in a cell the actual port/status, next port/status name, time until next location, time until arrival/departure. I have the...

Hey everyone! Hope everybody is doing well. I've bee searching around and I've found some threads that are similar to what I'm trying to do but small differences completely change the results. I have a spreadsheet that is e-mailed to me daily. It has hundreds of lines that need to be...

Hi, I have a data consists of 3 column as given below <tbody> A B C 10252554 SEA C 10252554 LSF MC 10252554 DGP MC 10252554 BOO MC 10252554 TSD BTO 10252554 THD BTO 10252548 SEA P 10252548 LSF MC 10252548 DGP MC 10252548 BOO MC 10252548 TSD BTO 10252548 THD BTO...

I put together a Vlookup to check concatenated value based on text and a certain date in two worksheets and return a value based on that. The lookup date is always the first of a month. The column it returns the value from has either "At Sea" or different cities in it. In many cases the value...

Hello. I use this formula to count unique text in a column and it works well: =ArrayFormula(SUM(IF(FREQUENCY(IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""), IF(LEN(L4:L)>0,MATCH(L4:L,L4:L,0),""))>0,1))) resulting in 6. But the cells in the column also contain the word "Sea" or "Freedom" followed by a...