RE: Unique data
- From: Steven Patrick <StevenPatrick@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 May 2008 13:30:12 -0700
Thanks for the response. In a nutshell, using the "find <control> F" as in,
find and replace, I can call up the unique identifier for a customer by
typing in the alpha-numeric data. "ABC123" is typed in and by clicking "find
all" on the find screen, the number of visits is registered in the results
window.
The results window has the following columns:
Book | Sheet | Name | Cell | Value |
Formula
--------- --------------- ---------------- ------------- ---------------
---------------
***xls | April | | $Q$35 | ABC123 |
***xls | March | | $B$10 | ABC123 |
***xls | February | | $G$50 | ABC123 |
(Hopefully the spacing doesn't compress)
I can get data in all the columns except the name column. How do you get
something to register in the "name" column. I was thinking that I needed to
name the range, and this is where everything gets fuzzy. I have 9 (possibly
more later) services I offer to ABC123 and I would like to detail which
service was performed in the name column either by service name or service
number identifier (1 - 9.)
So, on the spreadsheet, each day is a column and each customer is placed in
one of nine catagories based on which service they received. I would like to
keep a 6 to 12 month history of their visits with the possibility of offering
incentives based on the frequency of visits and service type.
In theory, in the time it takes to do a credit card transaction, I would
like to plug in 1 unique identifier and be to offer either a "service upgrade
/ discount for service" without getting a database full of other information
that on a busy day there would not be time to collect.
Thanks in advance.
Steve
"Wehrmacher" wrote:
Hi Patrick,.
I came across this note in Excel help when I was looking for a different
"unique" problem. Why don't you pop "Count unique values among duplicates"
into help and look at the help item with that name. It talks to summing
cells with difined values. I expect that it would span an entire workbook.
Sorry, but I didn't look to see if it would do what you wanted, partially
because I don't think I fully understand the issue.
Hope it helps.
--
Bill Wehrmacher
"Steven Patrick" wrote:
I have started a workbook with each page being a month. On each page, each
column being a day. Each column has identifiers (labels) being a sub-catagory
by service type purchased for each unique customer.
I would like to (so far, I found the <cntr> F) identify visit frequency by
customer, date and service type without creating the left to right access
type database. The find screen can identify month, day, with frequency, but
not service type (I thought - naming the range) due to syntax error or
physical impossibility of that function.
If this has already been discussed, I missed the topic, but would appreciate
the link.
- Follow-Ups:
- RE: Unique data
- From: Wehrmacher
- RE: Unique data
- References:
- Unique data
- From: Steven Patrick
- RE: Unique data
- From: Wehrmacher
- Unique data
- Prev by Date: RE: Unique data
- Next by Date: Re: vlookup sound alike
- Previous by thread: RE: Unique data
- Next by thread: RE: Unique data
- Index(es):
Relevant Pages
|
