auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
I am working with several hundred rows of data that look much like what is shown below.
I need to extract every instance where the named ranges start with 'A' and end with 'C5'. I considered listing all the names in the name manager and using them, but there are nearly 7,000 named ranges. I need only a few hundred that are used in formulas like shown above. How can I extract the names that are included in a range of formulas? They all all start with 'A' and end with 'C5'? Ideally, I simply need to list them all in a single column.
Thanks in advance.
=IF(B8>=DATEVALUE("06/30/2006"),Calc(A714A_C5,A705A_C5+A705B_C5+A704D_C5)*100,IF(B8>=DATEVALUE("03/31/2004"),Calc(A772_C5+A773_C5+A774_C5,A705A_C5+A705B_C5+A704D_C5)*100,"N/A")) |
=IF(B8<DATEVALUE("6/30/2006"),IF((A706_C5+A708B_C5)=0,0,((A756_C5+A757_C5+A758_C5)/(A706_C5+A708B_C5))*100), IF((A706_C5+A708B_C5)=0,0,((A715A_C5)/(A706_C5+A708B_C5))*100)) |
I need to extract every instance where the named ranges start with 'A' and end with 'C5'. I considered listing all the names in the name manager and using them, but there are nearly 7,000 named ranges. I need only a few hundred that are used in formulas like shown above. How can I extract the names that are included in a range of formulas? They all all start with 'A' and end with 'C5'? Ideally, I simply need to list them all in a single column.
Thanks in advance.
Last edited by a moderator: