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: 1
Default How to detect negative value cells from large size of data

Can anyone suggest how to detect Cells containing negative values form large size of data approx. having 100 columns and rows because filtering the data 100 times not make sense.

Thanks
Abhishek
 
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
How To Detect A Negative Number In A Cell Minitman Excel Worksheet Functions 7 March 13th 08 04:12 PM
automatically numbering cells for large data from other sheets chichi0918 Excel Programming 2 June 15th 07 06:59 PM
Auto-detect range size shelfish Excel Programming 4 May 19th 06 10:21 PM
NPV Calc appears incorrect with a large # of negative cash flows MikeW Excel Worksheet Functions 1 September 1st 05 03:31 PM
Ploting data with a large range including negative numbers Hoochi Coochi Man Charts and Charting in Excel 1 April 28th 05 03:18 PM


All times are GMT +1. The time now is 03:57 PM.

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"