Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding columns that has data by rows
My spreadsheet has 3700 rows with columns A-DZ labeled mm/yyyy in Row1.
Data are numbers 0 per cell. I need to pull the start (column mm/yyyy) per row where data is 0 and finish (last cell in a row where data is 0) and enter start in EA and finish in EB. Need to do it for all 3700 rows. I've tried index, match and if statements to no avail. Help please. TIA DPingger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding values in different rows/columns | Excel Worksheet Functions | |||
Finding the highest value from two columns of data | Excel Worksheet Functions | |||
Finding unique data between 2 columns | Excel Worksheet Functions | |||
Finding similar data or numbers in two columns | New Users to Excel | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions |