Hi, I have this population .csv (look at the pic) file and I need to get a column with the information of the prevailing age class for each row. The age groups range from P14 to P29. I'm not an expert and the only result I managed to get is a column with the maximum of all values with the formula =+MAX(etc..).
To explain myself better I'll give an example, in the cell where the number 7 appears I need the name of the column P25 instead.
I hope I have explained my problem correctly, thank you in advance whoever will take the time to help me.
Immagine 2022-11-24 175159.png
Bookmarks