Results 1 to 23 of 23

how to use my dropdown list

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    28

    how to use my dropdown list

    hello ,

    i have dropdown list witch is "date" in cell A1
    in cell C1 i put number witch is "money"

    d1:d100 i have "dates"
    e1:e100 should get the data from c1

    so i use in e1:e100
    =IF(a$1=d1,c$1,0)
    =IF(a$2=d2,c$1,0)
    etc ...

    my problem is that i can use it only for 1 date
    i want to choose date from my dropdown list put money and then choose another date and put money

    sorry about my english .
    and thx
    moshelog
    Last edited by moshelog; 04-28-2012 at 02:11 PM.

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