LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DCR DCR is offline
external usenet poster
 
Posts: 3
Default Counting blank cell issue

I need to count the number of orders that have not been reviewed yet. I have
been using countblank(O43:O5687). this works as long as some one updates the
formula when new orders are added. I am thinking I want a macro that will
find the last row using the order number in column A , then count the blank
cells in column O for order review, and also count the blank cells in
column t for outstanding orders.

Thanks
Clayton


 
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
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) foofoo Excel Discussion (Misc queries) 3 February 20th 12 08:03 PM
counting unique items within categories - but EXCLUDING blank cell Btaylor64 Excel Worksheet Functions 5 October 9th 08 05:01 PM
counting blank cell in pivot table violet Excel Worksheet Functions 3 April 23rd 07 04:24 AM
Summing (or counting) cells until there is a blank cell Box815 Excel Discussion (Misc queries) 3 November 17th 06 03:35 PM
Counting cells with blank adjacent cell Wingman Excel Worksheet Functions 4 November 16th 06 09:39 PM


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