Good morning all
I'm trying to create some helper columns on a very large spreadsheet, to make decisions easier rather than staring at a lot of cells!
We have 8 sites, and for each I've a column "Stock, PO, Sales" (1 site doesn't have a sales column) Using reporting software/xlookups I am able to display these values.
The sheet has over 1,000 product lines... so I had the idea of helper columns;
1. No Stock | =IF(AND($G3=0,$J3=0,$M3=0,$O3=0,$R3=0,$U3=0,$X3=0,$AA3=0),"True","")
2. No Stock No PO |
=IF(AND($G3=0,$H3=0,$J3=0,$K3=0,$M3=0,$N3=0,$O3=0,$P3=0,$R3=0,$S3=0,$U3=0,$V3=0,$X3=0,$Y3=0,$AA3=0,$AB3=0),"True","")
3. No Stock No Sales | =IF(AND($G3=0,$I3=0,$J3=0,$L3=0,$M3=0,$N3=0,$O3=0,$Q3=0,$R3=0,$T3=0,$U3=0,$W3=0,$X3=0,$Z3=0,$AA3=0,$AC3=0),"True","")
4. No Stock Active PO
5. No Stock Active Sales
6. No Stock No PO Active Sales
1, 2 and 3 I've put the formula next to each that I'm currently running
*** Is the most effective and up to date formula (we use Office 365, fully up to date), if not what would be an ideal replacement
I'm stumped at working out 4, 5 and 6.
Appreciate any help!
Thanks, Luke
I'm trying to create some helper columns on a very large spreadsheet, to make decisions easier rather than staring at a lot of cells!
We have 8 sites, and for each I've a column "Stock, PO, Sales" (1 site doesn't have a sales column) Using reporting software/xlookups I am able to display these values.
The sheet has over 1,000 product lines... so I had the idea of helper columns;
1. No Stock | =IF(AND($G3=0,$J3=0,$M3=0,$O3=0,$R3=0,$U3=0,$X3=0,$AA3=0),"True","")
2. No Stock No PO |
=IF(AND($G3=0,$H3=0,$J3=0,$K3=0,$M3=0,$N3=0,$O3=0,$P3=0,$R3=0,$S3=0,$U3=0,$V3=0,$X3=0,$Y3=0,$AA3=0,$AB3=0),"True","")
3. No Stock No Sales | =IF(AND($G3=0,$I3=0,$J3=0,$L3=0,$M3=0,$N3=0,$O3=0,$Q3=0,$R3=0,$T3=0,$U3=0,$W3=0,$X3=0,$Z3=0,$AA3=0,$AC3=0),"True","")
4. No Stock Active PO
5. No Stock Active Sales
6. No Stock No PO Active Sales
1, 2 and 3 I've put the formula next to each that I'm currently running
*** Is the most effective and up to date formula (we use Office 365, fully up to date), if not what would be an ideal replacement
I'm stumped at working out 4, 5 and 6.
Appreciate any help!
Thanks, Luke