Re: Is this possible

Tech-Archive recommends: Fix windows errors by optimizing your registry

On 20 Nov, 10:18, Gary''s Student
<GarysStud...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Consider using AutoFiter:

Data > Filter > Autofilter > Custom... > Contains > SP

This will hide all entries that do not contain SP.  Finally use the
=SUBTOTAL() function to count the visible cells.

If the items in cells were separated by commas, then a macro could be
written to produce a complete tally for each individual code.

--
Gary''s Student - gsnu2007k



"bryan.del...@xxxxxxxxxxxx" wrote:
I don't know if this is possible. I have a column that I enter
different chars. i.e. 1, d,hd,au,ad,L, SP, P. These are entered on
their own. But I need to be able to enter two different items in one
cell. Everything gets counted. Now, what I want to try and do is this.
If I enter a 1 and P in the same cell, can I get it to count the 1 and
the P seperately and put the total in different cells? I could have a
large number of entries in 1 column of any combinations and each need
to be counted on their own merit. I don't have enough columns to be
able to use 1 column for each char. Or, if this can't be done, is
there any way I can get round this?
Your wise advice would be appreciated.
Bryan.- Hide quoted text -

- Show quoted text -

Gary, I like the idea of seperating with a comma, it can be any
combination of the various chars not just the SP & 1. What you suggest
sounds promising.
Maybe when I get to work I will post another message going into more
detail as to what I have already and the way it's working. Trouble is,
when I add something new to the workbook, someone comes up with the
bright idea to add a new feature that has to run with what has already
been done. So when I get to work I will post again. Thanks for your
input.
Bryan.
.

Relevant Pages

  • Re: Is this possible
    ... This will hide all entries that do not contain SP. ... If the items in cells were separated by commas, ... Gary''s Student - gsnu2007k ... able to use 1 column for each char. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Pop up to flag an entry
    ... You can use an event macro to create a popup when certain entries are made to ... Gary''s Student - gsnu200909 ... "Andrew Mogg" wrote: ... entries are made to cells. ...
    (microsoft.public.excel.misc)
  • RE: for xmas, i wish this is possible
    ... "dribler2" wrote: ... "Gary''s Student" wrote: ... Dim bright_green As Integer ' popular ... Now the used data cells are yellow and cells with formulas are bright green. ...
    (microsoft.public.excel.misc)
  • Re: If function not working correctly
    ... But it might be good practice to use ROUND in formulas prolifically, albeit prudently, throughout the worksheet; for example, in F2 and G2:U2, which Relle says are "all sum functions". ... entries), but this month it's cropped up after 6 rows. ... Sometimes you can see these differences by formatting the cells so that you can see 15 significant digits. ... What the ROUND function does is: it ensures that the result matches the internal representation of the number as if you had entered it manually. ...
    (microsoft.public.excel.misc)
  • Re: How to sort/update large excel db
    ... versions by "new" entries, those newest entries were ... You'll see True if it appears on that other worksheet. ... stuff usually means fix, check, fix, check....until you ... > cells someplace. ...
    (microsoft.public.excel.misc)