Hello Forum,
Please can you assist with a formula that's doing my head in!
I've attached a file with note which I hope are clear enough.
Many thanks for having a look -- here are the conditions which I also have in the doc:
All changing data cells (cols BN-BQ) have formulas in them in original doc, ie they are not blank so isblank etc won't work
If columns BP BQ are blank: No data should appear in cols BT-BV
If both cols BP BQ have data, BQ appears in BV, and BP appears in BU
If one or the other of cols BP BQ have data, that data appears in col BV
Depending on which of Cols BP BQ now lead in col BV, look to the left for the numbers to appear in BU and BT
Until there's a blank cell (though there's still a formula there in the original doc), then stop
Conditional.xlsx
Bookmarks