Get instant live expert help on how do matches work
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to cross-reference two long columns with names, some of which are exact matches and some of which are partial matches, and then associate values from a third column, which are normally tied to the 2nd column, to the 1st column where matches between the names occur.
Firstly, how closely do the names need to match in order for this to work? Secondly, how do I do this? Thanks!
Solved by M. B. in 11 mins
Working on the destination sheet
How do I do this
If a cell content in column AR matches with any other AR then insert
E into P
F into Q
I into R
And what if it matches more than one cell?
Solved by V. L. in 16 mins
Hi how do you do a compare of the 2 columns in different spreadsheets and get a result of matches with yes or no. The spreadsheets are large and the column information varies
Solved by I. D. in 12 mins
How do I work out the an average across multiple worksheets
Solved by B. C. in 28 mins
How do I make a spread sheet for work at at a hospital?
Solved by T. E. in 13 mins