Trying to set up a formula to return the following.
A B C
Y Y 1
Y N 2
N Y 3
N N 4
What would be the formula be in C1 to return any of the combinations above.
Thanks in advance.
BILL PAYMENT VIA FASTER PAYMENT TO ABC Ltd REFERENCE UK , MANDATE 333
BILL PAYMENT VIA FASTER PAYMENT TO ACME LLC REFERENCE UK , MANDATE 375
TRANSFER TO A1 PUMPS Ltd REF: 1234
Dear All
Above is an extract from a report (3 entries) - but two different text strings. I need to remove the company...
Dear All
I have a spreadsheet that contains 200 Rows for data entry (and several columns) - ideally I only want to show 20 lines at a time. Can a scroll bar embedded into the spreadsheet allow me to do this - if so how can this be achieve.
Thanking you in advance.