Skip to main content

Horizontal sorting

In Excel, you can sort data horizontally by using the "Sort Left to Right" option. To do this, select the range of cells that you want to sort, then go to the "Data" tab and click on the "Sort" button. In the "Sort" dialog box, select "Options" and then choose "Sort Left to Right". You can then specify the column that you want to sort by and whether you want the sort to be in ascending or descending order.
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