| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula (visible cells only)
Need assistance editing the following if formula in excel 2003 to only show
the count for visible cells only and ignores any hidden rows. =IF(J2=J1,K1+1,1) The formula checks to see if the value in J2 equals J1, if true a + 1 is added from K1 and entered into cell K2. If false the count is returned to 1. The formula is entered K2:K2211. See below: K2: =IF(J2=J1,K1+1,1) K3: =IF(J3=J2,K2+1,1) K4: =IF(J4=J3,K3+1,1) Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| Formula only for visible Cells | Excel Discussion (Misc queries) | |||
| When creating a formula how do you select only visible cells | Excel Discussion (Misc queries) | |||
| How can I get a formula to work on visible cells with autofilter? | Excel Discussion (Misc queries) | |||
| Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
Linear Mode
