Forum Discussion
Need help to populate table from tally table
Hi I am trying create a table that populate the analysis table from the Tally table but It sounds like a complicated formula. I have attached the excel sheet with how I would like the analysis she...
Hi
Thanks for you answer.
However you have summed up the number of occurrences that id1 blue has. In the table you uploaded u have got 3 however it should b jus 1.
Please could you have a look at the original excel file I uploaded. The analysis table should look like the same but using formula.
Kind regards
Thanks for you answer.
However you have summed up the number of occurrences that id1 blue has. In the table you uploaded u have got 3 however it should b jus 1.
Please could you have a look at the original excel file I uploaded. The analysis table should look like the same but using formula.
Kind regards
It's done with this formula:
=IF(SUMIFS(B$3:B$11,$A$3:$A$11,$I3),1,"")
Hope that helps!