SteveStrummerUK

Absolutely nailed it Des! Thank you so much for your help ?

Thanks for your input Kurre. I did actually come up with this myself ? Unfortunately, as I quickly discovered, this formula treats an empty cell and a cell with a zero in it exactly the same.

Further to some excellent Excel advice received in here some time ago, I'm hoping someone can help me with this ☺️ Previous advice showed me how to cause one cell to display a '1' if another named cell contained a number greater than zero, e.g: =IF(A1>0,1"") I need to do something similar, but this time I need the '1' to be displayed if the named cell is NOT BLANK. For example, if I type any value into cell A1, a '1' will appear in cell B1 Further to the screenshots above, the =IF(W7>0,1"") formula (copied down column X) correctly inserts a '1' into the 'Days Operated' fields, but typing '0' does not (I type a zero in the 'Service Users' column if no passengers are travelling but the service is still operating). Ideally, with the correct formulae in place, the example above would look like this: Thanks in advance ?

Speaking of Welsh Wales isn't it that's lovely ... I once went to Barry Island. Unfortunately, it was open. Lush.

Insert Straummy's Welsh place-name p***s tattoo joke here >> <<

Love it mate ?

Just need Randy, Bob and Pistolpete and the gang will all be here ? Dare I say 'Stump' season would be well and truly open - what do you reckon Del ?

Did someone say "Kemper" ?

Awesome shredding - and that's just Billy Sheehan on bass ?

... I must be very pleased with myself ?

bump

bump

bump

bump

bump

bumo

bump

bump

bump

bump

... you must be very proud of yourselves ?

Currently rumbling away on the automobile turntabulum...