LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 465
Default Comparing two columns , and giving comparison results in a third.


Hi All

I have small request for assistance.

In Column A , I have a row of numbers. In column C I have a row of
numbers too , with a formula underlying each.

I need , in column D , for the numbers in A and C to be compared and a
plus sign to be placed in the cells where C is bigger than A , a minus
where C is smaller than A , and an equals sign where C is the same as A.



Can someone help on this , please? Grateful for any assistance.



Best Wishes
 
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
TRUNC zero giving odd results? [email protected] Excel Worksheet Functions 5 August 24th 06 05:26 PM
Very large workbook now giving incorrect results :( [email protected] Excel Discussion (Misc queries) 0 July 17th 06 11:29 PM
Very large complex workbook is now giving me the wrong results :( S Davis Excel Worksheet Functions 0 July 17th 06 09:00 PM
Comparing contents of two spreadsheets and outputting results to a brx Excel Worksheet Functions 5 March 17th 05 01:44 AM
Equation giving unexpected results Mike K Charts and Charting in Excel 2 January 27th 05 02:58 PM


All times are GMT +1. The time now is 05:28 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"