![]() |
#1
|
|||
|
|||
![]()
How do I make this Mode.sngl function to work only for visible rows?
=MODE.SNGL(IF($I$2:$I$5701=P2, IF($J$2:$J$5701=Q2,$L$2:$L$5701))) I will be grateful for your help Thanks |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tectonicseer | Excel Programming | 1 | 07-27-2014 11:54 AM |
a function that deletes all rows with no value in a certain column? | dunndealpr | Excel | 2 | 06-08-2013 06:50 AM |
![]() |
gsrikanth | Excel | 10 | 01-27-2012 05:29 AM |
![]() |
gsrikanth | Excel | 5 | 01-19-2012 02:40 PM |
![]() |
prg4hire | Word | 2 | 09-25-2010 09:46 AM |