LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default How Do I Identify 1 to 1 Offsetting Entries in a List?

I have a list of 100-200 numbers to reconcile every day, some of these
offset each other, is there a quick way to identify which do and have
them highlighted? The example below shows two entries that have
corresponding offsets, e.g., 1944.09 and 7418.25. The offsets are
always 1 to 1, meaning there is never a combination of numbers equal to
one number. Naturally looking for duplicates doesn't work as I am
comparing positive to negative numbers.

Example:

-1944.09
250
1944.09
125
54.69
880
546.25
7418.25
6521.58
470.45
-7418.25
63.00
1115.42

Thanks in advance!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare two worksheets and identify common entries MarkT Excel Discussion (Misc queries) 3 November 8th 07 01:09 AM
how to identify unique list of 200 random entries from a list of 3 tjb Excel Worksheet Functions 3 August 13th 07 02:15 PM
Need to identify duplicate entries in a Table bman342 Excel Worksheet Functions 6 July 6th 06 09:33 AM
How can you identify duplicate entries in a singe column? Melissa Excel Worksheet Functions 3 January 4th 06 09:20 PM
How to identify entries in a matrix also present in another list larkindale Excel Worksheet Functions 2 September 16th 05 07:07 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"