• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    need help..index and match..

    i didnt know wheres the problem..this is the formula in the cell.. =IF(ISERROR(SMALL(IF(B1:B11=C3,ROW(B1:B11)),COLUMN(A1:A11))),"",INDEX(A1:A11,SMALL(IF(B1:B11=C3,ROW(B1:B11)),COLUMN(B1))))
  2. K

    need help..index and match..

    A B C D E F G H 1-Feb PUBLIC HOLIDAY SATURDAY 10/02 20/02 21/02 23/02 27/02 10-Feb SATURDAY SUNDAY 15/02 22/02 24/02 26/02 #NUM! 15-Feb SUNDAY PUBLIC HOLIDAY 01/02 #NUM!<--- Can sumone xplaine this? 20-Feb SATURDAY...
  3. K

    need help..index and match..

    i've tried it both formula from Hui and xld, thanks alot. the result only appears 1 result. Saturday 10/2 Sunday 15/2 Public Holiday 01/2 can it show all dates in the same cell like example: Saturday 10/2,20/2,21/2,23/2,27/2 Sunday 15/2,22/2,24/2,26/2 Public...
  4. K

    need help..index and match..

    1-Feb PUBLIC HOLIDAY 10-Feb SATURDAY 15-Feb SUNDAY 20-Feb SATURDAY 21-Feb SATURDAY 22-Feb SUNDAY 23-Feb SATURDAY 24-Feb SUNDAY 25-Feb 7:30 - 4:30 PM 26-Feb SUNDAY 27-Feb SATURDAY From these data, i use this formula '=INDEX(A1:A11,MATCH("SATURDAY",B1:B11,0)) and the result shown...
  5. K

    Hello .. Introduce yourself

    Hello, im kyrel from Malaysia, every excel work i've done is refering to this site. its very useful. always been here to look for sumthing for learning. hope can learn more in excel.
Back
Top