Here are some problems that our users have asked and received explanations on
Want help for IF, OR, AND functions for large data base. Unable to prepare a correct logic with IF, OR, AND function in excel. Please help.
Solved by B. H. in 27 mins
I have one large trade blotter worksheet, and a couple smaller worksheets with different data that needs to be in the large worksheet. I need a function to make sure none of the smaller data is missed in the larger worksheet. Vlookup wont work because data is not in the same format
Solved by G. Y. in 19 mins
Hi, I need help with the 'MATCH FUNCTION' I have a very large data set and trying to extract data from there.
For ex: if user enters 'W14x38' and excel should get all stuff related to section (area, length, width, etc)
Solved by A. L. in 17 mins
how to copy/paste large data from applied filters in excel
Solved by Z. B. in 13 mins
I use LARGE functions the top 20 data points from a table. I then index/match other data for the same row as each data point. If there are duplicates in the column for the LARGE function, how do I avoid those duplicates when index/matching?