re: Help with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2803945%22%20slang%3D%22en-US%22%3Ere%3A%20Help%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2803945%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20trying%20everything%20I%20know%20of%20and%20have%20hit%20a%20brick%20wall.%26nbsp%3B%20%26nbsp%3B%20I%20am%20trying%20to%20remove%20the%20entry%20in%20the%20Area%20column%20(Q)%20if%20Function%20Room%20(I)%20is%20a%20duplicate%20within%20the%20Booking%3ABooking%20ID%20(E).%26nbsp%3B%20%26nbsp%3BBasically%20if%20the%20same%20room%20exists%20multiple%20times%20within%20the%20same%20Booking%20ID%20group%2C%20I%20don't%20want%20to%20count%20it's%20area%20in%20the%20total%20space%20calculation%20more%20than%20once.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2803945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2804142%22%20slang%3D%22en-US%22%3ERe%3A%20re%3A%20Help%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172609%22%20target%3D%22_blank%22%3E%40KCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWill%20it%20work%20if%20instead%20of%20summing%20area%20in%20values%20move%20it%20to%20rows%20area%20after%20ID%20%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20378px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314463iF755C7C674265A6B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@KCortez 

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

image.png

@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