Auto populate cell based on last value in row

[Detectiveclem]

Can anyone assist me with a formula which will auto populate the cells between N6:N5000 with the last ‘Item’ entered in the same row at columns Q, V, AA or AF etc. If nothing is entered in these cells on a particular row then the N cell needs to remain blank (For example as seen at Row 10).

Please see the screen shot below.

Any help would be greatly appreciate.

 

[Fluff]

Duplicate to: Auto add last entered data in same row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.