excel query.....

Replies (2)

 

IT CAN BE INSERTED IN XL BY DATA VALIDATION OPTION….                        
                         
Once you decide what validation you want to use on a worksheet, you can set up the validation by doing the following:                        
Select one or more cells to validate.                        
On the Data tab, in the Data Tools group, click Data Validation.                        
                         
                         
                         
1. The Data Validation dialog box is displayed.                        
2. Click the Settings tab.                        
3. To specify the type of validation that you want, do one of the following:                        
 
                       
1. In the Allow box, select List.                        
2. Click the Source box and then type the list values separated by the Microsoft Windows list separator character (commas by default).                        
For example:                        
                         
To limit entry to a question, such as "Do you have children?", to two choices, type Yes, No.                        
To limit a vendor's quality reputation to three ratings, type Low, Average, High.                        
 Note    The widtth of the drop-down list is determined by the widtth of the cell that has the data validation. You may need to adjust the widtth of that cell to prevent truncating the widtth of valid entries that are wider than the widtth of the drop-down list.                  
Make sure that the In-cell dropdown check box is selected.
 
                       

The symbol you have figured out will be of several things: -

1. As said by Mr. Sourav. and 

2. When you will filter the data you will get the same symbol.

Further if you have any specific requirement to know then kindly elaborate.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details