Forum Discussion
Solved
Excel Protect Workbook feature not working
As I have done in the past, I am trying to protect sensitive information via Info/ 'Protect Workbook' /Encrypt with Password. After entering the password twice, it gives me the message 'A password is...
For such layout
if you are on Excel with Dynamic Array that could be
in E2
=TRANSPOSE(UNIQUE(B3:B9))in E3
=FILTER($C$3:$C$9,$B$3:$B$9=E$2)and drag to the right.
Another option with more traditional functions
In I2
=IFERROR(INDEX($B$3:$B$9,AGGREGATE(15,6,1/(COUNTIF($H$2:H2,$B$3:$B$9)=0)*(ROW($B$3:$B$9)-ROW($B$2)),1)),"")in I3
=IFERROR(INDEX($C$3:$C$9,AGGREGATE(15,6,1/(COUNTIF(I$2:I2,$C$3:$C$9)=0)/($B$3:$B$9=I$2)*(ROW($C$3:$C$9)-ROW($C$2)),1)),"")and drag to the right and down.
Power Query also could be an option.
I figured out what the problem is. Files saved as .csv apparently cannot be password protected.
Hi Veronica,
Glad to hear that you have figured it out yourself.
I'd like to add that most of Excel functionalities cannot be saved with the .csv file extension!
Because this extension is intended to save raw data only!
It's often used in exporting raw data from some external sources to Excel!
Regards,
Haytham
Thank you Haytham!