would appreciate your help. thanks

  • Thread starter Thread starter etks
  • Start date Start date
E

etks

I have a spreadsheet that contain a column on the company name and th
next on vendor selling them. Ples refer to attach excel file. I woul
like to count how many company names I have in the spreadsheet withou
having to do it manually. The actual file is huge, going down until
about 2,000 over rows and it does take up a lot of my time to count i
and the company name does not stay stagant (i.e. I keep adding wheneve
there's a new one or delete).
Appreciate your help. Thanks

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47149
 
Hi
first a kind remark: Please try to describe your problem in plain
text - in your case there is no need for an attachment. Reasons for
this:
- most people won't look at attachments -> not that much responses
- Google archives the (text) discussions but I doubt your attachment
link will be available that long

but now to your question:
- Create a new name 'RANGE2' which references $E$4:$E$19 (your date
column)
- Now enter the slightly adapted array formula:
=SUM(IF(FREQUENCY(IF((LEN(RANGE1)>0)*(RANGE2>DATE(2003,9,15)),MATCH(RAN
GE1,RANGE1,0),""),IF((LEN(RANGE1)>0)*(RANGE2>DATE(2003,9,15)),MATCH(RAN
GE1,RANGE1,0),""))>0,1))
 
Back
Top