If Function
Hi, What I want to do is get excel to compare a reference number to a list of of reference numbers and if it is in the list more than once out put -1. I have been working on this for ages but cannot seem to find a way of getting this to work. If any one has any suggestions I would be very greatful. Many Thanks -- ells2812 ------------------------------------------------------------------------ ells2812's Profile: http://www.excelforum.com/member.php...o&userid=32562 View this thread: http://www.excelforum.com/showthread...hreadid=523548 |
If Function
=if(countif(range,ref#)1,-1,"No multiple occurrences")
"ells2812" wrote: Hi, What I want to do is get excel to compare a reference number to a list of of reference numbers and if it is in the list more than once out put -1. I have been working on this for ages but cannot seem to find a way of getting this to work. If any one has any suggestions I would be very greatful. Many Thanks -- ells2812 ------------------------------------------------------------------------ ells2812's Profile: http://www.excelforum.com/member.php...o&userid=32562 View this thread: http://www.excelforum.com/showthread...hreadid=523548 |
All times are GMT +1. The time now is 11:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com