{ "media_type": "text", "post_content": "Can someone please tell me the formula for finding all values that net to zero?", "post_id": "5f971424ec3e530021bfb21c", "reply_count": 16, "vote_count": 3, "bowl_id": "564a5cdb94887803001dd07c", "bowl_name": "Accounting", "feed_type": "crowd" }
null
Posting as :
works at
You are currently posting as works at

## Should I keep going ?

Lol KPMG 1 is stoopid

## I think you’re thinking of the solver function in excel - it’s an add-on that takes some skill to use but you can use it to “solve” for zero.

Tried that, but the population is too big :/

## I apologize as these instructions may be hard to follow, but I figured out this method when I had to net 32,000 line items from Operating Expense testing detail. I wish you the best of luck.1) Assign Absolute Value to Amount Column2) Sort the absolute value column by largest to smallest3) Create additional column4) Merge EVERY two cells together in the new column (i.e. combine cells 1 and 2; 3 and 4; 5 and 6)5) Use the formula =cell1 + cell2 in the newly merged cells6) Create additional column7) Use the following formulas in cells 1 to 4 in this ordera. =If ( Cell 1 = 0 , “TM” , “” )b. =If ( Cell 1 = 0 , “TM” , “” )c. =If ( Cell 3 = 0 , “TM” , “” )d. =If ( Cell 3 = 0 , “TM” , “” )8) After you have that sequence so that it will do rows 1, 3, 5, 7 etc… highlight the 4 formulas you just created and copy paste them to the bottom.9) That should net many duplicatesIf you need to remove even more entries do the next steps:1) Clear all filters2) Sort the data by the TM column so that all TMs are at the top (TMs were created in step 7 above).3) Start the above process over again starting at the first line item that does not have a TM.4) Repeat until you remove duplicates.

=countif

Yeah, I’ve had only limited success with the solver function. That’s the only thing that I’m aware of that fulfills that function.

Send to your offshore team in india

Or filter for 0

Or conditional formatting to find 0

Add a column. Take abs value of original data. Sort and see which ones net. Can get fancy with if cell in row 2 - cell in row 1 = 0 to help but might not be exact

Excel power query

## Additional Posts in Accounting

Me: I hate office drama!
Also me:

Really wish this became the norm

What is the level Amazon India offers for 8+ years experience developer ? Is it level 5 or 6 ?

I got offer for project specialist at Deloitte. Can any one help hierarchy of designations and wha my type of work mostly it will be?Deloitte

I am a data scientist with 8 yeo.
I have offer from
EXL Service and Absolutdata
Both are offering the same package.
Any suggestions which one to go with?

## Additional Posts (overall)

What is CohnReznick paternity leave policy?

What’s the typical accounting career path?

Has anyone gone CAIA route ?

### New to Fishbowl?

unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
• Discover what it’s like to work at companies from real professionals
• Get candid advice from people in your field in a safe space
• Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Share

#### Embed this post

Copy and paste embed code on your site

Preview