Hi
I created a column which has a drop down with the option of choosing the word blister or loose.
What I would like to do is set the value of the cell to 1 if either word is chosen or the value would be zero if cell was left blank.
Any help would be greatly appreciated
So you have a cell, let's say A1 and you used Data Validation to put a dropdown of blister or loose. Yes? But you don't want A1 to show Blister or Loose, you want it to show 1 or 0 (if nothing is chosen)? Since this column of dropdowns already exists, would they all read zero now or only after something on the same row is entered?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
what i really want is the column to show either nothing,blister, or loose and at the bottom of the column to show how many cells had the words blister or loose
This is a database for a collectible which is available in a blister pack or you could have it opened (loose). My end result is I want to know how many items there are either in blister or loose.
Hope that makes sense
You would use a formula like so (assuming data in B2:B1000)
andFormula:
=COUNTIF($B$2:$B$1000, "blister")
Does that work for you?Formula:=COUNTIF($B$2:B$1000, "loose")
That works perfectly!
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
garyw383 
Register To Reply
Bookmarks