+ Reply to Thread
Results 1 to 6 of 6

Iferror or other formula

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    Jakarta
    MS-Off Ver
    Excel 2010
    Posts
    32

    Question Iferror or other formula

    Dear All,

    I need help to pull january data based on one column.

    i attached the file.
    what i want is, if i put january in yellow highlight all january data will be show up and if i change the yellow highlight to february then only february data will be all february only.

    thank you and waiting for your expertise help

    sorry
    Attached Files Attached Files
    Last edited by sarahqputra; 02-11-2015 at 06:41 AM.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Iferror or other formula

    Hi Sarahqputra

    where is the attachment ??
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    03-04-2014
    Location
    Jakarta
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Iferror or other formula

    i just attached, sorry before

  4. #4
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Iferror or other formula

    Hi Sarahquputra

    check out the attached file and I hope this will work perfectly as you want
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-04-2014
    Location
    Jakarta
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Iferror or other formula

    thank you masterrrrr

  6. #6
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Iferror or other formula

    Hi Sarahquputra

    Welcome ! Glad to help you

    please don't forget to mark the thread as SOLVED and plz click on Add Reputation to say Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Iferror formula
    By Terisammis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2014, 03:05 PM
  2. [SOLVED] IFERROR and IF together in same formula
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2013, 09:45 PM
  3. xlfn.IFERROR or IFERROR don't work in Excel 98-2003
    By dj_danu01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 02:53 AM
  4. IFERROR Formula HELP PLEASE
    By jonnykhan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2013, 09:52 AM
  5. [SOLVED] #DIV/0 IFERROR formula
    By rlkerr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 10:33 AM

Tags for this Thread

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