Multiple responses for a column

  • Thread starter Thread starter JMN
  • Start date Start date
J

JMN

Dear helpers,

I have one column where I want my Sales Reps to list their top ten accounts.
What is a good suggestion for organizing this data?

Is there a code for where one adds a comma a new cel is created?
Is there a way to make add in responses appear as a drop down list?

I can just have the user separate the accounts by a comma, I just thought
there might be something better that I do not know about.

Thanks!
 
Why not columns (possibly entered using a form):

Sales Rep: Account Number; Qty Sales; Sales Value etc.

This tells your Sales reps what data is required you can easily Pivot the
result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct Column B based on Column A 3
Histogram/Frecuency for Multiple Response Questions 1
summing only certain rows 2
text to columns - break by delimiter 4
Drop down need to validate information 5
Merging multiple columns into one column (dynamically) 1
Moving Text from Word to Excel (and having it set into 2 columns) 4
Open CSV In One Column or Multiple Columns? 2

Back
Top