re: Help with formulas

New Contributor

I have been trying everything I know of and have hit a brick wall.    I am trying to remove the entry in the Area column (Q) if Function Room (I) is a duplicate within the Booking:Booking ID (E).   Basically if the same room exists multiple times within the same Booking ID group, I don't want to count it's area in the total space calculation more than once. 

3 Replies


Will it work if instead of summing area in values move it to rows area after ID ?


@Sergei Baklan  that would work - how do I do that?


I responded too soon - it's in the pivot so I'm good to go - thank you