HI,
as you can see i have 2 table in 2 different worksheets. in table 1 i want to fill dates. dates are mentioned in table 2.
Example -What formula i apply in cell D3 table 1 so if the S.NO B3 (S_001754) have any record in table2 15th June , if yes it should give Y for no N.
Note - 1 S# Number could have many records in 1 days so if it could tell number of records are even better.
Thanks
find date.jpg
Bookmarks