# Frequency function with text

#### Sukhvinder Singh

##### New Member
Hi everyone,
below are two columns and I want result from column1 like below here in the RESULT column, I can't use frequency function because values are not strings. Could you please help me here?
 COLUMN1 RESULT SVC-1 2 SVC-1 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 SVC-13 2 SVC-13 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0

<colgroup><col><col></colgroup><tbody>
</tbody>

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
 COLUMN1 RESULT SVC-1 2 sorted count the different SVC-1 0 items FALSE 0 FALSE 0 FALSE 0 SVC-1 2 FALSE 0 SVC-1 2 FALSE 0 SVC-13 2 SVC-13 2 SVC-13 2 SVC-13 0 FALSE 7 FALSE 0 FALSE 7 FALSE 0 FALSE 7 FALSE 7 FALSE 7 FALSE 7 FALSE 7 or just use a pivot table

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 COLUMN1 RESULT after Match function =match(range,range,0) then frequency =frequency(match(range,range,0), match(range,range,0)) SVC-1 2 2 2 sorted count the different SVC-1 0 2 0 items FALSE 0 3 7 FALSE 0 3 0 FALSE 0 3 0 SVC-1 2 FALSE 0 3 0 SVC-1 2 FALSE 0 3 0 SVC-13 2 SVC-13 2 8 2 SVC-13 2 SVC-13 0 8 0 FALSE 7 FALSE 0 3 0 FALSE 7 FALSE 0 3 0 FALSE 7 FALSE 7 FALSE 7 FALSE 7 FALSE 7 or just use a pivot table

<tbody>
</tbody>
I can't, I just need a logical formula for this. I can use match function and then frequency function but it'll give me the count of cells which contain false value that I don't

I can't use pivot, I just need a logical formula for this, I can use match function and then frequency, but it'll get the value of cells which contain false that I don't want. You can see below

 COLUMN1 RESULT match Frequency SVC-1 2 2 2 SVC-1 0 2 0 FALSE 0 5 5 FALSE 0 5 0 FALSE 0 5 0 SVC-13 2 7 2 SVC-13 0 7 0 FALSE 0 5 0 FALSE 0 5 0

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

Maybe - Notice that formula in B3 is different than formula in B2. Formula in B3 would be copied down.
Excel Workbook
AB
1COLUMN1RESULT
2SVC-12
3SVC-10
4FALSE0
5FALSE0
6FALSE0
7FALSE0
8FALSE0
9FALSE0
10SVC-132
11SVC-130
12FALSE0
13FALSE0
14FALSE0
15FALSE0
16FALSE0
Sheet

 COLUMN1 RESULT SVC-1 2 SVC-1 0 FALSE 0 FALSE 0 FALSE 0 col H FALSE 0 FALSE 0 SVC-13 2 SVC-1 2 2 ROW 9 SVC-13 0 SVC-1 2 row 10 FALSE 0 #N/A FALSE 0 #N/A #N/A #N/A SVC-13 3 3 SVC-13 3 SVC-13 3 #N/A #N/A the word false is a special word in excel so I replaced with #n/a using ifiserror ignores the #n/a's in the list this formula FOR THE FIRST ITEM IN THE LIST IN COLUMN H =IF(G9="","",G9) THIS FORMULA FOR THE SECOND ITEM IN THE LIST, DRAGGED DOWN COLUMN H OF COURSE =IF(G10="","",IF(G9="",G10,IF(AND(F10=F9,G10=G9),"",G10)))

<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>
</tbody>

Replies
1
Views
213
Replies
6
Views
175
Replies
1
Views
88
Replies
3
Views
80
Replies
1
Views
53

1,203,455
Messages
6,055,541
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back