Forum Discussion

Anonymous's avatar
Anonymous
Sep 12, 2018

HELP WITH COMBINING LARGE FORMULAS

Hello gurus!  I have attached my examples for you to look at to help my questions make sense.  I have two separate formulas that work for different parts of my overall Excel project.  One formula is ...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 12, 2018

Hi

 

First the ResultsTable is referring to another file Practice Data 2.xlsx which you didn't provide - thus resulting the formulas in #REF errors.

And second what exactly are you trying to do? What is the desired output?

 

 

  • Anonymous's avatar
    Anonymous
    Sep 12, 2018

    Hi!  Thanks for your response.  Please find Practice Data 2.xlsx attached.

     

    What I am trying to do is combine the two different formulas into one large formula.  I am trying to find out which candidate has the most job matches.

     

    I hope this helps!

     

    Ronna

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Sep 12, 2018

      Could you provide a sheet with the desired output (just the values)?

      Is Power Query available?

       

       

      • Anonymous's avatar
        Anonymous
        Sep 12, 2018

        Hi!  I've attached another workbook with the information I'm looking for on the green tab.  And no, I do not have Power Query.

         

        Thanks!

        Ronna

Resources