Skip to main content

FLASHFILL

Flash Fill is a feature in Microsoft Excel that allows you to automatically fill in a column or row with data based on a pattern or example you provide. It works by analyzing the data you've entered in one cell and then using that information to automatically fill in the rest of the column or row. Flash Fill can be a useful tool for quickly and easily cleaning and formatting data in a spreadsheet. To use Flash Fill, simply enter the data you want to use as the pattern or example in the first cell, and then press the Ctrl + E key combination. Excel will automatically fill in the rest of the column or row with the appropriate data.      
Labels:

Comments

Post a Comment

Popular posts from this blog

Get multiple lookup values in single cell

Post a Comment
Read more

Rupees into words

Option Explicit Function RupeesInWords(ByVal MyNumber As Double) As String Dim Rupees As String Dim Paise As String Dim Temp As String Dim DecimalPlace As Integer MyNumber = Round(MyNumber, 2) DecimalPlace = InStr(MyNumber, ".") If DecimalPlace > 0 Then Rupees = Left(MyNumber, DecimalPlace - 1) Paise = Mid(MyNumber, DecimalPlace + 1) Else Rupees = MyNumber Paise = "" End If RupeesInWords = "" If Val(Rupees) > 0 Then RupeesInWords = ConvertToWords(Rupees) & " Rupees" End If If Val(Paise) > 0 Then RupeesInWords = RupeesInWords & " and " & ConvertTwoDigits(Left(Paise & "00", 2)) & " Paise" End If RupeesInWords = Application.WorksheetFunction.Trim(RupeesInWords) & " Only" End Function Private Function ConvertToWords(ByVa...
Post a Comment
Read more