0 votes
I need a formula that counts both the total amount of characters in a cell and the frequency with which those characters appear.

For instance, in column A

201, 202, 203, 204, 205, 1001, 1002, 1003, 1004, and 1005 are the numbers in a set of ten cells.

Five cells have three characters, while five cells have four. What would the answer to this be? I'm not sure how many characters in each cell I would need to count, but I'm thinking that will be a simple formula edit in the future.
Nov 21, 2022 in Others 53 views

## 1 answer to this question.

0 votes

With data in column A, in B1 enter:

=SUMPRODUCT(--(LEN(A:A)=ROW()))

Then copy downwards:

I hope this helps you.

answered Nov 21, 2022 by
• 53,160 points

0 votes
1 answer

## Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

0 votes
0 answers

## What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

0 votes
1 answer

## How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

0 votes
1 answer

## MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

0 votes
0 answers

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

0 votes
1 answer

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

0 votes
1 answer

## Excel formula to get cell color

Add a Name(any valid name) in Excel's ...READ MORE