Hi everyone!
First time reaching out for help, I have a sequence in column A and would like to pull the data into column B. But the thing is I would like to skip over the cell if it states "All Other" yet continue on the same sequence. I remember writing a formula a while ago for this, had some nested If statements, but cant seem to recall it now.. Please help!
<tbody>
</tbody>
First time reaching out for help, I have a sequence in column A and would like to pull the data into column B. But the thing is I would like to skip over the cell if it states "All Other" yet continue on the same sequence. I remember writing a formula a while ago for this, had some nested If statements, but cant seem to recall it now.. Please help!
Original | What I Need | |
Apple | =IF(A7="All Other",A8,A7)....? | Apple |
HP | HP | |
Samsung | Samsung | |
All Other | Sony | |
Sony | Dell | |
Dell | LG | |
LG | Vizio | |
Vizio | Canon | |
Canon | Lenovo | |
Lenovo |
<tbody>
</tbody>