Need Excel Help (Page 2)

Forum guidelines BT super discount
Other Resources My Cup of Joe » Need Excel Help Rss Feed  
Moderators: k9car363, the bear, DerekL, alicefoeller Reply
 
 
of 2
 
 
2008-08-21 9:06 AM
in reply to: #937984

User image

Veteran
1097
1000252525
Elizabethtown, KY
Subject: RE: Need Excel Help
Oh, and before I forget, here's an example file that illustrates both methods and shows how to count how many items occur 1, 2, 3, etc times.



Attachments
----------------
Counting Unique Values Example.xls (24KB - 3 downloads)

2008-08-21 9:21 AM
in reply to: #1618287

User image

Expert
1240
100010010025
Columbia, MO
Subject: RE: Need Excel Help
Thanks so much!!!!
2008-08-21 9:41 AM
in reply to: #1618287

Elite
3650
200010005001002525
Laurium, MI
Subject: RE: Need Excel Help
roch1009 - 2008-08-21 9:58 AM
bsjracing - 2008-08-21 9:47 AM

Some of the #'s have a last # of X will that change my formula requirements?

as in 123456789X 

It gets a little more complicated:

=SUM(IF(FREQUENCY(MATCH(Range,Range,0),MATCH(Range,Range,0))>0,1))

Best of luck (oh, and you really don't want to know how long it took to find this out the first time)

cripes, and I thought sql queries and regex were complicated

2008-08-22 3:35 AM
in reply to: #937984

User image

Master
2665
20005001002525
The Whites, New Hampshire
Subject: RE: Need Excel Help
You guys ROCK! I'm totally bookmarking this thread, too. I completely agree with the entirely worthless support - they never give you any more than the, "So you just figured out where the on button is, you are still learning about that mouse thing, and you are trying to set up a spreadsheet" answer. ARGH! Some of us really are more computer literate than that, but might actually still need help!
2008-08-22 7:18 AM
in reply to: #1620490

Elite
3650
200010005001002525
Laurium, MI
Subject: RE: Need Excel Help

Slugger - 2008-08-22 4:35 AM You guys ROCK! I'm totally bookmarking this thread, too. I completely agree with the entirely worthless support - they never give you any more than the, "So you just figured out where the on button is, you are still learning about that mouse thing, and you are trying to set up a spreadsheet" answer. ARGH! Some of us really are more computer literate than that, but might actually still need help!

yes, I hate tech support for that very reason, which is why the few times I've ever had to call, I've demanded to talk to tier 2 support.  It's fun calling comcast and trying to explain to a level 1 tech that their amp is out of balance and causing issues with your internet.

However, working in telcom and taking troubleshooting calls from time to time (about cable internet) I can tell you the people who call in claiming to be computer literate are the worst.  I cringe every time someone says they know about computers (or worse yet, they have a buddy that knows computers that set it up for them).  Those people are good for at least a 45 minute call to change IP settings.   I sometimes wish I recorded some of the calls though.  It's funny how people will string together buzz words to try and sound smart.

2008-08-22 8:32 AM
in reply to: #1620588

Subject: ...
This user's post has been ignored.

New Thread
Other Resources My Cup of Joe » Need Excel Help Rss Feed  
 
 
of 2