“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hi
I am looking for your help with formula in finding out the similar opposite values in a big data sheet. I have attached the sample worksheet where row no. 2 and 5 have similar opposite value as well as row no. 2 and 10 have similar values. I want to find out either row 2 and 5 or 5 and 10 so that the sum of 2 items found is 0

Solved by B. W. in 22 mins

Hi I am looking for your help with formula in finding out the similar opposite values in a big data sheet. I have attached the sample worksheet where row no. 2 and 5 have similar opposite value as well as row no. 2 and 10 have similar values. I want to find out either row 2 and 5 or 5 and 10 so that the sum of 2 items found is 0

Solved by G. D. in 20 mins

Hi,
Pls connect me to EHB
Hi I am looking for your help with formula in finding out the similar opposite values in a big data sheet. I have attached the sample worksheet where row no. 2 and 5 have similar opposite value as well as row no. 2 and 10 have similar values. I want to find out either row 2 and 5 or 5 and 10 so that the sum of 2 items found is 0

Solved by O. Q. in 27 mins

I want summarise find desprencies in employee timesheet, could you please help?

Solved by Z. F. in 13 mins

I CAN'T FIND THE DOCUMENT I SAVED ? HELP

Solved by S. E. in 13 mins

What's the easiest way to find the range of the data of two data that contain with the total sales quantity and return sales quantity by simply a click of sale item name (like Pivot Table)?

Solved by S. Y. in 11 mins

Hi want to find the descrepencies in the two report.
Please help

Solved by M. B. in 15 mins

I am trying to find the weighted average excel with a group of date.

Solved by I. J. in 16 mins

I am trying to find an option , for automatically populating data on a word document from an excel sheet.Not sure how to do it at all. Would really need some help on this please!!

Solved by B. W. in 29 mins

I have one set of invoice #'s and the subtotal $ amount associated with that invoice # (2 columns of data) from one accounting software program and another set of invoice #'s and subtotal $ amounts from another accounting software program.
So, Column A = invoice #'s from quickbooks
Column B = the subtotal $ amount associated with the invoice # in the same row in Column A
Column D = invoice #'s from shopworks
Column E = subtotal $ amounts associated with the invoice # in the same row in column c
I need to find out the following
-- which invoice #'s are in Column A that aren't in Column D
-- which invoice #'s are in Column D that aren't in Column A
-- for invoice #'s that are in Column A and also in Column D, which of these have subtotal amounts that don't match up.. (for example: if invoice #15113 appears in column A and D, but the subtotal amount associated with 15113 is different in column B and column D, I need to know the invoice # of the discrepancy so I can investigate discrepancy.)

Solved by E. Y. in 20 mins