https://youtu.be/YdO_6U39SyA
Remember if you like it a free thumbs up via Spotify 5 star is greatly appreciated
https://github.com/XanderGr/EXCEL/blob/main/Python_matching
# Define the search criteria for the column use the placeholder
# Read the excel file into a pandas DataFrame
# Filter the DataFrame for rows where the placeholder column matches one of the search criteria
# Check if there are any matching rows
# If there are no matching rows, create a text file to indicate there are no matches
# If there are matching rows, write the filtered DataFrame to a new excel file