logandiana
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 107
Please help!
In my range data I have data:
Column A like red, blue, green, etc.
Column B has data like In Stock Warehouse A, In Stock Warehouse B, Out of Stock, etc.
Column C has account numbers stored as text like '12345, '12346, '12347, etc.
For my range criteria I have:
column A red
column B in stock?
column C <>12346
For the result:
I am getting everything red and in stock as expected, but the criteria in column C is not working and is returning all account numbers
I've tried
<>12346
<>'12346
="<>12346"
="<>'12346"
="<>"&"12346"
="<>"&"'12346"
I either get back no results or results that DO include account 12346
In my criteria for column C if I use just 12346 (to include it) then I do indeed get the 1 record back in the results.
But I can't figure out the proper syntax to exclude a number formatted as text.
Thanks
In my range data I have data:
Column A like red, blue, green, etc.
Column B has data like In Stock Warehouse A, In Stock Warehouse B, Out of Stock, etc.
Column C has account numbers stored as text like '12345, '12346, '12347, etc.
For my range criteria I have:
column A red
column B in stock?
column C <>12346
For the result:
I am getting everything red and in stock as expected, but the criteria in column C is not working and is returning all account numbers
I've tried
<>12346
<>'12346
="<>12346"
="<>'12346"
="<>"&"12346"
="<>"&"'12346"
I either get back no results or results that DO include account 12346
In my criteria for column C if I use just 12346 (to include it) then I do indeed get the 1 record back in the results.
But I can't figure out the proper syntax to exclude a number formatted as text.
Thanks