Forum Discussion

RMofMWHD's avatar
RMofMWHD
Copper Contributor
Mar 18, 2023

Column format

I want to make Column C follow the format of column A.   From this: A B C D E X    X       X X    X X    X    X   To this: A B C D E X    X        X    X X    X   X    X Though m...
excel
Formulas and Functions
Hecatonchire's avatar
Hecatonchire
Iron Contributor
Mar 18, 2023

RMofMWHD 

 

=IF(A2="","",INDEX($C$2:$C$5,COUNTA(A$2:A2)))

 

Then, copy and paste value

 

Resources