How to enter more than one value in MS excel cell?

Question

I have an excel sheet where in 1 column I have different company names and in another column the category it belongs to (in a drop down list).

I want to assign each company a category. But some companies fall into more than 1 category, how can I enter both or more categories against the company?

For example, company = General Electric, category (drop down list) = Energy, Healthcare, appliances. How can I assign all 3 values to General electric.

Answer 1

by entering data in the form of Constants Array

for example



={10, 20, 40, 100, 140, 189, 100}



if you want see all elements



select 7 cells in a row for example A1:G1

put this formula into the formula bar

press : Ctrl + Shift + Enter

Answer 2

Use separate columns for each category. Combining all the categories into one cell just makes a hash out of being able to easily use the information.

Answer 3

The word "cell" means a single unit. You cannot put several values into a single cell. You need to have several columns with the dropdown list, and for the Companies that have more than one category, you need to use more than one column.

Answer 4

i'm an Excel means person and that i do no longer understand what you're trying to finish, notwithstanding, i am going to provide you with a formula that couldn't provide you with an blunders if a cost is null (clean): =if(B1="",0,C1) it truly is an celebration of a conditional formula - what it says is: if cellular B1 is clean then the price of this formula is 0, otherwise if B1 is something else than 0 the price is the same as cellular C1 =(situation, what to do if situation authentic, what to do if situation pretend) - in case you provide me some rows of records i'd be in a position that would want to help you extra. FYI once you style those costs into the formula be sure there aren't to any extent further any areas between them. you should use the formula I in simple terms gave you except use the outstanding cellular references =if(G3="",0,G3) this offers you you with a nil if g3 is clean, once you replica it down the g3 could substitute to g4 the subsequent row down. this may restore your problem yet i imagine you're in simple terms no longer copying your formula properly.

Answer 5

go to ms-office help