Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT
Hi, i want to count rows, but only when i write something.
In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |