B5rocksass
Board Regular
- Joined
- Jan 10, 2017
- Messages
- 56
- Office Version
- 2016
- Platform
- Windows
Hello everyone, Is it possible to copy concatenated fields and have them treated as a formula in that pasted field? I have 4 columns of the same formula in which each of the 30+ rows reference a different tab in the workbook. Instead of entering each cell and replacing various parts of formula, I've created the correct formula using concatenate. Now all i have to do is put an equal sign before it. But i was hoping this could be pasted as a formula. Please help!
Here is a portion of the data I'm working with...
Here is a portion of the data I'm working with...
LUM Confirmations Time Frame Averages - 2021.01.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Formula Fragments | |||||||||||
2 | Tab | Form-1 | Form-2 | Form-3 | Form-4 | Form-5 | Form-6 | Form-7 | Form-8 | Concatenated Formula | ||
3 | 1' | COUNTIFS(' | !$F:$F, | $B$2 | ,' | !$G:$G,"N",' | !$C:$C,"<="&WORKDAY( | $A3 | ,-3)) | COUNTIFS('1'!$F:$F,$B$2,'1'!$G:$G,"N",'1'!$C:$C,"<="&WORKDAY($A3,-3)) | ||
4 | 2' | COUNTIFS(' | !$F:$F, | $B$2 | ,' | !$G:$G,"N",' | !$C:$C,"<="&WORKDAY( | $A4 | ,-3)) | COUNTIFS('2'!$F:$F,$B$2,'2'!$G:$G,"N",'2'!$C:$C,"<="&WORKDAY($A4,-3)) | ||
5 | 3' | COUNTIFS(' | !$F:$F, | $B$2 | ,' | !$G:$G,"N",' | !$C:$C,"<="&WORKDAY( | $A5 | ,-3)) | COUNTIFS('3'!$F:$F,$B$2,'3'!$G:$G,"N",'3'!$C:$C,"<="&WORKDAY($A5,-3)) | ||
6 | 4' | COUNTIFS(' | !$F:$F, | $B$2 | ,' | !$G:$G,"N",' | !$C:$C,"<="&WORKDAY( | $A6 | ,-3)) | COUNTIFS('4'!$F:$F,$B$2,'4'!$G:$G,"N",'4'!$C:$C,"<="&WORKDAY($A6,-3)) | ||
7 | 5' | COUNTIFS(' | !$F:$F, | $B$2 | ,' | !$G:$G,"N",' | !$C:$C,"<="&WORKDAY( | $A7 | ,-3)) | COUNTIFS('5'!$F:$F,$B$2,'5'!$G:$G,"N",'5'!$C:$C,"<="&WORKDAY($A7,-3)) | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J3:J7 | J3 | =CONCATENATE(B3,A3,C3,D3,E3,A3,F3,A3,G3,H3,I3) |