ExcelLearner00
New Member
Question One, if I have a table with data and blanks in each column, column header is a weekday I would like to have a formula to just return non blank cells in the range corresponding to the current date.
Question Two, if I have another table that fills by row first column has the current date how can I return data from column 2 that only matches the current date in column 1, variable number of rows for the date.
Question Two, if I have another table that fills by row first column has the current date how can I return data from column 2 that only matches the current date in column 1, variable number of rows for the date.
