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

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

        Oh, too bad because I think PQ would be the best way to tackle the problem.

         

Resources