Trying to come up with a way to evaluate my sample and find the 10 best matches to a given data set.
Included is my Exel file and also a link to video explaining the problem
https://screencast-o-matic.com/watch/cr66hVVX3Q3
I'm currently looking into using aggregate function as that may make this a bit easier for me.
Not looking anyone to "solve" this for me but more so point me in the right direction or give me some ideas. ( unless it's just something dumb and simple that I haven't thought of and it's a matter of small formula.)
Thanks
MTS
After watching my video I think maybe some kind of mad sum product validation might work.....
Got it solved. It's amazing how taking a day away from a problem, and right after asking for aid seems to crank the creative juices into over drive. If anyone has a similar issue and would like to see my solution, please let me know and I'll post a follow up.
Also, while I'm here, I was wondering what kind of jobs there are out there using excel?
Would like to change industries ASAP.
Thanks
MTS
Glad you solved it yourself, Matthew!
There are tons of jobs using Excel skills. Probably easiest to do a search on Excel as a keyword on a job search site to get an idea in your area.
All the best.
Mynda
awesome stuff. thanks for everything and your youtube channel.
keep up the great work!
