Che_Broludo
New Member
- Joined
- Sep 12, 2019
- Messages
- 9
Hello all! I have spent hours searching and trying to figure this out on my own—no dice. So I turn to the fine folks of this forum.
To boil it down, I need code that performs the following action:
if C1 is all-caps, D1 is TRUE;
if C1 is not all-caps, D1 is FALSE;
if C1 is empty, D1 remains empty
Easy, right?
It would be, if I had a normal-sized spreadsheet with just four columns (A, B, C, and D). However, I'm working with very large spreadsheets containing dozens or hundreds of columns.
Column A contains a unique identifier code, but the rest of the spreadsheet consists of the same three column types, repeated over and over. So for the next batch, replace B1 with E1, C1 with F1, D1 with G1, etc.
(The content of the "first" columns—B, E, H, etc.—doesn't concern us. It's the "second" and "third" columns I care about: C informs D; F informs G; I informs J . . . ad infinitum.)
The sheer size of these spreadsheets introduces two challenges. The first is fairly obvious: unless I automate this, I'll spend the rest of my life going column by column. The second: there are too many cells in the range for Excel to handle in one go; it will crash (OUT OF MEMORY) unless the code is written so it only tackles a portion at a time.
This is as far as I've gotten: =IF(ISBLANK(C2),"",EXACT(C2,UPPER(C2)))
That would work fine for me if I just had a small spreadsheet, but I don't know how to scale it.
Any tips?
Thank you.
To boil it down, I need code that performs the following action:
if C1 is all-caps, D1 is TRUE;
if C1 is not all-caps, D1 is FALSE;
if C1 is empty, D1 remains empty
Easy, right?
It would be, if I had a normal-sized spreadsheet with just four columns (A, B, C, and D). However, I'm working with very large spreadsheets containing dozens or hundreds of columns.
Column A contains a unique identifier code, but the rest of the spreadsheet consists of the same three column types, repeated over and over. So for the next batch, replace B1 with E1, C1 with F1, D1 with G1, etc.
(The content of the "first" columns—B, E, H, etc.—doesn't concern us. It's the "second" and "third" columns I care about: C informs D; F informs G; I informs J . . . ad infinitum.)
The sheer size of these spreadsheets introduces two challenges. The first is fairly obvious: unless I automate this, I'll spend the rest of my life going column by column. The second: there are too many cells in the range for Excel to handle in one go; it will crash (OUT OF MEMORY) unless the code is written so it only tackles a portion at a time.
This is as far as I've gotten: =IF(ISBLANK(C2),"",EXACT(C2,UPPER(C2)))
That would work fine for me if I just had a small spreadsheet, but I don't know how to scale it.
Any tips?
Thank you.
