Data Validation Circle Usage

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
3,327
Morning,
I have 2 columns as explained below.
Column J consists of values like Z159, R235, P004, N/A

Column L consists of values like JHMCN129357842S87, N/A

The columns have a drop down where the only selectable option is N/A

When i use the Data Validation Circle Invalid Data option i see a message telling me that there are more than 255 results etc & cant show them all.

Because of this i dont get to see where my real issues are.
How can i get around this please.
Having the values mentioned above in a drop down will never be possible.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,661
Hi ipbr21054

What are your invalid values? How do you recognise these?
Perhaps a macro can do the selection for you and highlight those cells with a different colour, even if there are a million...
 

Watch MrExcel Video

Forum statistics

Threads
1,099,505
Messages
5,469,017
Members
406,628
Latest member
jared92

This Week's Hot Topics

Top