The function you are looking for is
For example in cell D4 have a cell formula
, D5 has
Personally I would have had the validation set to
if the data WAS
entered in which case I would have used the formula
It is very easy to get tied up with multiple isblank functions especially with localisation, dates, other formulas etc etc ... this set of search results mentions several google search for isblank issues
] but I wouldn't worry about them unless/until you hit them
Finally, be careful about your terminology (so that it is easier for more people to help you out)
Member 10234093 said:I have put the above columns in the excel file in the cell A and B.
. You actually meant that you have put the above data
in rows 2 and 3
where row 1 is the headings row.
have numbers - usually these are displayed down the left hand side
have letters - usually displayed across the top of the sheet
are identified by their column + row e.g. C4 above.