Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count missing field
i have to fill sheet row wise.
data related to certain column are important to fill (say C,D,F & K column) i want to do following things as i start filling a row (say row 2), in B2 it should display 4( because 4 mandatory cells are still to fill i.e. C2,D2,F2 & K2) Now if i fill C2 , B2 should be 3 (because only mandatory 3 are still to fill ) similarly if D2 is filled,B2=2 so on & so fourth... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count missing field
Hi,
Try this in B2 =4-COUNTA(C2,D2,F2,K2) Mike "aditya" wrote: i have to fill sheet row wise. data related to certain column are important to fill (say C,D,F & K column) i want to do following things as i start filling a row (say row 2), in B2 it should display 4( because 4 mandatory cells are still to fill i.e. C2,D2,F2 & K2) Now if i fill C2 , B2 should be 3 (because only mandatory 3 are still to fill ) similarly if D2 is filled,B2=2 so on & so fourth... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count missing field
something like this should work:
=4-COUNTA(C2,D2,F2,K2) As C, D, F, and K are filled in, counter will decrease to zero. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "aditya" wrote: i have to fill sheet row wise. data related to certain column are important to fill (say C,D,F & K column) i want to do following things as i start filling a row (say row 2), in B2 it should display 4( because 4 mandatory cells are still to fill i.e. C2,D2,F2 & K2) Now if i fill C2 , B2 should be 3 (because only mandatory 3 are still to fill ) similarly if D2 is filled,B2=2 so on & so fourth... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table field missing | Excel Worksheet Functions | |||
Pivot table field list missing | Excel Discussion (Misc queries) | |||
Missing NUMBERS button in PivotTable Field Settings | Excel Worksheet Functions | |||
Missing Grand Total for a Calculated Field in a Pivot Table | Excel Worksheet Functions | |||
Field missing on completed mail merge Excel - Word once merged | Excel Discussion (Misc queries) |