AntBlabby8
Board Regular
- Joined
- Apr 18, 2002
- Messages
- 200
For each row, I have four columns labled Q1, Q2, Q3, Q4 which represents the shipping quarter for each customer. Under the appropriate shipping quarter, I have an alpha identifier (for one of more than a dozen products). The other quarters for that rowis blank. I want to pull all the alpha identifiers under a single column to the Right, regardless of the quarter column its in to start with. What is a formula to take the text in whichever of the four columns it falls into?
Thanks.
Thanks.
