Forum Discussion
excell
If I have downloaded bank statements for a 12 month period how do I transfer all negative amounts into a separate column?
downloaded bank statements
I guess because every downloaded bank statements has different layout there are no general automate separate way.
You may try flashfill
https://www.excel-easy.com/examples/flash-fill.html#:~:text=Flash%20fill%20in%20Excel%201%20First%2C%20tell%20Excel,when%20your%20source%20data%20changes.%20...%20See%20More.
I guess because every downloaded bank statements has different layout there are no general automate separate way.
You may try flashfill
https://www.excel-easy.com/examples/flash-fill.html#:~:text=Flash%20fill%20in%20Excel%201%20First%2C%20tell%20Excel,when%20your%20source%20data%20changes.%20...%20See%20More.