DrJ Posted February 25, 2008 Share Posted February 25, 2008 I can never remember how to do this: I have a db with fields for five kids,each kid a first name and age: "John (12)". I need to kick out a line that's blank or names the kids: John (12), Joan (11), Jennie (10), etc. Not all families have kids. I know how to do the if: a. =IF(C2>"",C2&IF(D2>"",", "&D2&IF(E2>"",", "&E2&IF(F2>"",", "&F2&IF(G2>"",", "&G2&IF(H2>"",", "&H2,""),""),""),""),""),"") b. or should I use a Case series -- which I've never used before. How would that work? Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.