Jesse
New member
- Joined
- Mar 22, 2011
- Messages
- 51
- Reaction score
- 0
- Points
- 0
I have some line level invoice data I'm working with. Each row is one line on an invoice, an invoice can have many items or just one.
I'm trying to flag each row if the whole invoice contains are particular type of item so I can filter when I put it into a pivot table.
Currently I'm using:
=IF(G1<>G2,IF(COUNTIF(OFFSET(T2,0,0,COUNTIF(G:G,G2)),"Fish")>0,TRUE,FALSE),D1)
To check to see if the invoice contains "Fish". The data is sorted by invoice so I first check the invoice number, if it's the same as the item above then just copy that.
The problem is my data has 120,000 rows, with four conditions to check a calculation takes upwards of 15 minutes on my Quad core PC.
Any suggestions for making this formula more efficient? I only need to flag TRUE or FALSE.
Jesse
I'm trying to flag each row if the whole invoice contains are particular type of item so I can filter when I put it into a pivot table.
Currently I'm using:
=IF(G1<>G2,IF(COUNTIF(OFFSET(T2,0,0,COUNTIF(G:G,G2)),"Fish")>0,TRUE,FALSE),D1)
To check to see if the invoice contains "Fish". The data is sorted by invoice so I first check the invoice number, if it's the same as the item above then just copy that.
The problem is my data has 120,000 rows, with four conditions to check a calculation takes upwards of 15 minutes on my Quad core PC.
Any suggestions for making this formula more efficient? I only need to flag TRUE or FALSE.
Jesse