chrismichaelgentile
New Member
- Joined
- Aug 7, 2013
- Messages
- 2
Hello, I'm attempting to organizing an extraction file that was originally a tab delineated table (from AutoCAD ATTOUT). I copy this table to a sheet preset in my workbook (ATTOUT). I have three formulas: one that lists the symbols (column A), the other returns the quantity(ies) associated with the symbol (columns C:extent needed), and a sum that edits the text to a number (column B). The database from ACAD (the ATTOUT sheet can be quite extensive.
I usually work with the formula calculation method set to manual. I didn't realize this when I was writing the formulas, but Excel crashes when I try to recalculate. I cannot find where I went wrong, can someone please review my code?
<tbody>
</tbody>
Formulas in A and B are copied down to extent needed. Formula in C is copied across to extent needed and down to match column A. Here is an example of the ATTOUT! sheet:
<tbody>
</tbody>
Thank you in advance!
I usually work with the formula calculation method set to manual. I didn't realize this when I was writing the formulas, but Excel crashes when I try to recalculate. I cannot find where I went wrong, can someone please review my code?
X | A | B | C |
1 | SYMBOL | SUM | QUANTITIES |
2 | =IFERROR(INDEX(ATTOUT!$D:$D,MATCH(0,COUNTIF(ATTOUT!$D:$D,"<"&ATTOUT!$D:$D)-SUM(COUNTIF(ATTOUT!$D:$D,$A$1:A1)),0)),"") | =SUMPRODUCT(IFERROR(IFERROR(IF(ISTEXT(C3:CCC3),--LEFT(C3:CCC3, FIND("|",REPLACE(C3:CCC3,LEN(C3:CCC3)-2,LEN(C3:CCC3)-(LEN(C3:CCC3)-2), "|"))),C3:CCC3),IF(ISTEXT(C3:CCC3),--LEFT(C3:CCC3,FIND("|",REPLACE(C3:CCC3, LEN(C3:CCC3)-1,LEN(C3:CCC3)-(LEN(C3:CCC3)-1),"|"))),C3:CCC3)),C3:CCC3)) | =IFERROR(INDEX(ATTOUT!$C:$C,SMALL(IF(ATTOUT!$D:$D=$A2, ROW(ATTOUT!$C:$C)-ROW(ATTOUT!$C$1)+1),COLUMNS($C:C))),"") |
3 | Ctrl+' | Ctrl+' | Ctrl+' |
<tbody>
</tbody>
Formulas in A and B are copied down to extent needed. Formula in C is copied across to extent needed and down to match column A. Here is an example of the ATTOUT! sheet:
X | C | D |
1 | QTY | SYM |
2 | 779 SF | CONC |
3 | 1230 SF | REF |
4 | 345 SF | DG |
<tbody>
</tbody>
Thank you in advance!