Results 1 to 18 of 18

count and index issue

Threaded View

jw01 count and index issue 10-03-2012, 09:56 AM
NBVC Re: count and index issue 10-03-2012, 10:06 AM
Fotis1991 Re: count and index issue 10-03-2012, 10:11 AM
jw01 Re: count and index issue 10-03-2012, 10:26 AM
Dave H9 Re: count and index issue 10-03-2012, 10:07 AM
jw01 Re: count and index issue 10-03-2012, 10:25 AM
NBVC Re: count and index issue 10-03-2012, 10:28 AM
jw01 Re: count and index issue 10-03-2012, 11:04 AM
jw01 Re: count and index issue 10-03-2012, 11:22 AM
Tsjallie Re: count and index issue 10-03-2012, 10:46 AM
jw01 Re: count and index issue 10-03-2012, 11:56 AM
NBVC Re: count and index issue 10-03-2012, 01:19 PM
jw01 Re: count and index issue 10-03-2012, 02:13 PM
NBVC Re: count and index issue 10-03-2012, 02:27 PM
jw01 Re: count and index issue 10-03-2012, 02:57 PM
NBVC Re: count and index issue 10-03-2012, 03:12 PM
jw01 Re: count and index issue 10-04-2012, 09:30 AM
icestationzbra Re: count and index issue 10-04-2012, 09:47 AM
  1. #8
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    Re: count and index issue

    i used the formula

    however it appears is now in the "rps contest payout" sheet

    cell D19
    =IF(ROWS($A$1:A1)>COUNT('CSA detail breakdown'!$O$14:$O$1020),"",INDEX('CSA detail breakdown'!$D$14:$D$1020,MATCH(SMALL('CSA detail breakdown'!$O$14:$O$1020,ROWS($A$1:A1)),'CSA detail breakdown'!$O$14:$O$1020,0)))

    it is listing the names twice

    i have attached a sample update

    any way to work around this? thx u
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1