We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

Excel Query

Cotta

Cotta Posts: 3,667 Forumite

22 October 2014 at 4:55PM in Techie Stuff

Hi All,

I have a list of names in column B along with some blank cells, I want to input a formula into column C that will display the word "Ungrouped" if the cell is blank other wise I want the word "Grouped" displayed. Is this possible and if so how do I go about it?

Thanks

0

Comments

Linton Posts: 17,646 Forumite

22 October 2014 at 5:01PM

Put in C1:

=IF(B1="","Ungrouped","Grouped")

Copy and paste this into every other relevant cell in Column C.

0
Cotta Posts: 3,667 Forumite

22 October 2014 at 5:07PM

Perfect, thanks. I tried to overcomplicate things.

0

This discussion has been closed.

★ ★ ★ Meet your Ambassadors

Categories

All Categories
346.2K Banking & Borrowing
251.2K Reduce Debt & Boost Income
451.1K Spending & Discounts
238.2K Work, Benefits & Business
613.4K Mortgages, Homes & Bills
174.5K Life & Family
251.4K Travel & Transport
1.5M Hobbies & Leisure
16K Discuss & Feedback
15.1K Coronavirus Support Boards

MSE News

Morrisons shopper? You can now book your Christmas delivery slot – here's how
Planning on getting your Christmas food shop from Morrisons? You can now bag your delivery or click & collect slot as bookings have opened for all shoppers today (Wednesday 9 October).
Last chance: Stock up on first-class stamps now before prices rise by 22% from 7 October
You've got just days left to stock up on standard first-class stamps before prices rise by an inflation-busting 22% from Monday 7 October. If you buy some now, you'll still be able to use them after prices go up.
Disney+ to charge up to £60 a year more if you share your account – here’s what you need to know
If you share your Disney+ account with friends or family who don't live with you, you'll now need to pay up to £4.99 a month extra to do so, as the streaming service has clamped down on password sharing.
Disney+ to charge up to £60 a year more if you share your account – here’s what you need to know
If you share your Disney+ account with friends or family who don't live with you, you'll now need to pay up to £4.99 a month extra to do so, as the streaming service has clamped down on password sharing.
Disney+ to charge up to £60 a year more if you share your account – here’s what you need to know
If you share your Disney+ account with friends or family who don't live with you, you'll now need to pay up to £4.99 a month extra to do so, as the streaming service has clamped down on password sharing.
How to keep fit for FREE
Getting something totally free is likely to get a true MoneySaver's heart pumping faster than any cardio workout ever could. But, if that's not enough, I've rounded up 20+ ways you can exercise and get fit without spending a penny, both outdoors and at home.
Get 'paid' to walk using free apps
Walking has great value – not just to your health, or to the environment, but also monetary value. This is because there are a plethora of free apps (or ones you can use if you have certain health/life insurance plans) that effectively pay you to walk.
Get 'paid' to walk using free apps
Walking has great value – not just to your health, or to the environment, but also monetary value. This is because there are a plethora of free apps (or ones you can use if you have certain health/life insurance plans) that effectively pay you to walk.