Hi
This is my first post :-)
Apologies if this has been answered before. I have looked through some of the posts in the forum but am not sure if the responses will do what I need.
I have a spreadsheet with five columns (cols A to E). The cells across all columns may or may not have a value. I would like to find the rows where any cell in columns A to B have a value in them. I would like to use Column F to have some text in there to flag that the row has got at least one value.
Please could someone advise me how this can be done using formulas.
Kind Regards
Sandy
Bookmarks