Get instant live Excel expert help to learn how to use Large function?
“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
Large file having issues with formula in 1 of the tabs. The formula populating is a realllly long file path.
Solved by K. A. in 22 mins
So I have a large list of data, around 1700 rows. It is all text but some of it has spelling and grammar problems. I have done a spellcheck to solve this which has mostly worked, but there are some words in all caps that haven't been corrected, is there any way i could solve this as going through manually would take too much time
Solved by G. E. in 29 mins
I need to format a large list of dates to look the same without hard coding. some of them are typed in the formula bar as 9/10/2016 and appear as 9-october-16 but some of them are typed in the formula bar as 9-october- 16 but appear to have an error and are a bit further to the right than the other dates.
Solved by A. Q. in 24 mins
I need to subsample a large data set. My dataset has about 90,000 lines and I make a smaller set taking every 6th line so I have no more than 15,000 lines.
Solved by X. L. in 16 mins
I need the ratio of males vs females in a excel sheet with a large list of companies
Solved by V. W. in 23 mins
I need to compare values from one table to values from another table in large quantities
Solved by Z. D. in 25 mins
I have been putting together a large Excel workbook with may linked pdfs. Everytime I move the it to a new computer or give it to someone I have to relink each file (hundreds). Is there anyway to change all the path names to the linked files at once so that I don't have to spend hours relinking the pdfs manually?
Solved by B. H. in 11 mins
I have been putting together a large Excel workbook with may linked pdfs. Everytime I move the it to a new computer or give it to someone I have to relink each file (hundreds) in Excel. Is there anyway to change all the path names that are stored in Excel to the linked files at one time so that I don't have to spend hours relinking the files to Excel? manually?
Solved by F. E. in 29 mins
i need to make a graph using a large number of data sets, i dont know where to start
Solved by Z. Y. in 13 mins
I have a large file (2,000 rows by 60-70 columns) with plenty of formulas and comments and when I tab from one cell to another it takes 2 to 3 seconds to move from one cell to the other but this is not consistent across the rows. In some cases there is quite a delay and in others there is no delay. I've tried several different things and can't figure this out
Solved by I. J. in 27 mins