Forum Discussion

rohithvr's avatar
rohithvr
Copper Contributor
Nov 12, 2023

How to Display Repeated Numbers First Digit from B2 to S2 in U2 Cell?

I have a Excel Sheet containing 2 digit numbers in B2 to S2. Now I want to display the First digit of each repeated number ( if they repeat 2 or more times only ) with parenthesis In U2 cell. Ex: If ...
Excel
Formulas and Functions
rachel's avatar
rachel
Steel Contributor
Nov 12, 2023

rohithvr 

 

Hi,

 

I think you can first add a helper column to get "first digit", and then add another column to count the number of occurrences of the "first digit".

 

I attached an example based on your data.

Resources