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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a large amount of data that I need to sort based on descending numerical order (the values are in column A), and the data is in table format—most of the data is text, and Excel won't sort the data all together because the cells are of a different size. I need the data that is in each row to stay together, because it is specific to that row—so I'm having a bit of trouble with this spreadsheet right now, and I don't know how to cleanly get the data sorted without having to manually sort it.
Solved by E. J. in 29 mins
Hi, I need your help with formula in finding out similar opposite values from a large data sheet basis a particular criteria. In the attached excel sheet row 1 and 5 are having similar opposite values.
Solved by A. J. in 28 mins
Hello, I would like to select a row (starting with row 2, because row 1 is a header row) and fill down 9 rows, then select the 12th row, fill down 9 rows, then select the 22nd row, fill down 9 rows, etc. So every 10th row is selected to fill down 9 rows. I have a large amount of data and would like to have this automated with a macro rather than do it manually, but I have only basic macro skills and am not able to figure this out. Help is much appreciated!
Solved by I. H. in 18 mins
I have a large pivot table of customers, I need to sum when there are new customers and in reverse, when customers leave. Not sure if this can be done through pivot table. I just can't figure out the best way to do this with a sumif formula
Solved by X. S. in 17 mins
Need to compare two large data sets in same work book, but different sheets. Need to see which Product Codes don't match and which do match, then need to export the 'do match list' on a separate sheet. Thanks
Solved by I. J. in 25 mins
I currently have a large worksheet with over 7,000 cells. I have listed regions under a column i named "Location." In that column I want to change the region from lets say "Eastern North Central" to "US-Midwest," "Mountain" to "US-West" and so on. Is there anyway I could use a function to enter under my location column so all regions change to my desired classifications so i don't have to manually change over 7,000 cells? Perhaps some convoluted IF function?
Solved by Z. J. in 11 mins
Need to improve existing code to accomodate multiple file extensions instead of just pdf xlsx etc... and to only run code once, instead of once per extension. My excel files are very large and I would like to set it to run and walk away so when i return it has finished searching for all extensions i specified and moved the lines to a new sheet. Here is the code and some snipits of code that may help. Keep in mind the following instructions: 1. "Source" sheet is the file that contains your database 2. You wil have to add a blank sheet to workbook and name it Destination 3. .pdf and .xlsx and more are the extensions extracted to Destination using this code. 4. Run the code once, all .pdf extension files will be xtracted to Destination, then run the same code again, all .xlsx will be extracted to Destination below the .pdf's Sub Extraction() Dim xRg As Range Dim xCell As Range Dim I As Long Dim J As Long I = Worksheets("Source").UsedRange.Rows.Count J = Worksheets("Destination").UsedRange.Rows.Count If J = 1 Then If Application.WorksheetFunction.CountA(Worksheets("Destination").UsedRange) = 0 Then J = 0 End If Set xRg = Worksheets("Source").Range("F2:F" & I) On Error Resume Next Application.ScreenUpdating = False For Each xCell In xRg If CStr(xCell.Value) = ".pdf" Or CStr(xCell.Value) = ".xlsx" Or CStr(xCell.Value) = ".xls" Or CStr(xCell.Value) = ".doc" Or CStr(xCell.Value) = ".docx" Then xCell.EntireRow.Copy Destination:=Worksheets("Destination").Range("A" & J + 1) xCell.EntireRow.Delete J = J + 1 End If Next Application.ScreenUpdating = True End Sub Code Snips for re-use To Search for Extensions in bulk Sub ConvertWordsToPdfs() Dim directory As String directory = "C:\Wordup" ' The starting directory Dim fso, newFile, folder, files Set fso = CreateObject("Scripting.FileSystemObject") Set folder = fso.GetFolder(directory) Set files = folder.files For Each file In files Dim newName As String newName = Replace(file.Path, ".doc", ".pdf") Documents.Open FileName:=file.Path, _ ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _ PasswordDocument:="", PasswordTemplate:="", Revert:=False, _ WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _ wdOpenFormatAuto, XMLTransform:="" ActiveDocument.ExportAsFixedFormat OutputFileName:=newName, _ ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, From:=1, To:=1, _ Item:=wdExportDocumentContent, IncludeDocProps:=True, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False ActiveDocument.Close Next End Sub OPENING MULTIPLE FILES Sub OpenMultipleFiles() Dim Filter As String, Title As String, msg As String Dim i As Integer, FilterIndex As Integer Dim Filename As Variant ' File filters Filter = "Excel Files (*.xls),*.xls," & _ "Text Files (*.txt),*.txt," & _ "All Files (*.*),*.*" ' Default filter to *.* FilterIndex = 3 ' Set Dialog Caption Title = "Select File(s) to Open" ' Select Start Drive & Path ChDrive ("E") ChDir ("E:\Chapters\chap14") With Application ' Set File Name Array to selected Files (allow multiple) Filename = .GetOpenFilename(Filter, FilterIndex, Title, , True) ' Reset Start Drive/Path ChDrive (Left(.DefaultFilePath, 1)) ChDir (.DefaultFilePath) End With ' Exit on Cancel If Not IsArray(Filename) Then MsgBox "No file was selected." Exit Sub End If ' Open Files For i = LBound(Filename) To UBound(Filename) msg = msg & Filename(i) & vbCrLf ' This can be removed Workbooks.Open Filename(i) Next i MsgBox msg, vbInformation, "Files Opened"' This can be removed End Sub
Solved by I. E. in 21 mins
In sheet 1 there is a large database containing 2000 names with their TXPDate and MRN. In sheet 2, there is a list of names with empty spaces for MRN and TXPDate. I need to fill the empty spaces in sheet 2 with the data from Sheet 1 with the Last Name as the common reference
Solved by X. C. in 21 mins
In sheet 1 there is a large database containing 2000 names with their TXPDate and MRN. In sheet 2, there is a list of names with empty spaces for MRN and TXPDate. I need to fill the empty spaces in sheet 2 with the data from Sheet 1 with the PTName as the common reference
Solved by C. U. in 14 mins
I have a large list of people with a list of sessions that each of them are attending a large group of sessions (indicated by a session ID). I would like a way to showcase each session ID and underneath it, list what names are attending.
Solved by X. F. in 21 mins