Forum Discussion

Rikki22bb's avatar
Rikki22bb
Copper Contributor
Jun 14, 2019

Excel Help

I want a cell with a Data Validation list to populate one of the list options if another cell/series count equals more than “0”(zero).....
excel
Formulas and Functions

6 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 14, 2019
    Please cite an example of the data and result you want.
    • Rikki22bb's avatar
      Rikki22bb
      Copper Contributor
      Jun 14, 2019
      Column V: =Countif(G7, “>$0”)
      Column W: Data Validation list with 8 options

      I want Column W to populate the first option from the list “Opportunity” IF the prior cell is greater than zero.
      .... (pls see attached picture if you can as my symbols appear to adjust above once I post this message)


      Just for reference, I am only “okay” at Excel so please give me laymen’s instructions if you can 😬 ty for your help!!
      • PReagan's avatar
        PReagan
        Bronze Contributor
        Jun 14, 2019
        Hello Rikki,
        It appears that your attached picture has not been uploaded. Could you try to re-upload your example?

Resources