josvill2010
New Member
- Joined
- Jun 1, 2011
- Messages
- 40
- Office Version
- 365
Hi,
I would like to get rid of the first #Ref! line that query is bringing.
The first line has the following formula
=query({SNC!A15:C;NAO!A15:C;ASH!A18:C; LDC!A15:C;HCO!A15:C;HIL!A15:C;ZCH!A15:C;ZHU!A15:C;ZGD!A15:C;ZAS!A15:C;ZAZ!A15:C;COL!A15:C}, "Select * where Col1 ='L1'")
It brings the error #REF!
The problem is only on the first line. It seems that for Column C it brings the cell just under C too ie
2001-CONSUMABLES PO
See below highlighted
I would like to get rid of the first #Ref! line that query is bringing.
The first line has the following formula
=query({SNC!A15:C;NAO!A15:C;ASH!A18:C; LDC!A15:C;HCO!A15:C;HIL!A15:C;ZCH!A15:C;ZHU!A15:C;ZGD!A15:C;ZAS!A15:C;ZAZ!A15:C;COL!A15:C}, "Select * where Col1 ='L1'")
It brings the error #REF!
The problem is only on the first line. It seems that for Column C it brings the cell just under C too ie
2001-CONSUMABLES PO
See below highlighted
SNC | Average Growth Rate | #DIV/0! | ||||||||||||||||||
SNC1 | NA | |||||||||||||||||||
Currency | USD | Building Count | ||||||||||||||||||
Previous Period Invoicing | ||||||||||||||||||||
PO | Supplier | Title | Description | Requestor | Need by | Amount | Billed | Unbilled | Run Rate | Q2'20 | Q3'20 | Q4'20 | Q1'21 | Q2'21 | Q3'21 | Q4'21 | Q1'22 | Q2'22 | ||
L0 | SNC | NON REPLENISHABLE MATERIALS | $3,309 | $53,635 | $4,406 | $28,760 | $83,052 | $41,864 | $7,345 | $5,970 | $0 | |||||||||
L1 | SNC | 2001-CONSUMABLES | 1 | $0 | $2,500 | $0 | $3,309 | $21,400 | $4,406 | $12,841 | $31,658 | $29,271 | $3,765 | $5,970 | $0 | |||||
PO | Supplier | Title | Description | Requestor | Need by | Amount | Billed | Unbilled | Run Rate | Q2'20 | Q3'20 | Q4'20 | Q1'21 | Q2'21 | Q3'21 | Q4'21 | Q1'22 | Q2'22 | ||
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |