Prev: Average for last 30 days
Next: Help in macro coding
From: AllyH on 24 Mar 2010 08:28 I need to rank a column containing concatonated names and addresses. Ranking only handles numeric values, is there any way to give text a numeric value?
From: Mike H on 24 Mar 2010 08:54 Hi, It would have helped to see some test data but let's start from here. With your data in column A starting in A2 enter this in b2 and drag down =COUNTIF($A$2:$A$100,"<"&A2)+1 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "AllyH" wrote: > I need to rank a column containing concatonated names and addresses. Ranking > only handles numeric values, is there any way to give text a numeric value?
|
Pages: 1 Prev: Average for last 30 days Next: Help in macro coding |