I can't figure out how to do this other than manually. Can you help me figure it out?
When there are three items listed in column P, I would like to have them entered in Columns AF:AK. When Column P has more than three items, I would like Columns AF:AK shaded in a color (light gray is okay).
When there are four items in Column P, I would like to have them entered in Columns AM:AV. When Column P does not equal to four items, I would like Columns AF: AK shaded in a color (light gray is okay)
Please supply a workbook with sample data and examples of your expected outcomes, and cover all scenarios.
Thanks
Phil
The request has changed somewhat. I would like for the data in Column U to pair up with the data in Column V. Where there are three items listed in Column U, I would like to have them entered in Columns AF:AK. When there are four items listed in Column U, I would like to have them entered in Columns AF:AO. Expected results are listed in the spreadsheet.
I added the attachment, wasn't sure if it was received previously. It might be a little different, but the concept / expectation is still the same.
Thanks
Hi Melinda
You already have the fixed formulas in all the columns.
Now you only need to check the length of the cell in column U to determine which of the formulas to use in each column.
I suggest you remove the comma in columns U and V as they are not necessary and in certain case make your formulas a bit longer
e.g. MID($U16,1,1)&MID($U16,1,3) could have been written as MID($U16,1,2) when the comma in U16 is removed.
Not sure about your cell color but conditional formatting (by checking on the length of column U) should do the trick.
I think in future you should redefine your needs again if you post a new file as it is very confusing for us to try to "map" the new file against your "old" requirements as the columns are different.
Sunny
Perfect!! Thank you
