Forum Discussion
Anonymous
Sep 12, 2018HELP 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 ...
Anonymous
Sep 12, 2018Hi! 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
Sep 12, 2018Silver Contributor
Could you provide a sheet with the desired output (just the values)?
Is Power Query available?
- AnonymousSep 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_LewinSep 12, 2018Silver Contributor
Oh, too bad because I think PQ would be the best way to tackle the problem.
- AnonymousSep 12, 2018
Hmm. Could you please send me the PQ information anyway? My co-worker has used that before (I think) and he might be able to explain it to me.
Thanks!
Ronna